Delphix currently supports Commvault v11. The version of Commvault SQL Agent on the staging environment must be the same as that on the source.
The TCP port 8415 must be open from the staging host to the Delphix Engine.
- If the dSource is backed up with Commvault, the source and staging environments must each have the SQL Agent installed.
- Both SQL Agents (on source and staging) should be registered with Commvault Server mentioned during linking.
The install path’s ‘Base’ directory of Commvault SQL Server Agent on the staging host, must be part of PATH environment variable as we need to access the Commvault CLI. This is typically located at <Commvault install path>\Base.
- Since SSO is used from Commvault CLI to login into the CommServe server from the staging environment, SSO should be enabled.
- Active Directory domain should be configured and configured staging environment user should be given required permissions to restore the database on staging client.
- In the CommServe server, the staging client should be configured with a user who has required permissions to restore the database on the staging environment. User account configuration can be done as explained in Commvault documentation at User Account Configuration for the SQL Server Agent.
- Only transaction logs, incremental, and database full backups are currently supported.
Linking with Commvault Backups:
To link a dSource and use Commvault, follow the steps to add the environments as earlier, and make sure all requirements listed above are met. Going through the linking wizard on the Data Management page, select Show advanced.
Enable Commvault Ingestion and input the CommServe host name and, source and staging client names.
We validate whether the source and staging clients exist in CommServe server and the Commvault SQL Agent on staging client is registered to the CommServe server. To run the validation commands following login command with SSO option is used to login into CommServe Server:
qlogin -sso -gt
LogSync for SQL Server dSources
Logsync (point-in-time provisioning) is currently not supported for Commvault transaction logs. However, LogSync can still be enabled if Commvault ingestion is enabled. LogSync for backups taken with other backup providers that support LogSync will work as before.
Enabling Commvault for previously created dSources
On an already created dSource go to Configure > Data Management and click edit (pencil button). Enable Commvault Ingestion and add all the configuration as necessary.
Linking an Availability Group database with Commvault
Linking with an Availability Group (AG) source works similar to as described above, however, the source client name provided in the Commvault configuration should be the MSSQL AG Client name as in CommServe server.
Commvault backups are not on local storage and therefore while ingesting backups taken using Commvault, Backup Paths provided in configuration will be ignored.