mssql_log_shipping [My wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

======Overview======
Log-shipping allows the databases to be kept in active/passive state. Thus we can assure passive standby in case of a failure and the loos will be minimal. We can configure a log shipping each 1 hour or each 5 minutes. Thus the maximum we can loose is 5 minutes, of course this depends on the network and distance between the servers.
Unlike mirroring, log-shipping is transparent to a SQL version, so we can have SQL server 2008 log shipping to SQL Server 2016 without any problems. In fact, this is strongly used for upgrades operations.

{{ :log_shipping_sql_server.jpg?400 |}}

There are couple things which has to be configured:

[[mssql_log_shipping_primary|On Primary]]

  * Disable Current Transaction Log Backup
  * Create a schedule
  * Create the necessary jobs and attach them Schedule
  * Do a backup to a shared location

[[mssql_log_shipping_secondary|On Secondary]]

  * Create a schedules (1 for copy and 1 for restore)
  * Create jobs for both: copy and restore
  * Restore the backup done on the primary
  * Start the log-shipping

[[mssql_log_shipping_switchover|Switchover]]

  * Perform Tail-log Backup (On Primary)
  * Restore with RECOVERY (On Standby)