There are a few undocumented things about the MSSQL Server 2000 missing in the knowledgebase of Microsoft. That’s a way to get a database marked as suspect into emergency mode:
use[master] go execute sp_configure 'allow updates',1 reconfigure with override go update sysdatabases set status =32768 where name ='' go
Restart the database server and you’re done. For reverting stuff, that’s the way to do it:
use[master] go update sysdatabases set status = 0 where name ='' go execute sp_configure 'allow updates',0 reconfigure with override
Restarting is also needed here.
Aileen says:
Der Emergency Mode hilft aber nicht beim reparieren?
Stargazer says:
Nein, der Emergency Mode sieht nur zu, dass die Datenbank IRGENDWIE läuft, damit du noch was rausziehen kannst