MSSQLSERVER_3156
New: 12 December 2006
Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.00.1399 |
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
Other Resources
How to: Create a New Database From an Existing Database Backup (SQL Server Management Studio)
How to: Restore a Database to a New Location and Name (Transact-SQL)
How to: Restore Files to a New Location (Transact-SQL)
RESTORE (Transact-SQL)