If you want to upgrade only your Metrics Reporting Server instead of the entire CommServe software, or if your CommCell environment grows beyond 200 clients, you can move the Private Metrics Reporting Server to a different, dedicated server. To relocate your Private Metrics Reporting Server, you must move the CVCloud database, and then install the latest version of Metrics Reporting to a different server.
For standalone installations of the Metrics Reporting Server, you must install an instance of the SQL Server Agent to be used for disaster recovery backups of the CVCloud database.
During the installation, you must provide the name and location of the production CommServe computer to associate it with the Metrics Reporting Server.
Back up the CVCloud database:
If the Metrics Reporting Server is installed on the production CommServe server, back up the CVCloud database using SQL Server Management Studio. For instructions, see Create a Full Database Backup (SQL Server).
If the Metrics Reporting Server is installed on a dedicated server, run a full backup operation for the CVCloud database using the SQL agent. For instructions, see Backing Up SQL Databases.
Restore the CVCloud database:
If you used SQL Server Management Studio to back up the CVCloud database, copy the CVCloud .dmp file, paste it to a location on the new server, and then restore the CVCloud database using SQL Server Management Studio. For instructions, see Complete Database Restores (Full Recovery Model).
If you used the SQL agent to run a full backup, restore the CVCloud database to the new dedicated server. For instructions, see Restoring SQL Databases Out of Place.
On the new server, enable Internet Information Services (IIS), and then install the following components:
If the CVCloud database and the CommServe database are not on the same version, Upgrade the restored CVCloud database using the DBUpgradeTool.
If the CVCloud database and the CommServe database are on the same version, then this step is optional.
Disable or uninstall the old Metrics Reporting Server:
If you moved the Metrics Reporting Server from the production CommServe server to a dedicated server, then on the production CommServe server, disable the Private Metrics Reporting Server. On the production CommServe server, from the command prompt, type the following command:
qoperation execscript -sn SetKeyIntoGlobalParamTbl.sql -si commservMetricsReportingServerEnabled -si y -si 0
If you moved the Metrics Reporting Server from one dedicated server to another, then uninstall the Commvault software from the old dedicated server. For instructions, see Uninstalling the CommServe Software.