Home > IT Answers > Storage > Recovering lost SQL Server 2000 data
SQL Server Ask the Experts
2,585 pts.
 Recovering lost SQL Server 2000 data
Data Recovery, LDF, MDF, SQL Server 2000, SQL Server backup and restore
I lost a LDF file for SQL server 2000 -- but I have the MDF. How can I recover my data?

Software/Hardware used:
ASKED: August 3, 2009  6:47 PM
UPDATED: December 13, 2010  7:41 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  December 13, 2010  7:41 pm  by  Denny Cherry   0 pts.
All Answer Wiki Contributors:  Denny Cherry   0 pts. , Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 
Subhendu Sen
 22,035 pts.