MSSQLSERVER_3176
Applies to: SQL Server
Details
Attribute | Value |
---|---|
Product Name | SQL Server |
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
Restore a Database to a New Location (SQL Server)
Restore Files to a New Location (SQL Server)
RESTORE (Transact-SQL)