Red Gate forums :: View topic - Restore of DB with Full Text Catalogs
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Restore of DB with Full Text Catalogs

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dabrough



Joined: 03 Jun 2013
Posts: 1

PostPosted: Mon Jun 03, 2013 11:22 pm    Post subject: Restore of DB with Full Text Catalogs Reply with quote

Had a situation where I had to restore a DB to another server that contained a number of Full Text Catalogs. These show up in the file structure as additional files with data, looks like no problem.

The problem was that SQL Backup generated the script for the restore with incorrect file names for the Catalogs only. All of the normal data and log files were created correctly, the name for the object was correct, the only problem was the file name.

This primarily caused a problem when the generated file name matched another file name for a secondary data file. The restore then failed, which is I guess good. Once found the problem and cleaned up the file names, the restore worked fine.

Anyone else come across this issue?
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Wed Jun 05, 2013 7:55 am    Post subject: Reply with quote

Thanks for your response in this matter.

Are you able to send me the following info via the associated support call:

1) Run the restore filelistonly command for the associated backup file and the output?
2) The restore command and the associated output?

Also let me know how have you generated the restore command when you have executed this in the past? via the GUI or you have been running the TSQL via SSMS?

Thanks for your response in this regards.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group