Options
Restore backup WITH MOVE
rvw
Posts: 14
I'm trying to restore a backup, but get the following error. How can I restore a backup WITH MOVE?
PRD001: Restore - Failed
========================
Restoring full backup - Failed
This operation failed with errors.
Restoring testdb (database) from:
C:\share\FULL_(local)_testdb_20080601_000256.sqb
SQL Server error
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3176: SQL error 3176: File 'C:\databases\MSSQL\Data\test_1' is claimed by 'sysft_pli'(65538) and 'sysft_TestValue'(65537). The WITH MOVE clause can be used to relocate one or more files.
SQL Backup exit code: 1100
SQL error code: 3176
Updating SQL Server information - Pending
Operation pending.
Comments
I think that this message is caused by some full-text catalogs in a SQL Server 2005 database. If the drive layout on the server that you want to restore to doesn't match the database's original, then you have to remember to move the full-text catalogs as well as the data and log files. Please see our knowledge base for more information.