Log file lost - SQL Server Forums

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

General SQL Server Forums

Data Corruption Issues

Log file lost

Author

Topic

juliemac
Starting Member

12 Posts

Posted - 2008-07-10 : 13:23:02

How can I reattach a MDF with out the LDB?

I get the error message:
Server msg 3624, level 20, State 1, Line 1
location: recovery.c:2657
Expression: seenCkptEnd
Spid" 7

connection broken

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-10 : 14:46:57

With this Store proc.

sp_attach_single_file_db

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-07-11 : 02:43:47

You can...., but if the database wasn't shut down cleanly, you may get a corrupt database

--
Gail Shaw
SQL Server MVP

juliemac
Starting Member

12 Posts

Posted - 2008-07-11 : 05:17:08

Of 6 databases, this is the only one where the log file appears corrupt and will not reattach.

I tried the single file attach, but IIRC I still got errors.
With the single file do I reattach with the log file with in the folder or remove it?
I'll rerun it and post the errors when I get to work this morning.

juliemac
Starting Member

12 Posts

Posted - 2008-07-11 : 07:11:11

Ok. I still get the same error posted earlier when I try sp_attach_single_file.
Is the DB corrupted? If so, what can be done to retrieve any of the data.

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2008-07-11 : 09:20:47

From Backup???

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-07-14 : 04:19:19