DaveWentzel.com            All Things Data

EMERGENCY database state option

 

EMERGENCY database state option
You can put a db in EMERGENCY state to gain limited access to the data as is.  Useful when the database is marked suspect.  Then you can either gain read-only access to the database or detach a suspect db.  Emergency mode sets the db to single-user and r/o, disables logging, restricts access to members of the sysadmin role, and allows repair or restoration of the db. 
 
alter database [name] set emergency;
 
 
 

Add new comment