Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
    
i'm curious as to how you came to have an ldf file without an mdf file. As far as i am aware, you are pretty well out of luck. If you have solved this, let us know how! –  DForck42 Jan 16 '13 at 22:22

1 Answer 1

So how did the MDF go away? Did the data drive get corrupted or fail?

Outside of using a third-party tool, you don't have many options.

About the only thing I can think of doing is attaching the LDF to a dummy database and then taking a tail of the log backup. But even then, it doesn't buy you anything.

Here's the basic process:

create database MyDatabase
go

-- run a full backup, this can be disgarded

alter database MyDatabase
set offline
go

-- go delete the mdf and ldf

alter database MyDatabase 
set online
go

backup log MyDatabase
to disk = 'C:\SQL Backups\MyDatabase-tail.trn'
with no_truncate
go

Now you have a LOG backup of your LDF file, but I'm not sure what you can do with it from there.

Maybe search for a product that lets you read a backup file...

Good luck!

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.