Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We had a drive die and lost the ldf file, but the mdf file is in tact. Is there a process for re-connecting to the mdf file, considering the ldf lost? I have searched without much luck.

share|improve this question
up vote 1 down vote accepted

Check this. It is explained how to recover the database.

share|improve this answer
I'm marking this correct because we had Microsoft Support on the box, and this was basically what they did. Plus they executed the rebuild log command here:… – Tom Lianza Jan 7 '11 at 2:53

Yes, you can try detaching the database and attaching it using the sp_attach_single_file_db system stored procedure. This will generate a new transaction log file for you. If this procedure fails, you will need to restore from your backup.

share|improve this answer
if there was an active transaction than SQL will not be able to create a new log file knowing that a transaction was not committed and the attach will fail. It will be much harder after a detach to attach a corrupted database. The easy way is to use emergency mode. Much safer. – yrushka Jan 4 '11 at 10:37

but the mdf file is in tact

Yes, but not consistent. Data files are not kept consistent between checkpoints - this is why you need an LDF file.

I suggest a backup. While you MAY be lucky with the sp_attach_single_file_db it is 99.9% a data loss involved.

share|improve this answer

Your Answer


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.