Click here to Skip to main content
15,921,622 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
When i am trying to restore a database it gives me error-
SQL
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
Updated 1-Oct-12 1:29am
v2
Comments
Ubaid ur Rahman IT 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

add ldf file...
C#
using
 add file 
(
name="ldf1";
filename="path\ldf1";
)


this will help you.....
 
Share this answer
 
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900