Upgrading Microsoft SQL Server Express to Microsoft SQL Server 2016 Standard Edition

Applies to: CommServe computer running Microsoft SQL Server Express

By default, the Microsoft SQL Server Express software is installed during the installation of some Commvault software (for example, the Edge solution).

Note

Upgrading is required if the size of your Microsoft SQL Server instance exceeds 10GB. For more information, see 6 Ways to Check the Size of a Database in SQL Server using T-SQL.
Commvault does not require or recommend upgrading unless scalability limit is reached.

Before You Begin

Make sure that you have the Microsoft SQL Server Standard Edition software on the CommServe computer.
Perform a disaster recovery backup of your CommServe database. For more information, see Performing a Disaster Recovery Backup.

Procedure

Stop all services on the CommServe computer. For more information, see Stopping Services.
From the command prompt, detach the CommServe database as follows:
1. To execute SQL commands, type the following command:
```
osql -S <machinename>\<instancename> –E
```
  Replace machinename with the name of the CommServe computer, and replace instancename with the SQL instance name (for example, Commvault).
2. To detach the database, type the following command:
```
exec sp_detach_db 'CommServ', true
go
```
3. To confirm that the Commserve database is not listed in the list of available databases, type the following command:
```
select name from sysdatabases
go
```
Copy the CommServe database folder to a safe location.

If the software was installed in the default location, the database folder may reside in the following location: Program Files\Microsoft SQL Server\MSSQLCommvault\Data\Commserve
Uninstall the Microsoft SQL Server Express software. For instructions, refer to Microsoft documentation.
Install the Standard Edition of the Microsoft SQL Server. For more information, see Pre-Installing the Microsoft SQL Server Software on a Non-Cluster Environment.
Use the SQL Server Management Studio to detach the CommServe database as follows:
1. Go to computer_name\Commvault > Databases > CommServ.
2. Right-click CommServ, click Tasks, and then click Detach Database.
If necessary, copy the database folder back to a convenient location.
Use the SQL Server Management Studio to attach the CommServe database that you copied as follows:
1. Go to computer_name\Commvault > Databases.
2. Right-click Databases, and then click Attach.
3. Choose the .mdf file from the CommServe database you saved.
Start all services on the CommServe computer. For more information, see Starting Services.