question

HoomanMoradmand-3099 avatar image
0 Votes"
HoomanMoradmand-3099 asked AmeliaGu-msft answered

Building an SQL DB cluster out of a standalone node

Hi,

We have an MS SQL database node (standalone). We are planning to make a cluster out of it with a VIP serving both servers. I have no idea why it was built as standalone in the first place since this is now production database. Is this easily possible? What are the high level steps for this? We'd need to replicate the steps in a dev environment first.

It seems that if there was an easy way it would go through AlwaysON. Thoughts on this is appreciated too.

Thanks,

Hooman

sql-server-generalwindows-server-clustering
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi HoomanMoradmand-3099,

Welcome to Microsoft Q&A.
Do you mean you want to upgrade a stand-alone instance of SQL Server to a failover cluster instance node?
No, I’m afraid it is not supported. Please refer to this doc for more details.
We need to create and configure a single-node SQL Server failover cluster instance, and then add the second node to the SQL Server failover cluster.
Please refer to the doc and some articles about Step-by-step Installation of SQL Server Failover Cluster part 1, part 2, part 3 and part 4, which might be helpful.

Best Regards,
Amelia


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.