Timeline for Syncing Server Objects across AG nodes
Current License: CC BY-SA 4.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 30, 2018 at 20:49 | comment | added | BDA the DBA | I use the DBATOOLS.IO alot for these manual copies, those modules are wonderful. Thank you for the hack link as well. I have a job that runs on all secondary nodes currently that will turn jobs off and on based upon whether the corresponding db's ag is primary or not. Works pretty slick. I need something that write the changes made to the primary objects. I.e. It wont matter if the ag fails over and the job kicks off like it is supposed to, alas the SSIS packages is not updated! Thank you Daniel for you're help | |
| Oct 30, 2018 at 20:40 | history | answered | Daniel Hutmacher | CC BY-SA 4.0 |