SQL:Synchronize Standby

Owned by Vijayganesh Sivaprakasam
Last updated: Jan 26, 2022
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. Checks the current LSN number of the standby.

  2. Take a differential backup of the primary database based on the LSN number on standby.

  3. Transfer the differential backup to standby.

  4. Restore the database backup on standby.

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

  6. Resume the automated update.

 

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