I have been using this little trick for some time now.
The other day I had to restore a backup to a database with full text indexes.
First we need to know the files included in the backup.
1: RESTORE FILELISTONLY FROM DISK='C:\backup.bak'
Next we need to move the additional files to another location.
1: RESTORE DATABASE myDatabase FROM DISK = 'C:\mybackup.bak' WITH REPLACE,
2: MOVE 'ftname_ft' TO 'c:\newpath\ftname.ft'
2 comments:
Thanks! I know it's an old post but it really helped me out!
Helped me as well. Thanks!
Post a Comment