January 10, 2009 at 11:12 am
I have been fighting to get sql server 2005 and management tools installed on PC. I finally was able to get the software installed. But when I try to restore a database using the SQL Management Tool I get the error message "System.Data.SqlClient.SqlError: Directory lookup for the file "D:\data1\database\MSSQL\Data\ITMS_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)"
I have a feeling my install of SQL server and management tool is not complete or correct.
Has anyone fun into this problem?
January 10, 2009 at 12:04 pm
But when I try to restore a database using the SQL Management Tool I get the error message "System.Data.SqlClient.SqlError: Directory lookup for the file "D:\data1\database\MSSQL\Data\ITMS_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)"
During the restore goto the Options page and change the Restore As for both the data and log files. For example, change to C:\data\mydb.mdf and c:\data\mydb_log.mdf.
By default the original path for the data and log files are used in a restore.
April 12, 2009 at 11:49 pm
But what if you don't have any .mdf file or an associated .log file, let alone the path.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply