?
Solved

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

Posted on 2014-12-15
5
Medium Priority
?
189 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Assume you have an outside contractor who comes in seasonally or once a week to do some work in your office, but you only want to give him access to the programs and files he needs and keep all other documents and programs private. Can you do this o…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

771 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