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:
Hai...i tried this one but not working..
update update sysdatabases set status=32768 where name=
Can explain clearly....plz
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