Solved

How can I transition from a Windows Server 2012, 2-physical node Windows Failover Cluster, running SQL 2012 in cluster mode, to an AlwaysOn SQL 2012 Availability Group?

Posted on 2014-09-17
3
143 Views
Last Modified: 2015-03-01
I'm trying to transition from a Windows Failover Cluster running SQL 2012 in a clustered installation as a role between two physical nodes, 1x active and 1x passive/standby, to a SQL 2012 AlwaysOn Availability Group, such that I could add a third read-only node, as well as have true high availability.

As it currently stands, while failover is fast (less than 60 seconds) between node01 and node02 when migrating the SQL Server role, it's still a piece of the environment that is not truly highly available, such that maintenance or restarts could be performed on nodes at any point, without any interruption.

I've been unable to find any real guides for how to do this, only guides for how to setup a NEW SQL AlwaysOn availability group.

My desire though is to keep the current SQL instance name, and have a transition to AlwaysOn with the smallest amount of downtime possible (would be even better if it would be possible to do it without any downtime, but I'm realistic that it probably will require downtime).

How would I best go about doing something like this?

0
Comment
Question by:Ntiva
3 Comments
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 50 total points
ID: 40328248
I never did that but from what I read you are going to have a lot of work to do.
Check the SQL AlwaysOn Team Blog
0
 

Author Comment

by:Ntiva
ID: 40328342
Thanks Vitor for the link,

I've actually seen that blog series before, and while it appears to be fairly similar to what I'm trying to accomplish here, it is slightly different, as they begin with two Windows Failover Cluster's with database mirroring already in place, whereas I'm coming from a single 2-node FC without any mirroring.

While I could most likely adapt that to suit my needs, I'm still hoping that there is something else out there that exists, or someone who has done something similar to what I'm attempting to do now.
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 450 total points
ID: 40339644
Maybe I can clear something up - you are setting up a new Availability Group, but you can do it using an existing database (or set of databases). In this case, you can just use a new server, set up SQL Server on it, and then use that instance as your "mirror" or "secondary" instance of SQL, where you FCI is your primary database instance. Since an FCI can participate in an AG as one of the members, I think that would work. I'm not sure if you can use the same two nodes that are currently participating in your FCI, but assuming you want to and that's possible, here's what you'd do (assuming you have Node A and Node B):

1. Install a new stand-alone instance of MSSQL on Node A
2. Set up copy of database and configure users on new instance
3. Set up AlwaysOn AG, using FCI as primary and new instance as secondary
4. Ensure database is up to date and replicating properly
5. Repeat steps 1 and 2 on Node B
6. Add new instance on node B to existing AG from step 3
7. Confirm all instances are working in AG
8. Remove your FCI from the AG, making one of the other instances primary
9. If desired, install MSSQL on Node C and add it to the AG

There's no reason you couldn't seamlessly migrate to new instances using those steps. If for some reason you can't set up an AG on an existing cluster, you could extend the database onto Node C, destroy the cluster, and then set up two new instances of MSSQL and create an AG that includes all three of those servers.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

708 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

12 Experts available now in Live!

Get 1:1 Help Now