SQL Server error: Cannot find log file
Home > IT Answers > SQL Server > SQL Server error: Cannot find log file
SQL Server Ask the Experts
2445 pts.
0
Q:
SQL Server error: Cannot find log file
SQL Server logs, SQL Server error messages, SQL Server errors, SQL Server database, MDF
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?
ASKED: Jul 15 2009  2:52 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jul 15 2009  5:30 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Troy Tate   0 pts.  |   Jul 15 2009  5:08PM GMT

Please provide SQL Server version details.

 
0