MSSQLSERVER_3156

Applies to: yesSQL Server (all supported versions)

Details

Attribute Value
Product Name SQL Server
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)