Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Can Anyone tell me how to recover database in SQL Server 2005 using free (i mean not shareware) software that only using ldf file?

Thanxs before

share|improve this question

migrated from stackoverflow.com Jan 3 '10 at 9:15

This question came from our site for professional and enthusiast programmers.

1  
I may be rusty, but isn't ldf just the log file and no data? –  MandoMando Jan 2 '10 at 14:46
    
Duplicate: stackoverflow.com/questions/304824/… –  gbn Jan 2 '10 at 16:06

4 Answers 4

If you only have the LDF file (the transaction log), there's no way you can recover the database......

The transaction log file - as its name implies - only contains the transactions that were run against your database in the past - since the last full backup of the log file. It does not contain the actual data that's stored in the database.

share|improve this answer

You can't. I'm deadly serious.

Your only option is to restore from a backup, which you have of course...?

share|improve this answer

Your question so much off, that I can only "point a finger to the moon", so start reading here.

share|improve this answer

A transaction log (the ldf) is just a file of transactions and the changes made by them all. Unless this transaction log contains every transaction since the very beginning of the original database's existence, it simply doesn't contain the information needed to even hypothetically recreate the source DB. Even if it did contain every change, I'm not aware of any software (especially not free software) that could recreate it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.