Live Sync Replication of SQL Databases
The Live Sync feature enables incremental replication from a backup of an 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 performs the following procedures:
- Initiates the replication automatically 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 replications. 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 only use the Live Sync feature with SQL databases that use the Full Recovery model.
Last modified: 2/13/2019 3:45:10 AM