Take the 2-minute tour ×
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.

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.