Restore of DB with Full Text Catalogs

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Restore of DB with Full Text Catalogs

Postby dabrough » Mon Jun 03, 2013 11:22 pm

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?
dabrough
 
Posts: 1
Joined: Mon Jun 03, 2013 11:13 pm

Postby RajK » Wed Jun 05, 2013 7:55 am

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.
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests