Restore backup WITH MOVE

rvw

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.

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.