mssqlserver-3156-database-engine-error.md

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

MSSQLSERVER_3156

[!INCLUDE SQL Server]

Details

Attribute	Value
Product Name	[!INCLUDEssNoVersion]
Event ID	3156
Event Source	MSSQLSERVER
Component	SQLEngine
Symbolic Name	LDDB_CANT_WRITE
Message Text	File '%ls' cannot be restored to '%ls'. Use WITH MOVE to identify a valid location for the file.

Explanation

This general message identifies the logical or physical file names of files that could not be restored because of a problem with the specified location.

Possible Causes

The possible causes include the following:

• You might need access to the specified Windows directory.

• You might have mistyped the path or specified a path that does not exist.

• The file name might be being used by a file that cannot be overwritten.

User Action

Look at the error logs for other messages that provide more details.

Correct the problem with the specified location, for example, by granting access, or use the WITH MOVE option in your RESTORE statement to relocate the file.

See Also

Restore a Database to a New Location (SQL Server)
Restore Files to a New Location (SQL Server)
RESTORE (Transact-SQL)