January 28, 2012 at 6:06 pm
I get the following error restoring a Database:
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportingHistory.mdf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'ReportingHistory' cannot be restored to 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportingHistory.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportingHistory_log.ldf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'ReportingHistory_log' cannot be restored to 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportingHistory_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any help would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 28, 2012 at 9:28 pm
please post the restore statement as well.
January 29, 2012 at 5:35 am
Does this folder exist?
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply