Restore backup WITH MOVE

rvwrvw Posts: 14
edited June 6, 2008 10:05AM in SQL Backup Previous Versions
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.
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi,

    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.
    · Share on Twitter
Sign In or Register to comment.