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
sql-server
|sql-server-2000
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