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)