Emergency mode | SansSQL

Saturday, May 3, 2008

Emergency mode

sp_configure 'allow update', 1
Reconfigure with override

update sysdatabases set status=32768 where name=

sp_configure 'allow update', 1
Reconfigure with override

Use this query to take the database to Emergency Mode whenever it is marked as suspect.
When the database is in Emergency mode, you can query the database and export the data into a new database.

2 comments:

As..Reddy said...

Hai...i tried this one but not working..

update update sysdatabases set status=32768 where name=


Can explain clearly....plz

Sandesh Segu said...

The command in the post works for SQL 2000.
For 2005 and up use this query to set the database into Emergency Mode
Alter Database <DBName> Set EMERGENCY

Post a Comment