Manie Verster (8/15/2012)
Yes! I know but how and to what? I don't have a cooking clue. Can you help maybe, Perry?
as Anthony said above really.
You could also use the stored procedures to do this via T-SQL instead of the GUI. On the primary use this to set the threshold
exec sp_change_log_shipping_primary_database @database = 'yourdb'
, @backup_threshold = 'backup_threshold in mins'
or disable the backup threshold alert using
exec sp_change_log_shipping_primary_database @database = 'yourdb'
, @threshold_alert_enabled = '1'
On the secondary up the threshold using
exec sp_change_log_shipping_secondary_database
@secondary_database = 'yourdb'
, @restore_threshold = 'restore_threshold in mins'
or disable using
exec sp_change_log_shipping_secondary_database
@secondary_database = 'yourdb'
, @threshold_alert_enabled = '1'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉