Solved

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

Posted on 2014-12-15
5
165 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
This article shows how to convert a multi-page PDF file into multiple image files, with one image file created for each page of the PDF. It does this by utilizing an excellent, free software package called GraphicsMagick. The solution is amazingly s…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

911 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now