Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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