Transactional Consistency SQL/Sharepoint

[gingerdazza]

In an environment whereby you have a SharePoint VM, a SQL VM, and perhaps even a VM for BLOB storage, what tactics can be employed to keep the entire SharePoint stack transactionally consistent? This seems quite a difficult objective without storing all these VMs on the same SAN LUN and using SAN snapshots....

[foggy]

You would need to freeze SharePoint farm activities first (via some pre-job script), then backup all VMs simultaneously, and finally unfreeze SharePoint, once the snapshots of all VMs are taken.

[gingerdazza]

The other alternative I can think of is to have the entire sharepoint stack of VMs in a Zerto VPG. (Sorry if that five letter word is blasphemous round here)

[gingerdazza]

You would need to freeze SharePoint farm activities first (via some pre-job script), then backup all VMs simultaneously, and finally unfreeze SharePoint, once the snapshots of all VMs are taken.

....this makes frequent SharePoint PIT protection verrrry difficult. You can't be having hourly outages

[foggy]

Another point is that we support only BLOBs with Microsoft RBS FILESTREAM provider, which can be used either locally or via iSCSI.