Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005C#
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 1:27am
Edited 1-Oct-12 1:29am
v2
Comments
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
good
Please Sign up or sign in to vote.

Solution 1

add ldf file...
using
 add file 
(
name="ldf1";
filename="path\ldf1";
)
 
this will help you.....
  Permalink  
v2

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Shai Vashdi 480
1 Tadit Dash 305
2 Sergey Alexandrovich Kryukov 250
3 Peter Leow 190
4 OriginalGriff 163
0 Sergey Alexandrovich Kryukov 9,435
1 OriginalGriff 5,498
2 Peter Leow 4,230
3 Maciej Los 3,540
4 Abhinav S 3,353


Advertise | Privacy | Mobile
Web02 | 2.8.140415.2 | Last Updated 3 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid