Edit

Share via


MSSQLSERVER_3156

Applies to: SQL Server

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)