• Restore the last full and differential backup from primary on secundary and leave the database in NORECOVERY or STANDBY. Restore each log backup on secundary after this is created on the primary, still leaving the database in NORECOVERY or STANDBY. In case of disaster create a TAIL LOG backup on primary and restore this on the secundary. Set the database on secundary to RECOVERY if the secundary needs to serve the application because the primary is crashed.

    The restore of the LOG backups can be setup as an automated process. This is preferred above a manual approach.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **