> Software > Auto Recovery > Databases > SQL

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 Auto recovery > Replication groups.

    The Replication groups page appears.

    Note

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

  2. Click Add.

    The Select Workload Type page appears.

  3. Select SQL Server, and then click Next.

    The Source page of the Configure recovery group - SQL Server wizard appears.

  4. On the Source page, 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. Using the search box, select the databases that you want to replicate at the destination computer.

    5. Click Next.

  5. On the Target page, 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.

  6. On the Override options page, do the following:

    1. If the destination instance is the same as the source instance, in the Redirect options table, change the location of the database on the destination server:

      1. In the row for the database, click the Edit button edit button. The Edit database options dialog box appears.

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

      1. For Data file path, click Browse to select the data file path.

      2. For Log file path, click Browse to select the log file path.

      3. Click Save.

    2. Expand Advanced options, and then do the following:

      1. To delay the replication operation, in the Sync delay(Hour(s)) box, enter the number of hours by which you want to delay the data sync.

      2. To specify the state of the database after the restore operation, do the following:

        1. Select one of the following restore state:

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

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

          Note

          You should select restore with Stand by only when target instance has the same version as the source instance. When you want to restore to a higher target version, upgrade your database and use No recovery option.

        2. From the Copy precedence list, select the copy to recover data.

  7. 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.

×

Loading...