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)