Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2014-12-15
5
Medium Priority
?
193 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
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 39

Accepted Solution

by:
Aaron Tomosky earned 2000 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 39

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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
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.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

636 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