Undocumented SQL Server 2017 log shipping stored procedures SQL Server 2017 supports the following useful undocumented log shipping stored procedures: 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 configuration. Syntax sp_check_log_shipping_monitor_alert Return Code Values 0 (success) or...
Tag: sp_log_shipping_get_date_from_file
Useful Undocumented SQL Server 2016 Stored Procedures (Part 4)
Useful Undocumented SQL Server 2016 Stored Procedures (Part 4) SQL Server 2016 supports the following useful undocumented stored procedures: sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_log_shipping_get_date_from_file sp_MSget_jobstate sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs 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 configuration. Syntax sp_check_log_shipping_monitor_alert Return Code Values 0 (success)...
Five Undocumented SQL Server 2014 log shipping stored procedures
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 […]
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...