Skip to content

Latest commit

 

History

History
40 lines (33 loc) · 1.57 KB

File metadata and controls

40 lines (33 loc) · 1.57 KB
title MSSQLSERVER_3176
description MSSQLSERVER_3176
author MashaMSFT
ms.author mathoma
ms.date 04/04/2017
ms.service sql
ms.subservice supportability
ms.topic reference
helpviewer_keywords
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)