By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,827 Members | 813 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,827 IT Pros & Developers. It's quick & easy.

Recover a corrupted LDF file

P: n/a
WKC
Recently, one of our database's mdf and ldf was corrupted. We were able to
bring back the database with the capability of importing and querying the
data. However, the data is not the full list. Some of the data are still
missing because the tables we want still has sone 'chain mis linkage' error
when we did a DBCC checkdb/checktable. DBCC couldn't fix those errors
either. We're pretty sure that there are some data still burry under the
corruption. Then we thought of the life LDF file. This file should have
recorded every transaction up to the point of failure. So we trying to
recover that file, but there are 2 problems. First is we don't have back up
of that file and 2nd, that file is also corrupted. I couldn't backup the
corrupted ldf file at its current state. It's giving me some unrelated error
message like disk space is out. All I know now is the only hope to recover
those missing data are in this LDF file. We tried to use this software from
Limingent Log Explorer to recover it. So far no such luck with that. So
I'm asking anyone who has similar experience or problem. Please let me know.
I need to know anyway to recover this LDF file, either by using sql server's
native tools or 3rd party tools. Any input is helpfull. thanks in advance.

Wei
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"WKC" <wc***@eibilling.com> wrote in message
news:Dd********************@news4.srv.hcvlny.cv.ne t...
Recently, one of our database's mdf and ldf was corrupted. We were able to
bring back the database with the capability of importing and querying the
data. However, the data is not the full list. Some of the data are still
missing because the tables we want still has sone 'chain mis linkage' error when we did a DBCC checkdb/checktable. DBCC couldn't fix those errors
either. We're pretty sure that there are some data still burry under the
corruption. Then we thought of the life LDF file. This file should have
recorded every transaction up to the point of failure. So we trying to
recover that file, but there are 2 problems. First is we don't have back up of that file and 2nd, that file is also corrupted. I couldn't backup the
corrupted ldf file at its current state. It's giving me some unrelated error message like disk space is out. All I know now is the only hope to recover those missing data are in this LDF file. We tried to use this software from Limingent Log Explorer to recover it. So far no such luck with that. So
I'm asking anyone who has similar experience or problem. Please let me know. I need to know anyway to recover this LDF file, either by using sql server's native tools or 3rd party tools. Any input is helpfull. thanks in advance.
Call, Microsoft Server Support. It's really your only chance at this point
I think.

Good luck

Wei

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.