Transactional Consistency SQL/Sharepoint

VMware specific discussions

Transactional Consistency SQL/Sharepoint

Veeam Logoby gingerdazza » Thu Sep 17, 2015 11:01 am

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....
gingerdazza
Expert
 
Posts: 101
Liked: 3 times
Joined: Tue Jul 23, 2013 9:14 am
Full Name: Dazza

Re: Transactional Consistency SQL/Sharepoint

Veeam Logoby foggy » Fri Sep 18, 2015 11:51 am 1 person likes this post

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.
foggy
Veeam Software
 
Posts: 14752
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Transactional Consistency SQL/Sharepoint

Veeam Logoby gingerdazza » Fri Sep 18, 2015 12:56 pm

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
Expert
 
Posts: 101
Liked: 3 times
Joined: Tue Jul 23, 2013 9:14 am
Full Name: Dazza

Re: Transactional Consistency SQL/Sharepoint

Veeam Logoby gingerdazza » Fri Sep 18, 2015 12:58 pm

foggy wrote: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 :)
gingerdazza
Expert
 
Posts: 101
Liked: 3 times
Joined: Tue Jul 23, 2013 9:14 am
Full Name: Dazza

Re: Transactional Consistency SQL/Sharepoint

Veeam Logoby foggy » Fri Sep 25, 2015 12:48 pm

Another point is that we support only BLOBs with Microsoft RBS FILESTREAM provider, which can be used either locally or via iSCSI.
foggy
Veeam Software
 
Posts: 14752
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 22 guests