Error 14420 14421, Log shipping please help, How to set values for Backup threshold and Out of sync threshold values?

  • HI all,

    I've gone through all the articles regarding logshipping about 14420 backup threshold and 14421 out of sync threshold error messages,

    Everyone is suggesting that we have to set backup and out of sync threshold values to 3 times the frequency of our operations.

    If don't think otherwise (cause i am a newbie) where we have to set these values in sql 2005 and sql 2008, shall i've to update the columns of log_shipping_monitor_alert table manually or

    it will be configured like in sql server 2000 at the time of log shipping configuration, please help

    I can't find any options when configuring log shipping using wizard in 2005.

  • Log shipping stored procedures are detailed here

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply