@Kris_K said in VDP MS SQL AAG backup best practices:
@travisdh1 said in VDP MS SQL AAG backup best practices:
Sounds correct to me. Just be sure the SQL backups actually happen before the AAG cluster backup,
Well, if i select Full server and select the whole cluster, aren't all the dbs (except for system dbs) backed up along with all node VMs?
In theory yes. In reality, those database files are held open by the database more often than not, and so they might not be a valid file anymore if you try to just restore the files. Which is why the rule to backup databases is to use the built-in database tools to create a backup, and then keep that in your normal backups.