Replication of SQL Databases

You can use Live Sync to perform incremental replication from a backup of a SQL database to a synced copy of the SQL database. The Live Sync operation continuously applies changes from the source database backups since the last sync point.

The Live Sync feature includes the following capabilities:

  • Automatically initiates replication after a log backup is completed on the source database.
  • Minimizes the impact on production systems CPU and I/O by using the backup data for replication. This method avoids the need to read the source database again for replication.
  • Copies the backup data to remote disaster recovery (DR) sites with deduplication to minimize the wide area network (WAN) traffic. Live Sync then runs at the DR site.
  • Supports the destination database sync in standby mode so that users can schedule workloads on the destination server.

The Commvault software automatically performs the Live Sync operation when the following operations occur:

  • After you configure Live Sync, the software replicates the data from the last full cycle.
  • After a log backup completes on a database that is part of the Live Sync configuration. The software initiates a replication job that updates the destination database.

Note: You can use the Live Sync feature only with SQL databases that use the full recovery model.

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