MSSQLSERVER_3176

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

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

Reference

RESTORE (Transact-SQL)

Concepts

Restore a Database to a New Location (SQL Server)

Restore Files to a New Location (SQL Server)