Click here to Skip to main content
11,415,074 members (74,241 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-server-2005 C#
When i am trying to restore a database it gives me error-
Restore failed for server "myServer". (Microsoft.SqlServer.Smo)
Additional Information : System.Data.SqlClient.SqlError : Directory lookup for the file "C:\Program Files\Microsoft Sql Server\MSSQL.1\MSSQL\DATA\myDbBkp.mdf" failed with the operating system error 3(error not found) (Microsoft.SqlServer.Smo)

plz help me!
Posted 1-Oct-12 2:27am
Edited 1-Oct-12 2:29am
Ubaid ur Rahman IT at 1-Oct-12 7:34am
Go to options at the left side of sqlserver.

Click options->Give the correct path as C:\........ and at last give as .mdf and in other box as .ldf

This will help u.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

add ldf file...
 add file 

this will help you.....

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 9,200
1 OriginalGriff 7,512
2 Maciej Los 3,710
3 Abhinav S 3,298
4 Peter Leow 3,084

Advertise | Privacy | Mobile
Web04 | 2.8.150427.4 | Last Updated 3 Oct 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100