I don't use VM backup for any of our SQL farms; as we use guest NW for SQL we use the same for DR so all our VMs running SQL are on so called nosnapshot datastores (eg. I run TLOG every 1h for all databases). If I were you, I would rather make possible that I increase capacity of storage node (I do not use storage nodes any longer as with ddboost there is no need for those).
As for scheduling, I believe you could do something like that, but with external scheduler only. (unless you have situation where you set frequency to 2h and you set vm backup to run between those 2 hours frame - assuming and hoping such backup would complete in that range).
ble1
4 Operator
•
14.4K Posts
0
September 28th, 2016 13:00
I don't use VM backup for any of our SQL farms; as we use guest NW for SQL we use the same for DR so all our VMs running SQL are on so called nosnapshot datastores (eg. I run TLOG every 1h for all databases). If I were you, I would rather make possible that I increase capacity of storage node (I do not use storage nodes any longer as with ddboost there is no need for those).
As for scheduling, I believe you could do something like that, but with external scheduler only. (unless you have situation where you set frequency to 2h and you set vm backup to run between those 2 hours frame - assuming and hoping such backup would complete in that range).