Last post May 23, 2018 01:36 PM by JohnsonWelch
May 17, 2006 12:09 AM|blg2|LINK
I had to replace my hard drive which was going bad. I reinstalled Sql 2005 and now need to restore the backup that I have. I selected Restore Database and chose From Device, and selected the backup location on J: drive and selected the backup file which
has no extenstion. I checked the checkbox next to the backup set to restore. Click OK and then I get this error message:
Restore failed for Server
System.Data.SqlClient.SqlError: Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL\data\MyDB_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)
I don't know why it is looking for a MDF file as this was never in the Backup folder. Can someone please help me on this? I thought I was doing the right thing making a backup all along and now I can't restore it!
May 17, 2006 03:29 AM|Atrax|LINK
May 17, 2006 11:56 PM|blg2|LINK
May 14, 2018 09:13 AM|101Geek|LINK
There is third-party software that can help you some way, MiniTool ShadowMaker is a good option for all choices. It has just updated to the latest version of 2.0/
May 23, 2018 01:36 PM|JohnsonWelch|LINK
In the restore dialog, go to options and change the path of the file under Restore As to a valid path.