Error when restoring a .bak file in SQL Server
Home > IT Answers > Storage > Error when restoring a .bak file in SQL Serve...
SQL Server Ask the Experts
2445 pts.
0
Q:
Error when restoring a .bak file in SQL Server
Backup & recovery, SQL Server backup, SQL Server errors
I’m having a problem restoring a .bak file in SQL Server. The .bak file is fine and good. But when I restore it, I get an error. It says " TITLE:
Restore failed for Server <servername>(Microsoft.SqlServer.Smo)

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Directory lookup for the file "C:Temp<databasename>.mdf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Smo)

My OS is in D drive. What should I do to restore the database successfully?
ASKED: Apr 10 2008  2:12 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
How did you restore the database, with T-SQL command or through SSMS? This error is likely to occur when network is unstable. But in your case it looks you're restoring a local database to the same server from a local backup. Have you checked the path and the "replace" option? If you used SSMS, please post your input in the restore dialogue window.
Last Answered: Apr 12 2008  1:04 AM GMT by Richard Ding, SearchSQLServer.   30 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0