August 18, 2015 at 7:26 am
Hi,
We have 4 node cluster with sql cluster in always on. How do you maintain an this hadr? In addition to that we are using logshipping to different server from primary
August 18, 2015 at 7:42 am
ramana3327 (8/18/2015)
Hi,We have 4 node cluster with sql cluster in always on. How do you maintain an this hadr? In addition to that we are using logshipping to different server from primary
So you have THREE different things going on, each of which is a complex (VERY complex in the case of AG and moderately complex for sql clustering) subsystem, AND each of which interact with and affect the others (if AG fails over, how would log shipping work then?) that is the backbone of your company's HA/DR scenario(s) - meaning if it fails you could cause the entire company to go out of business - and you are asking about how to maintain it using a free forum post?!?!?!?!?!?!? :hehe:
You REALLY REALLY REALLY need to get professional help for such a complex undertaking!!!!!!! You cannot POSSIBLY be successful without that. Sorry to be blunt, but I have seen so many messes from such stuff, including companies GOING OUT OF BUSINESS!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
August 18, 2015 at 7:55 am
AlwaysOn failover clustering with a 4 node cluster?
AlwaysOn Availability Groups with a principle replica and three secondary replicas?
Or do you really have Availability Groups and failover clustering mixed? The principle replica on the 4-node cluster and the async replica elsewhere.
You need to be specific when asking for help. AlwaysOn is not a technology, it's a marketing term with multiple different actual meanings.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 18, 2015 at 10:19 am
TheSQLGuru (8/18/2015)
(if AG fails over, how would log shipping work then?)
It involves a special LS configuration and requires in depth knowledge
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 18, 2015 at 10:27 am
Perry Whittle (8/18/2015)
TheSQLGuru (8/18/2015)
(if AG fails over, how would log shipping work then?)It involves a special LS configuration and requires in depth knowledge
Yes, yes it does! 😎
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply