SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / Setting out-of-sync threshold / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 22:15:22 GMT20RE: Setting out-of-sync thresholdhttp://www.sqlservercentral.com/Forums/Topic867054-391-1.aspxunless the gui has really changed in SQL2008 instructions on how in my original post.Fri, 19 Feb 2010 07:12:55 GMTgeorge sibbaldRE: Setting out-of-sync thresholdhttp://www.sqlservercentral.com/Forums/Topic867054-391-1.aspx[quote][b]luckysql.kinda (2/19/2010)[/b][hr]Can't we make the threshold change using GUI? Do I need to run sp_change_log_shipping_primary_database and sp_change_log_shipping_secondary_database?[/quote]You can. The details are in the same main section of Books Online.Fri, 19 Feb 2010 06:33:14 GMTPaul WhiteRE: Setting out-of-sync thresholdhttp://www.sqlservercentral.com/Forums/Topic867054-391-1.aspxPaul,Can't we make the threshold change using GUI? Do I need to run sp_change_log_shipping_primary_database and sp_change_log_shipping_secondary_database?Fri, 19 Feb 2010 06:05:18 GMTluckysql.kindaRE: Setting out-of-sync thresholdhttp://www.sqlservercentral.com/Forums/Topic867054-391-1.aspxI don't have a resolution for your immediate problem but I have a suggestion for the future. You might execute the process more often to generate smaller dumps which should take less time to copy..CEWIIThu, 18 Feb 2010 08:02:40 GMTElliott WhitlowRE: Setting out-of-sync thresholdhttp://www.sqlservercentral.com/Forums/Topic867054-391-1.aspxBooks Online (hit F1) to the rescue![color="#0000FF"][u][url=http://msdn.microsoft.com/en-us/library/ms187351.aspx]sp_change_log_shipping_primary_database[/url][/u][u][url=http://msdn.microsoft.com/en-us/library/ms177507.aspx]sp_change_log_shipping_secondary_database[/url][/u][/color]See the @threshold_alert and threshold_alert_enabled parameters in particular.PaulThu, 18 Feb 2010 06:59:50 GMTPaul WhiteRE: Setting out-of-sync thresholdhttp://www.sqlservercentral.com/Forums/Topic867054-391-1.aspxI don't have logshipping on SQL2008 but presuming it has not changed from 2005 its set on the restore transaction log tab under 'secondary server instances and databases' in the log shipping wizard(right click database - properties)Thu, 18 Feb 2010 06:27:59 GMTgeorge sibbaldRE: Setting out-of-sync thresholdhttp://www.sqlservercentral.com/Forums/Topic867054-391-1.aspxCan anyone tell me how to change this setting pleaseThu, 18 Feb 2010 05:52:55 GMTluckysql.kindaSetting out-of-sync thresholdhttp://www.sqlservercentral.com/Forums/Topic867054-391-1.aspxCan anyone tell me as how to change out of sync threshold value in a log shipping environment. I am getting 14421 error and I have found that the out of sync threshold value is set to 12 min. The copy job itself takes around 10 min to complete. I found the out-of-sync value from log_shipping_secondaries table.-LuckyWed, 17 Feb 2010 07:29:28 GMTluckysql.kinda