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)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for