I was trying to Configure Log shipping through SSMS (SQL server Management Studio) in between Failover Cluster Instance (Principal Server) and Standalone (Secondary Server), Once I click OK button to finish the Log Shipping configuration, Backup on Primary completed successfully but for Restore to secondary it throws error. I am using existing Drives with required Permissions granted.

Error message: enter image description here

It means I need to Create a separate folder and assign permissions?

  • Comments are not for extended discussion; this conversation has been moved to chat.
    – Paul White
    May 17 '17 at 15:09

To summarize what we hashed out in the comments, yes, you will first need to setup a file share with proper permissions as part of the Prerequisites outlined in the Configure Log Shipping Guide provided by Microsoft.

Once you have the fileshare created, you should be able to connect to it using a UNC path similar to \\servername\sharedFolder


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.