Solved

taking a vsphere snapshot of Sharpoint SQl servers inf Alwayson configuration.

Posted on 2014-12-15
5
171 Views
Last Modified: 2014-12-22
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?
0
Comment
Question by:CharlesH
  • 3
  • 2
5 Comments
 
LVL 38

Expert Comment

by:Aaron Tomosky
ID: 40503462
0
 
LVL 1

Author Comment

by:CharlesH
ID: 40503518
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
 
LVL 38

Accepted Solution

by:
Aaron Tomosky earned 500 total points
ID: 40503573
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
 
LVL 1

Author Closing Comment

by:CharlesH
ID: 40513902
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
 
LVL 38

Expert Comment

by:Aaron Tomosky
ID: 40513915
Thanks, let us know how it goes. The way MS designed Always-On is so that it is ALWAYS on.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Online collaboration can help businesses be more efficient, help employees grow their skills and foster a team environment.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question