LogShipping Copy and Load Question

Hi,
I have established a LogShipping plan with Secondary
Server DB set as Standby, 15 minutes interval of Backup
Log, Load and Restore. Questions:
(1) Inside Log Shipping History, it seems that the Copy
will always copy NEWER Log (in my case, 15 minutes later,
eg. 1815), and Load will always Load OLDER Log (in my
case, 15 minuutes earlier eg. 1800). How can I resolve
this?
(2) Most importantly, The Logshipping will have errors
after a while and it reaches a stage where NO file(s) will
be processed and "Last File" in Log Shipping History
always remains the same file (Eg. ...200407090615.TRN). I
suspect it is all related to the frequency that I set.
I just find it hard to maintain a good Log Shipping plan
which does not require close monitoring.
I would appreciate any help for me here. Thanks a lot in
advance.
Tom
Tom,
making the load frequency every 5 mins should solve the issues you are
experiencing.
I always have a more frequent load than copy to prevent backlogs of the log
files.
HTH,
Paul Ibison
sql