The synchronize standby feature of the Multiplatform can be used to resolve the unrecoverable transaction log gap in standby. This can happen under these circumstances
Adhoc transaction log backups are taken in the primary which can break the log chain between the primary and standby.
Adhoc full backup was taken with tail log backup that breaks the log chain.
One or more transaction log backup files are lost in standby before getting applied in standby.
The Sync feature, in summary, does the following:
Checks the current LSN number of the standby.
Take a differential backup of the priamry database based on the LSN number on standby.
Transfer the differential backup on the standby.
Restore the database backup on the standby.
Delete unwanted transaction log backup that are present on standby.
Resume the automated update.
Click on Synchronize to start the process and press start to start the sync process.
