mssqlserver-3176-database-engine-error.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
MSSQLSERVER_3176	MSSQLSERVER_3176	MashaMSFT	mathoma	04/04/2017	sql	supportability	reference	3176 (Database Engine error)

MSSQLSERVER_3176

[!INCLUDE SQL Server]

Details

Attribute	Value
Product Name	[!INCLUDEssNoVersion]
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 [!INCLUDEssManStudioFull], 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)