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 2000 Forums
 SQL Server Development (2000)
 Missssssing LDF

Author  Topic 

victorious
Starting Member

3 Posts

Posted - 2005-02-26 : 13:36:45
Hi! I have a huge problem.

I have deattached the database

I have four MDFs
H:\Data1.mdf
H:\Data2.mdf
H:\Data3.mdf
Q:\Data4.mdf

TRNs for the last three days
and a missing LDF.

How I can recreate the LDF?

Should I apply the same solution? Please HELP ME!!!

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-02-28 : 09:29:53
I think you want to explore the "single file attach" process (aka sp_attach_single_file_db SP in the MASTER DB)
Go to Top of Page

victorious
Starting Member

3 Posts

Posted - 2005-03-07 : 05:11:19
Problem solved. Thank you for the reply
Go to Top of Page
   

- Advertisement -