question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

AlwaysOn with single node possible?

I am currently reviewing a SQL2012 migration plan which is a migration from a traditional 2-node 2008R2 cluster to a 2012 2-node AlwaysOn solution. The idea is to dismantle the cluster and convert the 2nd server to SQL2012 including AlwaysOn. After the databases are migrated, the first server is also converted and added to the AlwaysOn group. But is this method possible? AFAIK you can't create a single node AlwaysOn cluster.
migrationalways-onclustering
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This is something I was wondering about recently, but never got round to trying out. The thought occurred to me that it might (might) be possible to do this with a second (named) instance on the first server you migrate... ...but, as I said, I never got further than having that thought. I await a real answer with interest.
0 Likes 0 ·

1 Answer

· Write an Answer
H_G_H avatar image
H_G_H answered
this documentation my help " http://msdn.microsoft.com/library/hh781257.aspx" . You need to enable the Failover Clustering feature on nodes and create and validate the Windows Failover Cluster. then install SQL Server onto the cluster (you tell the SQL Server installation using GUI installing it on the cluster using Wizard . Hope this help .. Good Luck HG
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.