Problem with LDF files ( database log file )
-
Hi there . I have a problem with SqlServer 2005 Log file . I have an application and i want to attach my database to SqlServer , I did it by SqlConnection and ConnectionString ,in many times it gives me an error. I know that when we use AttachDbFilename property in Connection for attach DB we don't need database log file, But most of times it gives me this error:
"Unable to open physical file 'filpath_log.LDF'. Operation system error 5: "5(error not found)". Could not open new database 'DbName'. CREATE DATABASE is aborted. Cannot attach the file 'FilPath.mdf' as database 'DbName'. File activation failure. The physical file name 'filpath_log.LDF' may be incorrect. The log cannot be rebuilt when the primary file is read-only.'I wonder to say sometimes attachment works but sometimes not.:wtf: I already did this attachment process with SQLServer 2000 and it never gives me error X| .DMASTER
-
Hi there . I have a problem with SqlServer 2005 Log file . I have an application and i want to attach my database to SqlServer , I did it by SqlConnection and ConnectionString ,in many times it gives me an error. I know that when we use AttachDbFilename property in Connection for attach DB we don't need database log file, But most of times it gives me this error:
"Unable to open physical file 'filpath_log.LDF'. Operation system error 5: "5(error not found)". Could not open new database 'DbName'. CREATE DATABASE is aborted. Cannot attach the file 'FilPath.mdf' as database 'DbName'. File activation failure. The physical file name 'filpath_log.LDF' may be incorrect. The log cannot be rebuilt when the primary file is read-only.'I wonder to say sometimes attachment works but sometimes not.:wtf: I already did this attachment process with SQLServer 2000 and it never gives me error X| .DMASTER
What are you trying to do ????? Load a log file via a connection ????
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]
-
Hi there . I have a problem with SqlServer 2005 Log file . I have an application and i want to attach my database to SqlServer , I did it by SqlConnection and ConnectionString ,in many times it gives me an error. I know that when we use AttachDbFilename property in Connection for attach DB we don't need database log file, But most of times it gives me this error:
"Unable to open physical file 'filpath_log.LDF'. Operation system error 5: "5(error not found)". Could not open new database 'DbName'. CREATE DATABASE is aborted. Cannot attach the file 'FilPath.mdf' as database 'DbName'. File activation failure. The physical file name 'filpath_log.LDF' may be incorrect. The log cannot be rebuilt when the primary file is read-only.'I wonder to say sometimes attachment works but sometimes not.:wtf: I already did this attachment process with SQLServer 2000 and it never gives me error X| .DMASTER
hello friend where u get the back of data base it is not saved full some thing is missing so again take back up and there is no error tell me how to creat database with sqlscript or enterprisemanager if u take backup of enterprisemanager is best this is the step (1) open Enterprisemanager (2) right click on database name (3) All Task (4) Attach database (5) MDF File database to attach (Browse the path) (6) click mdf file and ok button you have succesfully attach in the server database then your problem is solve connection to database coding have a nice day