Restore a database with LDF file only
- by Martin
First of all, i know how stupid it is not to have a any backup. I can't help it, but i have to (try) to solve it.
I have a transaction log (LDF) file from a SQL Server 2000 database that contains all transactions since the creation of the database. No truncation has been done. The MDF file is gone. Probably because of some disk failure. There is no backup. Not from the original database and not from the transaction log.
I have tried to link the transaction log to a new clean database. But (ofcourse) that failed because SQL Server checks the identity of both files.
I have read about software that can read the transaction log. ApexSQL seems to do that. I tried to install the trial version but it gives weird errors when trying to start the program.
Anyone knows a solution for me? It may contain third party software, but i prefer a clean SQL Server solution.