Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 deleted .ldb file by accident

Author  Topic 

reuben
Starting Member

1 Post

Posted - 2014-08-23 : 16:29:48
cannot attach database(.mdb file) without the missing .ldg log file.
is there a solution to this problem
thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-24 : 04:14:33
You can try the sp_single_attach_db procedure.


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-25 : 06:18:45
Check the mdb file was originally detached, as you may experience problems when using sp_single_attach_db procedure

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -