Configuring Replication for a SQL Database

Perform a SQL replication operation for a SQL database.

You can specify whether the database is in standby or no recovery mode after the operation completes.

You must have a backup in order to perform a replication operation. If you have installed the SQL Server agent on the client, but have not yet performed a backup, then the software does not display any databases in the SQL Live Sync Options dialog box.

Note: You can only use the replication feature with SQL databases that use the Full Recovery model.

Before You Begin

Verify that you have the following:

• A SQL Agent installed on the destination host.

• A SQL instance in the Commvault software for the destination instance.

• A backup for the database that you want to use for the replication operation.

Procedure

1. From the navigation pane, go to Disaster recovery > Replication.

   The Replication groups page appears.

   Note: You can also access the Replication groups page from the instance level and the database level.

2. Click Configure replication group, and then select SQL Server.

   The Configure replication group - SQL Server page appears.

3. On the Source tab, enter the following information for the source computer:

   1. In the Name box, type a name for the replication schedule that you are creating.

   2. From the Servers list, select a server.

   3. From the Instances list, select an instance.

   4. Select the databases that you want to replicate at the destination computer.

   5. Click Next.

4. On the Target tab, enter the following information for the destination computer:

   1. From the Servers list, select a server.

   2. From the Instances list, select the instance on which you want to replicate the data.

   3. Click Next.

5. On the Override options tab, complete the following advanced tasks:

   1. If the destination instance is the same as the source instance, then click Redirect options, and provide the following information to change the location of the database on the destination server:

      1. In the Database name box, type a name for the new database.

      2. Click Browse to select the data file path.

      3. Click Browse to select the log file path.

   2. To delay the replication operation, perform the following tasks:

      1. Click Advanced options.

      2. In the Sync delay box, enter the number of hours by which you want to delay the data sync.

   3. To specify the state of the database after the restore operation, select one of the following options:

      1. To leave the database in a restoring state after recovery, select No recovery.

      2. To leave the database in a read-only state after recovery, select Stand by, and then click Browse to select the path where undo file is stored.

6. Click Submit.

Results

The software initiates replication using the most recent full backup. You can monitor the replication job on the Replication Monitor page.

What to Do Next

• To view existing replication groups, go to Configuration > Replication.

• You can view the global Replication Monitor table, which contains information about the status of replication groups, replication clients, and replication jobs.