January 10, 2007 at 9:15 am
Hi Everyone,
I'm running a SQL Server 2005 log shipping configuration and have disabled all log shipping and alerting jobs on the primary node. I've disabled all log copy, restoration and alerting jobs on the secondary (retore to) node. I've confirmed the jobs are disabled via: job history and job activity monitor.
However, the Transaction Log Shipping Status keeps being updated and a 'Bad' status has been flagged since the copy and restore jobs have exceeded their threshold time limit. The Alert job fires every 2 minutes on both the primary and secondary nodes. I'm not using a Monitor server.
From the Alert job (disabled), the only step is exec sys.sp_check_log_shipping_monitor_alert (from master) but there isn't any information in BOL or on the web.
I'd like to know how to temporarily disable the log shipping/copy/restore jobs and the alerting.
thanks for your help !
January 10, 2007 at 11:56 am
Your logshipping is still enabled where as your jobs, alerts and restores disabled manually...
I think there is not an option to disable (not sure) but there is an option to delete log shipping
Check the BOL topic "HOW TO: REMOVE LOG SHIPPING"
http://msdn2.microsoft.com/en-us/library/ms191297.aspx
MohammedU
Microsoft SQL Server MVP
January 11, 2007 at 3:43 pm
Hi Mohammed,
thanks for your reply. I didn't want to remove log shipping, merely temporarily disable it in preparation for a planned network outage.
I found the problem:
While I disable the log shipping jobs on both the primary and secondary nodes, there are also alerts on each of the nodes that pertain to log shipping that need to be disabled. They are:
Log shipping Primary Server Alert.
Log shipping Secondary Server Alert.
Thanks again,
Tim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply