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?
LVL 1
CharlesHAsked:
Who is Participating?
 
Aaron TomoskyConnect With a Mentor SD-WAN SimplifiedCommented:
I believe the right way is to do a "planned manual failover"
http://msdn.microsoft.com/en-us/library/hh231018.aspx

Turn off the secondary
Turn off the primary
snapshot
turn on the primary
turn on the secondary
go back to automatic

Disclaimer: This is all based on my limited research, there isn't much available and I've never done this personally.

Edit: you can also take an availability group offline, this might be better:
http://msdn.microsoft.com/en-us/library/jj573599.aspx
0
 
CharlesHAuthor Commented:
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/fixes.

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.)
0
 
CharlesHAuthor Commented:
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 .
0
 
Aaron TomoskySD-WAN SimplifiedCommented:
Thanks, let us know how it goes. The way MS designed Always-On is so that it is ALWAYS on.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.