SCOM database corrupted
We have a SCOM database that has corruption on it. We believe that the database ran out of space and then corruption occurred when it was lacking free space. Our last known good backup was about one month ago (since
then we have removed several systems from the SCOM Server). It we do a
DBCC CHECKDB with the REPAIR clause, we are afraid that it might delete something during the repair that might cause additional problems. Does anyone have any other suggestions
or comments?
Thanks in advanced
November 4th, 2010 1:19pm
I do not think that forums is the right place for such questions. I think you need to open a CSS case. You can do worse trying to fix it yourself...http://OpsMgr.ru/
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2010 1:25pm
Agreed, we only looking for options and some feedback at this point. We have a call open with support (non-microsoft) that we used.
November 4th, 2010 1:35pm
First of all, tell us please why are you think that your DB is corrupted?
What do you see? Errors? Have you tried to restart all services on RMS, clear health service cache?http://OpsMgr.ru/
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2010 1:40pm
Database consistency check is failing. The only error we said was the one about the database not having any free space. All services are up and running as far as we can tell everything is reporting back to SCOM data warehouse.
We only have a single server environment.
How do you clear the health service cache?
November 4th, 2010 1:48pm
> The only error we said was the one about the database not having any free space.
Have you tried to increase the DB size?
http://msdn.microsoft.com/en-us/library/ms175890.aspx
Autogrow is disabled on OpsMgr DB, so you have to do it manually.
http://OpsMgr.ru/
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2010 1:52pm