Hi everyone,
I am fully over how AG's work, backups, restores, fallover etc etc..
The question asked of me by the boss is
If we lose the VM that is running SQL server primary and perform a restore of the OS and SQL restore of backups taken using ola.hallengren.com
what state would this leave the AG? for example would all the setting of the AG come back with the restore of the system databases ?
All servers are running on VMware
I have been looking for a best process around restoring the system from backup with AG's but so far not found any
PS sorry for cross post i originally posted in SQL 2016 admin then found this forum which is much better topic