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?


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

| improve this answer | |

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.