I would like to setup a log shipping but I have a concern as to what would happen if the restore operation on the secondary would fail for some reason. I want the primary database keep working no matter what happens on the secondary database – even if the log restore can't be completed or secondary db goes offline. Does log shipping offer such an option?
Thank you all.
Best Answer
A restore failing on the secondary will have no impact on the primary. You want to monitor your secondary DBs to make sure this hasn't happened.