/
SQL:Synchronize Standby

SQL:Synchronize Standby

Owned by Vijayganesh Sivaprakasam
Last updated: Jan 20, 2025
2 min read

The synchronize standby feature of the MultiPlatform resolves the unrecoverable transaction log gap in standby. This can happen under these circumstances.

  1. Adhoc transaction log backups are taken in the primary, breaking the log chain between the primary and standby.

  2. An ad-hoc full backup was taken with tail log backup that breaks the log chain.

  3. One or more transaction log backup files are lost in standby before getting applied in standby.

The Sync feature, in summary, does the following:

  1. Take a differential backup of the primary database based on the backup taken on primary that was used to create the DR

  2. Transfer the differential backup to standby.

  3. Restore the database backup on standby.

  4. Delete unwanted transaction log backups that are present on standby.

  5. Resume the automated update.

 

Click on Synchronize to start the process and press start to start the sync process.