Jeremy Wadsworth
My Contribution to the ASP.NET Community


Welcome   
Welcome to my personal website. Here you will find blog posts related to web development as well as personal related interests. If you're here for the source code to my Personal Web Site Kit, please register and you'll receive an email when your account has been approved.


Latest Blog Entries

 Thursday, August 14, 2008


Attach database failed for Server computername\SQLEXPRESS    

The error I received.

Attach database failed for Server 'COMPUTERNAME\SQLEXPRESS'.  (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Directory lookup for the file "C:\Data\WebHelp\help_log.ldf" failed with the operating system error 2 (The system cannot find the file specified.). (Microsoft SQL Server, Error: 5133)

This error occurred for me when I tried to attach and SQL Server was looking for an existing log file (.ldf). I was able to get around this by doing the following.

Opened up SQL Server Management Studio Express. Browsed to my database (.mdf) file. Once I set the file name to attach I selected the log file that was listed below the database file, and clicked the Remove button located just above the Cancel button.



jeremy at 11:32 PM | (24) Comments | Add a comment | Permalink







Join WebHost4Life.com






If you would like to help support this project, please click the button below to make a small donation.