As the topic says, I was wondering if you guys have any advice on potential issues with Always On availability during a massive update?
We're in need of making several massive datamodel changes, removing & adding tables and moving around large amounts of data (some 300+ GB), including creating and rebuilding hundreds of indexes and statistics in a procedure that will take well over 24 hours in total, and schedule-wise can not take more than 30 hours before bringing the DB's back online. And I'm not sure whether the always on availability mode's synchronization is the best option to replicate these changes to the other availability groups. Would it be better to just backup the changes once they're done, restore that to the other groups and re-enable synchronization from there?
Like I said, I don't really have experience working with it, so this is an open question. And apologies for any misunderstandings or misconceptions here, again since my experience is limited. Please correct me where appropriate. :)