I m having sql server 2000 database and 4-5 database is in offline\suspect\Emergency .
I have tried that to take online throgh following step:
EXEC sp_resetstatus 'DBName'
ALTER DATABASE DBName SET EMERGENCY
ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DBName')
2. ALTER DATABASE DBName SET MULTI_USER
From this command :
but its not coming online and multiuser then i run this command : UPDATE SYSDATABASES SET STATUS=24 WHERE NAME='DBNAME' and it comes online but whenever sql sever services
get restarted it again goes into suspect mode.
Please help somebody?