Replication of SQL Databases

The replication feature enables incremental replication from a backup of an 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 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. 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 only use the replication feature with SQL databases that use the Full Recovery model.

Loading...