Loading...

Configuring Live Sync Replication for a SQL Database

Perform a SQL Live Sync 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 Live Sync 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 Live Sync feature with SQL databases that use the Full Recovery model.

Before You Begin

  1. Install the SQL Agent on the destination host. For more information, see Getting Started with SQL Server.
  2. Add a SQL instance in the CommCell Console for the destination instance. For more information, see Adding SQL Instances.
  3. Make sure that you have a backup for the database that you want to use for the Live Sync 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 Live Sync 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 Live Sync 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 Periodic Replication Monitoring table, which contains information about the status of replication groups, replication clients, and replication jobs.

Last modified: 12/4/2020 8:54:57 PM