Change database Mode (EMERGENCY MODE)

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  February 8, 2008 at 10:48 am

  #120575

  Hello,

  We've got one database name that initialy was in SUSPECT MODE and i change it to EMERGENCY MODE. The point is that i cant remember how to change this database to normal mode :sick: and what should i do with the object that is corrupt.

  Can u help me please?

  Other thing,after i saw all tables including the one that as problems i try to put the database offline and try to stop this process, the database stays online and i can do queries but curious is the fact that i cant see them by the SQL Server Managment Studio :blush:

  Here are the commands that i execute:

  ALTER DATABASE PTC_QS SET EMERGENCY

  GO

  USE PTC_QS

  GO

  DBCC CHECKDB WITH ALL_ERRORMSGS;

  GO

  Thanks and regards,

  JMSM

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  February 8, 2008 at 11:57 am

  #776549

  You may be lucky enough to hear from Paul directly but until then, check out this article:

  http://www.sqlskills.com/blogs/paul/2007/10/02/SearchEngineQA4UsingEMERGENCYModeToAccessARECOVERYPENDINGOrSUSPECTDatabase.aspx