Solved

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

Posted on 2011-09-21
4
261 Views
Last Modified: 2012-05-12
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
Comment
Question by:fiveguys
  • 2
4 Comments
 
LVL 24

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 250 total points
ID: 36577886
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
 
LVL 2

Assisted Solution

by:marappan
marappan earned 250 total points
ID: 36582645
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
 

Accepted Solution

by:
fiveguys earned 0 total points
ID: 36601066
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
 

Author Closing Comment

by:fiveguys
ID: 36895881
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now