Configuring Backups for SQL Server in Oracle Cloud Infrastructure

You can configure SQL Server databases on OCI. The configuration wizard guides you through the configuration process, which includes creating any new entities that are needed, such as a plan, an object storage client, and a content group.

Before You Begin

For Oracle Database Cloud Service and Oracle Exadata Cloud Service systems in OCI, use the Oracle Console to clear the Enable Automatic Backup setting for the databases you want to protect. If you enable automatic backups, Commvault Cloud backup or restore operations may fail.

Procedure

From the navigation pane, go to Protect > Databases.
The Overview page appears.
In the upper-right area of the page, click Add server.
The Select Database Type page appears.
Select SQL server.
The Select Your Database Environment page appears.
Select Database running in the cloud VM.
From the Select vendor list, select Oracle Cloud Infrastructure.

An active trial or an active subscription is required.
Click Next.
The Backup method overview page appears.
Review the information.
Click Next.
The IAM Role page appears.

Configure Oracle IAM permissions for API key-based authentication using Resource Manager template that is provided by Commvault Cloud.
Click Launch Oracle Cloud Stack Template. The Create Stack page of the OCI website appears. Create your MetallicServiceAccount user and then follow the directions in Step 2 on the page to obtain your Tenancy OCID, API key, and fingerprint for the user.
Select I have reviewed and accept the Oracle terms of use.
The Resource Manager template creates an IAM user in the IAM group. Then, it creates and assigns an IAM policy to the group.
Verify that the Use custom Terraform providers check box is not selected.
In the Name box, enter a descriptive name for the stack.
From the Create in compartment list, select a compartment.
In the Tags section, add a tag to identify the IAM stack.
Click Next.
The Configure Variables page appears.
In the Email address for User (MetallicServiceAccount) box, enter an email address.
Click Next.
The Review page appears.
Click Create.
In the search bar at the top of the page, search for your user MetallicServiceAccount.
Your MetallicServiceAccount page appears.
Under API Keys, select Add API Key > Download Private Key.
Under the API key section, click the button with three dots.
Copy the Credential Name, Tenancy OCID, User OCID, and Fingerprint values.
Return to the Commvault Cloud configuration wizard.
For Credentials, select existing credentials or create new credentials.
To create credentials, do the following:
1. Click the add button .
  
  The Add credential dialog box appears.
2. In the Credential name box, enter a descriptive name for the credentials.
3. In the Tenancy ocid box, enter the OCID for the tenant.
4. In the User OCID box, enter OCID for the user for the hypervisor.
5. In the Finger print box, enter the fingerprint.
6. For Private key, upload the private key file.
7. In the Private key's password box, enter the password for the private key.
8. In the Description box, enter a description of the credentials.
9. Click Save.
Click Next.
The region selection page appears.
From the region list, select the region where the cloud storage is located.
Click NEXT.

The backup gateway selection page appears.

A backup gateway is required to back up object storage without egress charges.
Select an existing backup gateway or create a new backup gateway.
Click Next.
The Cloud Storage page of the configuration wizard appears.
For the primary copy of the backup data, select existing cloud storage or create new cloud storage.
Decide whether to store a secondary copy of the backup data for long-term retention. To use a secondary copy, do the following
1. Move the Secondary copy toggle key to the right.
2. For Storage location, select an existing storage location or create a new storage location.
Click Next.
The Plan page of the configuration wizard appears.
Select an existing plan or create a new plan.
Click Next.
The Install Package page of the configuration wizard appears.
To perform a push installation, do the following:
1. Select Push installation.
2. Select one or more database servers from the list at the bottom of the page, or add a new database server.
3. To add a new database server, click +, then complete the following in the Add Oracle database service page:
  1. In the Host name box, enter the host name.
  2. From the Credential list, select the existing credential or create a new credential.
  3. To add a credential, do the following:
    Steps to add a new credential
    1. Click +.
      The Add Credential dialog box appears.
    2. In the Credential name box, enter a unique name to access the credential.
    3. In the User account box, enter the user account that access to the SQL server.
    4. In the Password box, enter the password for the user account.
    5. In the Description box, enter a brief description for the credential.
    6. Click Save.
  4. Click Save.
To perform an interactive installation, complete the following:
1. Select Interactive installation.
2. Download the SQL Server package, and then install it on the server you want to back up.
3. Copy the authcode, and then use it to authenticate the SQL Server package on the server.
4. In the Server name drop-down list, select the name of the server.
Click Next.

The Credentials page appears.
To use a local system account for impersonation, move the Use local system account toggle key to the right.
Select the existing credential or create a new credential.
To add a credential, do the following:
1. Click +.
  The Add Credential dialog box appears.
2. In the Credential name box, enter a unique name to access the credential.
3. In the User account box, enter the user account that access to the SQL server.
4. In the Password box, enter the password for the user account.
5. In the Description box, enter a brief description for the credential.
6. Click Save.
Note
- If you are installing the SQL Server on a Windows server, select the Windows account for SQL impersonation. A new credential is added as Windows account.
- If you are installing the SQL Server on a Linux server, select the SQL account for SQL impersonation. A new credential is added as SQL account.
- If a credential is not selected, the local system account will be used for impersonation. If a credential is selected, credentials for impersonation should be common between all selected servers. Once the installation is complete, credential will be available for modification at the server level.
- If you have servers that are running on Windows and Linux, a common credential must not be used. Instead, leave the credential blank and set the impersonation on servers manually after the installation completed.
Click Next.
The Backup Content page appears.
Review the list of instances that will be protected.
Click Next.
Review the summary.
Click Finish.