I posted an article on SAP SDN with needed steps:
https://forums.sdn.sap.com/thread.jspa?threadID=602465&tstart=0
Sunday, October 21, 2007
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);
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);
Subscribe to:
Posts (Atom)