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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 20:02:59 +0200

> You also need to seriously suggest firing that IT guy...What he's done
> really pissed off DBAs!

Or fire the IT manager who allow for non-trained personnel have this kind or privileges on a database
server... :-) 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Ding" <rding@acadian-asset.com> wrote in message news:eiYHCg2jEHA.4068@TK2MSFTNGP10.phx.gbl...
> You also need to seriously suggest firing that IT guy...What he's done
> really pissed off DBAs!
>
>
> "Steven Scaife" <anonymous@discussions.microsoft.com> wrote in message
> news:08b501c48f52$f1c64690$a401280a@phx.gbl...
> > 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