Guys,
I got this error when I was restoring one database on mssql 2005(win 2003). I have tried to override the DB but still got the error message. I have changed the path and then successfully restored it since error is giving the clue :)
Error :
======
System.Data.SqlClient.SqlError: Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\HTMLPDF.mdf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Express.Smo)
======
Exact path for my system(Try to find out the paths of those files/You can make new files[May be inside the plesk directory]) :
=====
C:\Program Files (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\Data\dbname.mdf
C:\Program Files (x86)\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\Data\dbname.LDF
=====
Note : You'll get it at the "option" of the windows tool. You can refer the following URL.
======
http://www.linglom.com/2008/01/12/how-to-backup-and-restore-database-on-microsoft-sql-server-2005/
======
Note : You can create/backup/restore the DB at the mssql 2005 management area.
Try :)
No comments:
Post a Comment