0

One of the secondary's is failing log shipping restore due to insufficient drive space. This might not be looked at by IT for several days. Can log shipping primary server purge transaction log backup before secondary has a chance to restore in this scenario? Or does Log shipping primary just hold onto transaction log backups until all secondary's have restored it?

1
  • Don't you have alert set if job fails at any place? You can define purging retention when configuring log-shipping. Dec 26 '20 at 8:29
2

The primary server must retain all transactions until the secondary restores them and acknowledges to the primary.

You must constantly monitor both the primary and secondary servers to avoid this situation.

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.