HELP! I deleted the log files for my db. I need to restore

The drive holding the logs was full w/ 60 gigs of logs.

I stopped the db and deleted the log files. Now i'm hosed Please help. No drive restore avail.

I still have the mdf files. I tried to detatch the db but can't due to log on error, tried to delete the db after moving the mdf file, unable due to log on error.

In a perfect world i would delete the db. Create a new one w/ the same privs and then replace the newly created mdf file.


Please help

when I try to delete i get the following.

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.


Failed to connect to server sql. (Microsoft.SqlServer.ConnectionInfo)


Cannot open user default database. Login failed.
Login failed for user 'path\user'. (Microsoft SQL Server, Error: 4064)

For help, click:
Who is Participating?
SvenTech Lead Web-DevelopmentCommented:
There is no hope for you I think. We had a similiar problem a few weeks ago when our raid system crashed completly and did not restore itself. We tried to restore the database with the .mdf and .ldf files, but this is not working even some user got this working in sql versions before 2000!

We luckily got the raid system working and restoring after a day or two and so could rebuild the data by restoring backups and logs.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.