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

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 21:05:14 +0100

I wouldn't sack anyone for pissing of DBAs. Putting 65 GB of business data
at risk is a different matter though.... not to mention the downtime and the
extra work involved. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in 
message news:uWLfBT4jEHA.1404@TK2MSFTNGP09.phx.gbl...
>> 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

  • Re: export all tables in a db without the data
    ... Tibor Karaszi, SQL Server MVP ... > How can I export all the tables in a given database, ... without having to use the Enterprise Manager -- but even ...
    (microsoft.public.sqlserver.server)
  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: How critical is the transaction log file?
    ... Tibor Karaszi, SQL Server MVP ... file when you have only one file (no log file). ... circumstances it is supported to attach only an mdf file. ... > This development database that we're building does not have any 'user' ...
    (microsoft.public.sqlserver.tools)
  • Re: commiting the transaction log?
    ... Tibor Karaszi, SQL Server MVP ... been that the file growth (such as that by alter database or autogrowth) is ... Is that the reason for the log file (in the file system) having time stamp that is pretty old ... But even if I run the FULL backup, and then the T-log backup, I can see that ...
    (microsoft.public.sqlserver.server)
  • Re: "Do Not Allow Null" fields suddenly accept Nulls
    ... SQL Server MVP ... > to "Not Null" are now allowing nulls. ... > and the database saves it just fine. ... > message saying the field does not accept null data. ...
    (microsoft.public.sqlserver.server)