Log Shipping Copy Job Not working as on time which specified

Question

Post reply

Log Shipping Copy Job Not working as on time which specified

2M

SSC-Addicted

Points: 485
More actions
May 17, 2016 at 12:40 am

#146150

Hi All,
I am using SQL Server 2005.
I am taking backup of my Live Server to another local server by using transnational log shipping.
On Secondary there are two jobs 1) LS Copy 2) LS Restore
To LS Copy I have scheduled for after every 15 minutes It will take action.
To LS Restore I have scheduled for after every 60 minutes It will take action.
LS Restore is working fine...
But LS Copy Not working as specified. Eg: It ran on 4:15 AM, then 9:45 AM then 11:00 AM.
So can any one give me the reasons what is happening and why LS Copy not working after every 15 minutes. :discuss:

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 1

Is it running every 15 minutes and failing, or just not running except for various times like you listed?

How many databases are setup for log shipping and are using the same schedules for LSCopy/LSRestore jobs?

Joie Andrew
"Since 1982"

2M SSC-Addicted Points: 485 More actions · Answer 2

Hi,

I am using two server. On primary I have created One scheduler where One log shipping incremental backup processed. In that On secondary there are two jobs created one is LS Copy which will copy incremental backup files and another is LS Restore which restore that copy files came on secondary.

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

Are there any failures in the job history? If so can you copy/paste some of the errors?

Joie Andrew
"Since 1982"

2M SSC-Addicted Points: 485 More actions · Answer 4

No Dear that is the main issue. Its showing only batch which run successfully.

Is there any setting ?? which give me success as well as failure batch details??.

Lowell SSC Guru Points: 323506 More actions · Answer 5

I like the direction Joie Andrews was going;

look at the job history, andn see how long it takes.(the duration column)

if you set it for every 15 minutes, but it takes three hours to run, the fifteen minute increments won't matter until the job completes.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

2M SSC-Addicted Points: 485 More actions · Answer 6

Hi,

Can Anybody tell me about setting of job history where I can see the history of all run jobs of LS Copy. Because currently I can see only Jobs from 7.00 AM to 9.00 AM Only.Only today's jobs. But I want to see past job history also.:unsure: