If you have a backup of the database, restore it from the backup.
LDF file contains only the log records - that is not sufficient to recover or restore the database.
If the database is critical and if you don't have a backup, you might try some of the data recovery tools available - I have no experience with them, so don't know what the probability of success is.
LDF file is not sufficient to recover your corrupt database. As James K already suggested third party SQL Recovery Software to repair corrupt database. I have used Stellar Phoenix SQL Recovery Software to repair my corrupt database. Please check this link for more information about the software: http://www.stellarinfo.com/sql-recovery.htm
To restore your corrupt sql files database just try Kernel for sql database recovery tool that recover or repair all corrupt sql files from sql database. To know more visit: unspammed
You can restore it from backup file, but due to some reasons if fresh backup is not available or backup file is corrupt and damaged then use this helpful application (SQL Backup Recovery Software). With the help of this application you can restore entire backup of SQL Server database in just few seconds. If you have any problem related to run this application then visit at: unspammed
Data File Restoration
Posted - 01/20/2013 : 01:49:25
