467,915 Members | 1,201 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Regarding reocvering data through corrupted ldf file

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
  • viewed: 1073
Share:
1 Reply
ck9663
Expert 2GB
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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by r.e.s. | last post: by
7 posts views Thread by Stuart McGraw | last post: by
9 posts views Thread by Matthew T. O'Connor | last post: by
3 posts views Thread by aka | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.