WhatsApp me +91-9966246368, if you need any help and support
Are you aware of this?
1) Why is transactional replication is every-green option?Why is this feature still being recommended for use instead of Always-ON, Mirroring, Logshipping, and Clustering?
2) Why we need to call Publisher and Subscriber why we don't call it as Primary and Secondary
Hint: subscriber is R/W , additional indexes can create here
Watch below video, to know the answers.