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

Regarding reocvering data through corrupted ldf file

P: 1
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
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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.