Regarding reocvering data through corrupted ldf file

lavango

Dear All,


Actually we were not able to take the backup of mdf file, but we were able to take the backup of ldf file.
So we need to recover the data from that ldf file

Please provide us the steps or any tool so that we can recover the data and continue with the transactions.

Oct 14 '08 #1

ck9663

LDF is a transaction log file that SQL Server keeps for all updates on your database. In order for you to revert back these updates, you need your database first, otherwise there's nothing to be "reverted".

Find the latest backup of your database and restore it. Then use your transaction log to reflect the changes.

Here are some links that might help you.

http://sqlserver2000.databases.aspfa...log-files.html

http://blogs.techrepublic.com.com/datacenter/?p=132

-- CK

Oct 14 '08 #2