VDP MS SQL AAG backup best practices
-
Hi all,
have a little trouble figuring out the best way to configure MS SQL 2014 AAG backups using VMware VDP 6.1.
https://pubs.vmware.com/vsphere-60/topic/com.vmware.ICbase/PDF/vmware-data-protection-administration-guide-61.pdf (starting at page 166) doesn't really help, cannot find any best practice docs as well.
There (and in some other Avamar docs) i found that simple recovery model dbs (master, model, msdb) should be backed up separately.So am i right to assume that this would work?...:
Job 1. Select Full server, select whole AAG cluster and Full as a backup type (scheduled every whatever days)
Job 2. Select Full server, select whole AAG cluster and Incremental as a backup type (scheduled every whatever days, obviously more often than full)
Job 3. Select Select Databases, select single SQL server along with its master, model and msdb, and Full as a backup type (scheduled every whatever days).And then restoring in case of total SQL failure takes two steps? (full servers first (as i back up whole AAG), then simple recovery model dbs).
VMWare support takes days to even take a look at a ticket, wondered if someone has a similar setup.
Thanks!
Kris
-
Sounds correct to me. Just be sure the SQL backups actually happen before the AAG cluster backup,
@Kris_K said in VDP MS SQL AAG backup best practices:
VMWare support takes days to even take a look at a ticket, wondered if someone has a similar setup.
You have the licensing to get a VMWare cluster and their support can't be bothered to respond for days? Something doesn't add up. Course it could be the shakeup with yet another new company owner (Dell).
-
@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?
-
@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.
