Monday, October 1, 2007

SQL VPX_HIST_STAT Table corruption

To check Virtual Center db for consistancy:
dbcc checkdb ('VCDB');

To repair soft:
alter database VCDB set SINGLE_USER;
dbcc checktable(VPX_HIST_STAT,REPAIR_REBUILD);
alter database VCDB set MULTI_USER;

if it doesn't help:
dbcc checktable(VPX_HIST_STAT,REPAIR_ALLOW_DATA_LOSS);