Post reply

When do you put the Database in Emergency Mode

  • February 7, 2006 at 2:27 am

    #103074

    Hi,

    I have a small Question, Generally When do u put the Database in the Emergency mode?, I have not come across any such situation.

    Cheers,

    Raghu Pyapili

     

     

  • February 8, 2006 at 12:05 pm

    #619607

    Under normal circumstances NEVER. I've had to perform this a few time in the past but it was only at the direction of MS PSS.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • February 8, 2006 at 2:58 pm

    #619639

    Sometimes when a db is marked as suspect, and all other attempts to get it back fail, the last resort is to bring it up in emergency and select out the data to some other place.

     

    References to this are many; here is one on this site

    http://qa.sqlservercentral.com/columnists/bknight/unmarksuspect.asp

    Terry

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply