Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

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  
0
fiveguys
Asked:
fiveguys
  • 2
3 Solutions
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
Mostly because it knows what the LSN is and that it has already restored it.  That is part of the black box of sqllogship.exe.  If there are multiple files in the directory where the copy lands, then it will need to try those out.  There is no context that I know of during the restore process of the job.
0
 
marappanCommented:
There is a table in msdb database that stores last restored file and last copied file. So, SQL Server job knows to skip the files already copied and restored. The table name should start with log_ship
0
 
fiveguysAuthor Commented:
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.
0
 
fiveguysAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now