Before upgrading an existing Veeam Availability Console installation to version 3, please run the pre-upgrade check script. This script removes duplicated values from the VAC database that can affect the upgrade procedure.To apply the script:
Interpreting the results:
- Ensure that you are running Availability Console 2.0 (any update and patch level). The script will not work on an earlier version of the database.
- Using Microsoft SQL Management Studio or sqlcmd connect to the SQL Server running the Configuration Database. You can get the Database connection parameters from the corresponding section in the Server Settings.
- Back up Availability Console database:
- Execute the script against the Availability Console database.
If the script outputs one of the following messages, you can proceed with the upgrade to version 3.0:(x row(s) affected)All duplicates entries (x) have been removed. Ready to upgrade.
or(0 row(s) affected)No duplicates have been found. Ready to upgrade.
In case of the following message, make sure that the product's version is at least 2.0 or 2.0U1, and you are connected to a proper database. If these conditions are met, contact Technical Support for assistance:Msg 208, Level 16, State 1, Line 5Invalid object name 'VeeamBR.CompanyResources'