Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Log shipping fails with the below error. Sql agent on secondary server has access to the folder and files in security. It is not a firewall issue. I created the jobs using the LS scripts as it fails through GUI.

I have done it before on a different server where there were several LS databases. This is a new primary and secondary server and not sure what I am missing. Thanks for the help

***** Error: Access to the path '\\sqlp\R$\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\Database' is denied.(mscorlib) ***
----- END OF TRANSACTION LOG COPY     -----**
share|improve this question
1  
The R$ share is only accessible by administrators. Therein lies your problem, with almost 100% certainty. You should create a share on the Backup folder with security that allows the SQL Server service account write access. – Max Vernon Dec 3 '13 at 15:54
    
Yes that was it. I gave sa account admin rights on the server. Thank you for your help and time! – knahs Dec 11 '13 at 14:48

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.