MSSQLSERVER_3176

Details

Product Name

SQL Server

Product Version

10.0

Product Build Number

-

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.