Sunday, September 5, 2010

Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\HTMLPDF.mdf" failed with the operating system error 3

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