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
 .mdf file at 0 bytes .ldf file at 6GB

Author  Topic 

apmeyers1987
Starting Member

1 Post

Posted - 2009-10-04 : 18:15:48
I have a server that crashed due to a backplane failure in a raid-5 setup. When the server came back online the .mdf file was at 0 bytes and the .ldf file was at 6GB. The really bad thing is that I don't have the data backed up with is a very bad call on me...had it set up but stopped it until our server went live and never re-activated it. Is there any way of recovering the data from the ldf file which seems to have the right amount of data for the database.

Thanks,
Andrew Meyers

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-10-05 : 03:07:25
Also asked here: http://www.sqlservercentral.com/Forums/Topic797603-357-1.aspx

--
Gail Shaw
SQL Server MVP
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-05 : 13:45:42
Seems like they've got you covered over at SQL Server Central already. I'd highly recommend getting on the phone with Microsoft and requesting the case to be Severity A. I'm not sure that they can recover the data for you, but it's at least worth a shot.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -