Home > IT Answers > SQL Server > SQL Server error: Cannot find log file
SQL Server Ask the Experts
2,585 pts.
 SQL Server error: Cannot find log file
MDF, SQL Server database, SQL Server error messages, SQL Server errors, SQL Server logs
I am receiving the error, "cannot find log file." I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

Software/Hardware used:
ASKED: July 15, 2009  2:52 PM
UPDATED: July 15, 2009  5:30 PM
RELATED QUESTIONS
Answer Wiki:
When you attach the database you need to product the MDF, and LDF as well as any NDF files that were created. If you don't have the LDF you can attempt to attach just the MDF file using the sp_attach_single_file_db system stored procedure. If that doesn't work you'll need the origional LDF file that was with the MDF file on the original server.
Last Wiki Answer Submitted:  July 15, 2009  5:30 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Please provide SQL Server version details.

Troy Tate
 0 pts.