Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 logshipping

Author  Topic 

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-11-29 : 17:46:53
Kind of new to logshipping, how do we specify theshhold when logshipping out of sync

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-12-03 : 13:11:04
Anybody have idea?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-03 : 13:27:13
You can do it while setting up Log shipping. It will ask you if are using GUI feature.
Go to Top of Page

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-12-03 : 13:34:20
Thanks Sodeep! I got below error...please guide me
The log shipping secondary database abcd has restore threshold of 45 minutes and is out of sync. No restore was performed for 399 minutes. Restored latency is 171 minutes. Check agent log and logshipping monitor information.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-03 : 13:46:47
http://deepakrangarajan.blogspot.com/2007/11/log-shipping-errors.html
Go to Top of Page

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-12-04 : 02:49:37
Looks like set an incorrect value for the Out of Sync Alert threshold. Where can I go and modify the value of the Out of Sync Alert threshold?
Go to Top of Page
   

- Advertisement -