MSSQLSERVER_3176
New: 12 December 2006
Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.00.1399 |
Event ID |
3176 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
LDDB_FILE_CLAIM |
Message Text |
File '%ls' is claimed by '%ls'(%d) and '%ls'(%d). The WITH MOVE clause can be used to relocate one or more files. |
Explanation
Attempting to use a file for more than one purpose.
Possible Causes
Another database is already using the file name.
User Action
Restore the database files to a different location. In a RESTORE statement, use a WITH MOVE clause to move each file. In SQL Server Management Studio, change the file locations in the Restore the database files as grid of the Restore Database Options dialog box.
See Also
Other Resources
How to: Create a New Database From an Existing Database Backup (SQL Server Management Studio)
How to: Restore a Database to a New Location and Name (Transact-SQL)
How to: Restore Files to a New Location (Transact-SQL)
RESTORE (Transact-SQL)