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;