If the MDF isn't damaged you should be able to attach the MDF without the LDF using the sp_attach_single_file_db system stored procedure. This will generate a new log file when it attaches the database.

If this works without issue run a DBCC CHECKDB to ensure that there aren't any problems with the database.

Keep in mind that you may have transactions that were in-flight and half committed which will remain in that state as the database can't rollback the transaction without the log.

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window