Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Setting out-of-sync threshold Expand / Collapse
Author
Message
Posted Wednesday, February 17, 2010 7:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
Can 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.

-Lucky
Post #867054
Posted Thursday, February 18, 2010 5:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
Can anyone tell me how to change this setting please
Post #867945
Posted Thursday, February 18, 2010 6:27 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, September 8, 2014 8:17 AM
Points: 5,991, Visits: 12,939
I 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)


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

Post #867975
Posted Thursday, February 18, 2010 6:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:59 AM
Points: 11,194, Visits: 11,166
Books Online (hit F1) to the rescue!

sp_change_log_shipping_primary_database
sp_change_log_shipping_secondary_database


See the @threshold_alert and threshold_alert_enabled parameters in particular.

Paul




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #868002
Posted Thursday, February 18, 2010 8:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
I 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..

CEWII
Post #868066
Posted Friday, February 19, 2010 6:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
Paul,

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?
Post #868999
Posted Friday, February 19, 2010 6:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:59 AM
Points: 11,194, Visits: 11,166
luckysql.kinda (2/19/2010)
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?

You can. The details are in the same main section of Books Online.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #869018
Posted Friday, February 19, 2010 7:12 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, September 8, 2014 8:17 AM
Points: 5,991, Visits: 12,939
unless the gui has really changed in SQL2008 instructions on how in my original post.

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

Post #869060
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse