Five Undocumented SQL Server 2014 log shipping stored procedures In this article, I want to describe the following five undocumented log shipping stored procedures shipped with SQL Server 2014: sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_delete_log_shipping_monitor_info sp_delete_log_shipping_monitor_jobs sp_log_shipping_get_date_from_file sp_check_log_shipping_monitor_alert The sp_check_log_shipping_monitor_alert log shipping stored procedure is used to check all monitor alerts in the primary database and in the secondary database in log shipping […]
Tag: log shipping
SQL Server 2014 – Log Shipping Feature Overview
SQL Server 2014 – Log Shipping Feature Overview Author: Basit A. Farooq SQL Server log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary standby server instances. In Log Shipping, a database on secondary standby server instance is a mirror image of...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Undocumented SQL Server 2012 log shipping stored procedures
Undocumented SQL Server 2012 log shipping stored procedures In this article, I want to describe the following six undocumented log shipping stored procedures shipped with SQL Server 2012: sp_add_log_shipping_monitor_jobs sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_delete_log_shipping_monitor_info sp_delete_log_shipping_monitor_jobs sp_log_shipping_get_date_from_file sp_add_log_shipping_monitor_jobs The sp_add_log_shipping_monitor_jobs log shipping stored procedure is used to add ‘Log Shipping Alert Job – Backup’ and ‘Log Shipping Alert Job – Restore’ jobs. Syntax...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Troubleshooting SQL Server 2012 Log Shipping
Troubleshooting SQL Server 2012 Log Shipping If you have problems with SQL Server 2012 log shipping, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 log shipping bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Troubleshooting problems with log shipping in SQL Server 2008 R2
Troubleshooting problems with log shipping in SQL Server 2008 R2 If you have problems with log shipping in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 log shipping bugs were fixed in SQL Server service packs, you should install the...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here