Upgrading Older SQL Server Versions to Microsoft SQL Server 2012 Enterprise Edition
Applies to: Server packages (CommServe, Metrics Reporting, Web Server, and Workflow Engine)
The current Commvault version uses Microsoft SQL Server 2014 Standard Edition, but continues to support the Microsoft SQL Server 2012 Enterprise Edition. Previous Commvault versions used the Enterprise Editions of Microsoft SQL Server 2012 and 2008.
By default, when you upgrade a Commvault server package, Microsoft SQL Server versions 2008 and 2008 R2 are automatically upgraded to Microsoft SQL Server 2012 SP2. However, if the server package is in a cluster environment, you must use this procedure to upgrade the Microsoft SQL Server manually.
The procedure covers the steps to upgrade Microsoft SQL Server versions 2008 and 2008 R2.
Before You Begin
- Review the platforms and Commvault packages that are supported by Microsoft SQL Server 2012. For information, see Considerations for SQL Server 2012.
- If you have Microsoft SQL Server 2008 R2, make sure that you install SQL Server SP2. If SP2 is not installed, the upgrade will fail.
- If the server package is installed in a cluster environment, review the following considerations before you start the upgrade:
- You must first upgrade the SQL Server instance on all passive nodes of the cluster. Then, you can upgrade the SQL Server instance on the active node.
- Windows Installer 4.5 might be installed during the upgrade. If you are prompted to restart your computer, restart and then double-click Setup.exe again.
- Log on to the computer as an Administrator or as a member of the Administrator group.
For cluster environments, log on to the selected physical node of the cluster group as an Administrator, or as a member of the Administrator group.
From the installation package that was created using the Download Manager, run the following program:
The SQL Server Installation Center wizard is displayed.
- In the left navigation area, click Installation and then click Upgrade from SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2.
- On the Setup Support Rules page, click OK after the wizard identifies any issues with the support rule files.
- On the Product Key page, click Next. The product key is already provided.
On the License Terms page, select the I accept the license terms check box and then click Next.
- On the Product Updates page, click Next to include the latest SQL Server updates.
The Install Setup Files page is displayed, where the setup files are copied and then the installation automatically starts.
- On the Setup Support Rules page, check that the verification process returns successful results. If the setup returns a few warnings or failures, make sure to fix them before proceeding with the installation. Then, click Next.
- On the Select Instance page, from the Instance to upgrade list, select the SQL Server instance to upgrade, and then click Next.
On the Select Features page, the SQL Server features to be upgraded are displayed. Click Next.
On the Instance Configuration page, the details of the SQL Server instance that you selected to upgrade is displayed. Click Next.
On the Disk Space Requirements page, review the disk space summary and click Next.
- On the Server Configuration page, accept the default values and then click Next.
- On the Full-text Upgrade page, select Import and click Next.
- On the Error Reporting page, click Next.
On the Upgrade Rules page, check that the verification process returns successful results. If the setup returns a few warnings or failures, make sure to fix them before proceeding with the upgrade. Then, click Next.
- On the Cluster Upgrade Report page, the upgrade status of the failover cluster nodes is displayed. Click Next.
- On the Ready to Upgrade page, verify the features to be upgraded and then click Upgrade.
The Upgrade Progress page is displayed, showing the upgrade process.
- On the Cluster Upgrade Report page, click Next.
- On the Complete page, click Close. The SQL Server is successfully upgraded.
To complete the upgrade process in a cluster environment, repeat the steps on all the other nodes of the SQL Server failover cluster.