| SQL 2005 log shipping restore threshold |
|
 |
|
 |
|
 |
|
 |
Group: microsoft.public.sqlserver.setup · Group Profile
Author: Ray YanRay Yan Date: Sep 8, 2008 22:13
Looks like the default SQL 2005 log shipping restore threshold is 45 minutes,
how do you adjust it after you have set up the whole log shipping?
I've setup the log backup on primary server at every two hours and copy to
secondary server 15 minutes later, then get restored after another 15
minutes, the copy and restore job on secondary server seem ok but on the
monitor server, I keep getting the alert warning for the 45 minutes
threshold is out of sync.
I guess if I adjuest the threshold to 2 hours then every thing should be
fine, but I can't find where I can change this setting?
Thanks in advance.
|