vWorld

vWorld – Oude Doesburgseweg 89C6901 HH Zevenaar – info@vworld.nl – Kantoor: 0316-798037 – Because it’s a virtual world!

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;