Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| mssql_log_shipping [2020/03/10 14:24] – andonovj | mssql_log_shipping [2020/03/10 23:18] (current) – andonovj | ||
|---|---|---|---|
| Line 4: | Line 4: | ||
| {{ : | {{ : | ||
| - | |||
| - | |||
| There are couple things which has to be configured: | There are couple things which has to be configured: | ||
| Line 11: | Line 9: | ||
| [[mssql_log_shipping_primary|On Primary]] | [[mssql_log_shipping_primary|On Primary]] | ||
| + | * Disable Current Transaction Log Backup | ||
| * Create a schedule | * Create a schedule | ||
| * Create the necessary jobs and attach them Schedule | * Create the necessary jobs and attach them Schedule | ||
| Line 21: | Line 20: | ||
| * Restore the backup done on the primary | * Restore the backup done on the primary | ||
| * Start the log-shipping | * Start the log-shipping | ||
| - | * * In case edit the job if needed | ||
| + | [[mssql_log_shipping_switchover|Switchover]] | ||
| + | |||
| + | * Perform Tail-log Backup (On Primary) | ||
| + | * Restore with RECOVERY (On Standby) | ||