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
154 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 48

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
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…

830 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