How to synchronize instance level objects on Availability Group replicas
Osbit
Posts: 1 New member
Hi,
This will be my first post!
The organization that I work for wants to start making use of Availability Groups for several of their services, but I have some concerns that I have not found a good solution to yet.
Mainly this is around instance level object synchronization across AG replicas and how I keep them up to date when a new object (login, linked server, Agent job, etc.) or updated, which looks to be even more tricky as you can't just check to see if the object exists on other replicas.
I'm currently thinking about using triggers on the object tables to try and catch the updates, but don't want to waste time if there is a product/solution out there that already exists.
Any advice would be greatly appreciated
Thanks !
This will be my first post!
The organization that I work for wants to start making use of Availability Groups for several of their services, but I have some concerns that I have not found a good solution to yet.
Mainly this is around instance level object synchronization across AG replicas and how I keep them up to date when a new object (login, linked server, Agent job, etc.) or updated, which looks to be even more tricky as you can't just check to see if the object exists on other replicas.
I'm currently thinking about using triggers on the object tables to try and catch the updates, but don't want to waste time if there is a product/solution out there that already exists.
Any advice would be greatly appreciated
Thanks !
Comments
If you want to better understand betting and feel more confident in the world of gambling, the glossary on https://betting.bc.game/glossary/ is exactly what you need!
This resource is designed to help both beginners and experienced players. It provides clear and simple explanations of key terms frequently used in betting and gambling.
Why should you check out this glossary?
Using the BC.Game glossary not only enhances your understanding but also helps you make smarter and more informed decisions when betting.
We highly recommend visiting the BC.Game glossary, bookmarking it, and using it as your go-to guide in the world of gambling!