How to place a Database in emergency mode.

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  February 6, 2006 at 11:31 pm

  #110961

  HI,

  Please let me know how to take a suspect database in an emergency mode?

  Awaiting early reply.

  Thanks
  Jay
  http://www.sqldbops.com

• Ford Fairlane

  SSCertifiable

  Points: 7664

  More actions

  February 6, 2006 at 11:45 pm

  #619162

  Hi there,

  To place your database in emergency mode, use the following command:

  SP_CONFIGURE 'allow updates', 1

  RECONFIGURE WITH OVERRIDE

  GO

  UPDATE master..sysdatabases set status = -32768 WHERE name = 'pubs'

  GO

  SP_CONFIGURE 'allow updates', 0

  RECONFIGURE WITH OVERRIDE

  You can then BCP data out and place it into a different database

   

  Hope this helps...

  Ford Fairlane
  Rock and Roll Detective