Whats the best interval needed to set up the difference between the copy and
load frequency for log shipping. What i mean is if i set up the copy and
load each for 10 mins, would there be ever a contention where the load is
trying to restore a log file being copied also invoked at the same time
resulting in error " File being used by another process" since I have seen
those errors on our failure of restore jobs.
ThanksIt depends on the amount of transactions performed between the log =shipping routines and the performance of your servers. We perform log =shipping every 30 minutes. The restore the the standby server takes =less than 30 seconds.
-- Keith, SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message =news:u0kTuxcSDHA.1552@.TK2MSFTNGP10.phx.gbl...
> Whats the best interval needed to set up the difference between the =copy and
> load frequency for log shipping. What i mean is if i set up the copy =and
> load each for 10 mins, would there be ever a contention where the load =is
> trying to restore a log file being copied also invoked at the same =time
> resulting in error " File being used by another process" since I have =seen
> those errors on our failure of restore jobs.
> > Thanks
> > >
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment