Link to home
Start Free TrialLog in
Avatar of fiveguys
fiveguysFlag for United States of America

asked on

Why does the copying and restoring jobs skip a bunch of already restored files before it finds the right one in log shipping in sql server 2008

Why does the copying and restoring jobs skip a bunch of already restored files before it finds the right one in log shipping in sql server 2008  
SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fiveguys

ASKER

the monitor server was not in the same box and it was in a different domain. So it did not record the last restored or last backed up file. So it started copying every file and skipping the ones those were not restored.