SQL 2005 log shipping restore threshold
  Home FAQ Contact Sign in
microsoft.public.sqlserver.setup only
 
Advanced search
POPULAR GROUPS

more...

 Up
SQL 2005 log shipping restore threshold         

Group: microsoft.public.sqlserver.setup · Group Profile
Author: Ray 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.
no comments
diggit! del.icio.us! reddit!