Repair SCOM 2007 R2 Database

Today I ran into problems with an dirty shutdown concering SQL Server. This is how to repair the database :

alter database OperationsManagerDW set SINGLE_USER;

dbcc checkdb(‘OperationsManagerSQ’,REPAIR_REBUILD);

alter database OperationsManagerDW set MULTI_USER;

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.