May 7, 2015 at 6:25 am
Hi,
How to set up SQL Server 2012 AlwaysOn Availability Groups for achieving as below scenario
1. Server1 – the primary production SQL Server in primary datacenter and data will be stored on a local storage (HDD).
2. Server2 – the secondary production SQL Server in same primary datacenter (High availability setup) and data will be stored on a local storage (HDD).
3. Server3- an offsite SQL Server in secondary datacenter (For DR setup) and data will be stored local storage(HDD)
If the production server crashed, need to failover automatically to a either second server or third server? does it possible to configure on availability group in local HDD level?
Thanks
May 7, 2015 at 8:32 am
You sound like you don't have experience here. I can tell you that there are MANY caveats, limitations, provisos and gotchas with Always On that will be VERY LIKELY to result in your not being successful with this endeavor without qualified, experienced help. I have seen failures over and over and over.
One great place to start is with our own Perry Whittle's Stairway series:
http://www.sqlservercentral.com/articles/FCI/107536/
AlwaysOn is based on local storage and windows failover clustering and uses glorified database mirroring under the covers.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply