Database shows (Suspect\offline) in EM
-
Hi,
I have a Database which showed the status as (suspect\offline) in EM. But when I tried to bring the db on line I was able to. I checked that the DB files were in place. Any reason why this could have happened. Also while trying to bring it online I ran the profiler and caught this events and error.
Error: 942, Severity: 14, State: 4
Can someone interpret this error please
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me -
The error merely indicates that a request was made to an offline database. Once you've brought it up you won't see the errors anymore.
As to why...
-
Trying just giving the database a restore with recovery command -- it might just be stuck in a non-recovery state. If it still doesn't come online, check the SQL Server error log -- you'll probably get a better idea of what's wrong.
If it's truly Suspect (read: corrupted) and it is a production database, you may want to escalate to a PSS call.
Good luck!
-
The database could be brought online via QA when u get such error message from EM.
Please use the below command within the 'master' DB:
sp_dboption 'pubs','offline','false'
- change the parameter false/true to make it offline/online.
Hope this helps !
- A
Get busy living ....or get busy dying....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply