Restore a database with LDF file only

Posted by Martin on Super User See other posts from Super User or by Martin
Published on 2012-11-28T08:27:55Z Indexed on 2012/11/28 23:06 UTC
Read the original article Hit count: 215

Filed under:
|

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.

© Super User or respective owner

Related posts about sql-server

Related posts about sql-server-2000