Replication of SQL Databases

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

The replication 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. Replication 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 replication operation when the following operations occur:

  • After you configure replication, the software replicates the data from the last full cycle.

  • After a log backup completes on a database that is part of the replication configuration. The software initiates a replication job that updates the destination database.

Note

You can use the replication feature only with SQL databases that use the full recovery model.

Loading...