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

"WKC" <wchen@eibilling.com> wrote in message
newsdtBb.9218$T24.3604173@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
>
>