FULL recovery model
Log monitor server plus backup share
sp_add_log_shipping_primary_database
sp_add_schedule
sp_attach_schedule
sp_update_job
sp_add_log_shipping_primary_secondary
sp_add_log_shipping_secondary_primary
sp_add_schedule --copy
sp_attach_schedule
sp_add_schedule --restore
sp_attach_schedule
sp_update_job /* to enable both copy and restore jobs */
sp_add_log_shipping_secondary_database
sp_process log shipping monitor secondary
Failover:
- tail end log backup
no_truncateNORECOVERY
- apply
NORECOVERYuntil tail end log which is applied withRECOVERY
Switch roles
- disable backup, copy, and restore jobs
- rebuild jobs as above
- synchronisation “No, The Secondary Database is Initialized”
sp_change_log_shipping_secondary_database
sp_change_log_shipping_primary_database
sp_help_log_shipping_monitor
Log STANDBY uncommitted transaction on Transaction Undo File
- Error 14420 backup threshold exceeded
- Error 14421 restore threshold exceeded