Recovering lost SQL Server 2000 data

Tags:
Data Recovery
LDF
MDF
Microsoft SQL Server 2000
SQL Server backup
I lost a LDF file for SQL server 2000 -- but I have the MDF. How can I recover my data?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Subhendu Sen
    One more guide here : http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html
    29,350 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following