Log Shipping issue

[kodaksmile]

Hi -

I ran into an odd issue when configuring log shipping. The transaction log backups work but, the copy job fails with the following error:


2010-08-16 11:19:00.97 Copying log backup file to temporary work file. Source: '\\xxxx\PROD_db\PROD_db_20100816165505.trn', Destination: '\\xxxxx\PROD_db\PROD_db_20100816165505.wrk'
2010-08-16 11:19:01.00 *** Error: Access to the path '\\xxxx\PROD_db\PROD_db_20100816165505.wrk' is denied.(mscorlib) ***

I set the PROD_db as a share with the sql server agent service account and sql server service account having full access. If I login as that account I can manually copy the files fine.

Any suggestions? This is really driving me nuts.

 

[kodaksmile]

As an added note, I even made the sql server service account (same account sas the agent) a local admin and still no luck...

 

[djj55]

Did you make the destination a share?

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[kodaksmile]

Well I figured out the issue at least in my case - the destination cannot be a unc - only works when it is entered as N:\Prod_db (for example) in the copy tab of the configuration. It does not need to be a share (and it did not work when it was a unc and the folder was a share) I thought this was a bit odd since there are several articles that talk about being able to restore the log shipping files from a completely separate server (performance tends to be a concern there)

 

[djj55]

Thanks for posting your solution.
Log shipping is a black art and finding information is hard. I have a set pattern for setting up that I follow but am lost if something breaks.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!