How can we help you today? How can we help you today?

Restore backup WITH MOVE

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.
rvw
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.