MSSQLSERVER_3156

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

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

Reference

RESTORE (Transact-SQL)

Concepts

Restore a Database to a New Location (SQL Server)

Restore Files to a New Location (SQL Server)