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

Posted on 2007-08-10
Last Modified: 2010-03-19
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:
Question by:priehl
    LVL 11

    Expert Comment

    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.
    LVL 4

    Expert Comment

    LVL 4

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now