About
Pricing
Community
Teams
Start Free Trial
Log in
CharlesH
asked on
12/15/2014
taking a vsphere snapshot of Sharpoint SQl servers inf Alwayson configuration.
we have two 2012 servers running SQL 2012 in an alwayson configuration which support our SharePoint farm.
We would like to take a snapshot for them before making some troubleshooting changes and want to know what the best practice is.
I am assuming that we should shut them both down before taking the snapshot.
Assuming this is correct, how do I go about shutting them down gracefully and then bringing them back up?
Microsoft SQL Server
Document Management
5
1
Last Comment
Aaron Tomosky
8/22/2022 - Mon
Aaron Tomosky
12/16/2014
Yes, this is a tricky situation. Basically VMware and Microsoft both say you shouldn't use snapshots for sql clusters.
https://social.technet.microsoft.com/Forums/sharepoint/en-US/e5abf633-9023-4f24-a707-2680cced28e8/sharepoint-farm-backuprestore-with-vmware-snapshots
http://www.vmware.com/files/pdf/solutions/SharePoint_2010-Availability-and-Recovery-Options.pdf
if you use netapp, they have this:
http://community.netapp.com/t5/SnapManager-SnapDrive-and-SnapProtect-Discussions/SMSP-amp-Sharepoint-2013/td-p/21575
If you have DPM:
http://technet.microsoft.com/en-us/library/hh757819.aspx
Here is the long way:
http://technet.microsoft.com/en-us/library/ff806332%28v=office.15%29.aspx
CharlesH
12/16/2014
ASKER
Hmm. yes, I see. Thank you. I am not sure I would want to have to do a restore but backing it up first just in case is not a bad idea.
Perhaps I could shut down the entire farm, snapshot everything and then do my updates/troubleshooting/fi
xes.
I could then shut it all back down and either remove or revert the snapshots. That might keep the timing issues at bay.
I would not want to run very long with a growing delta disk.
Do you have any instructions on shutting everything down? (SQL 2012 in an always on configuration.)
ASKER CERTIFIED SOLUTION
Aaron Tomosky
12/16/2014
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
CharlesH
12/22/2014
ASKER
We have not done the snapshot yet but this is probably the way we will go.
I wanted to make sure you got your points .
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Aaron Tomosky
12/22/2014
Thanks, let us know how it goes. The way MS designed Always-On is so that it is ALWAYS on.
https://social.technet.microsoft.com/Forums/sharepoint/en-US/e5abf633-9023-4f24-a707-2680cced28e8/sharepoint-farm-backuprestore-with-vmware-snapshots
http://www.vmware.com/files/pdf/solutions/SharePoint_2010-Availability-and-Recovery-Options.pdf
if you use netapp, they have this: http://community.netapp.com/t5/SnapManager-SnapDrive-and-SnapProtect-Discussions/SMSP-amp-Sharepoint-2013/td-p/21575
If you have DPM: http://technet.microsoft.com/en-us/library/hh757819.aspx
Here is the long way: http://technet.microsoft.com/en-us/library/ff806332%28v=office.15%29.aspx