Frequently Asked Question

This is the ticket dedicated to the issue with upgrading VSPC to 8.1.

I have examined the database and found issues related to index corruption in the database. I have run the DBCC CHECKDB command and got this output:

There are 5 consistency errors found in the database that refer to a corrupted index. The vast majority of corruption problems are related to the IO subsystem. We can only speculate whether this was due to hardware issues, improper shutdown, etc. The thing is a small portion of data cannot be restored.

However, I was able to fix this by SQL means by possibly losing part of corrupted data and successfully upgraded to 8.1. I have also successfully attached the database to the server and made sure it is operational. If you would like to follow this path please perform the following:

1. Stop Veeam Management Portal Service.
2. Back up VSPC database.
3. Run the following SQL script against VSPC database. This will remove the corrupted rows but data loss is possible:

ALTER DATABASE [VSPC] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
BEGIN TRANSACTION;
DBCC CHECKDB ('VSPC', REPAIR_ALLOW_DATA_LOSS);
COMMIT;
ALTER DATABASE [VSPC] SET MULTI_USER;

4. Run the installation wizard and successfully complete the upgrade.

5. Check with the UI that all required data is available.