Once you set up SQL Log Shipping, it will produce 4 Major jobs:
I assume the Primary server is R1, the Secondary is R2
- Alerts (Both on Primary R1 and Secondary R2)
- Backup (On Primary)
- Copy (On Secondary)
- Restore (On Secondary)
I’ve set up already and
Backup/Copy/Restore are all worked fine and correctly. But Alerts on Primary R1 has been sent all the time below