Deleted .LDF File how can the database be brought back online

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steven Scaife (anonymous_at_discussions.microsoft.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 05:06:27 -0700

Ok this morning one of the IT guys deleted the LDF file
from the server for a particular database. The file was
45 gig, he stopped the server then deleted the file,
without detaching the database.

We tried running sp_attach_db @dbname='', @physname=''

filling in the blanks but that refused to work.

We still have the 65 gig MDF file but we get error 9004
when we try to attach using enterprise manager.

We saw a knowledge base article saying to install service
pack 3a will this solve the problem, don't necessarily
want to mess about with these things unless absolutely
necessary

I will be very grateful is someone tells me how to sort
this and doesn't say i'm up the creek without a paddle

thanks in advance

Relevant Pages

  • Flat File Backup Failed *suddenly*
    ... DB: SQL Server 2000 SP3a ... I have a database maintenanec plan set up to do full database backup (i.e. ... I have a DB which has a 3.8GB LDF file which backup with no problems!) ...
    (microsoft.public.sqlserver.server)
  • Flat File Backup Failed *suddenly*
    ... DB: SQL Server 2000 SP3a ... I have a database maintenanec plan set up to do full database backup (i.e. ... I have a DB which has a 3.8GB LDF file which backup with no problems!) ...
    (microsoft.public.sqlserver.server)
  • two .ldf files
    ... We have a server that have several individuals having sa ... permissions on the box. ... There used to be database that had 1 log .ldf file. ...
    (microsoft.public.sqlserver.server)
  • priv1.edb keeps growing / increasing - 2 gig in 1 day so far
    ... I got in the office this morning and noticed my database ... It is now almost 2 Gig higher than normal and I ... have tried restarting the IS. ... server. ...
    (microsoft.public.exchange2000.information.store)
  • Re: Help, I cannot attach my database again
    ... but unfortunately I do not have the old log file. ... but after I restarted the server it is gone. ... > First Attach the database with the old LDF file. ...
    (microsoft.public.sqlserver.server)