June 23, 2011 at 6:52 am
Hi All,
Lets take a small scenario, suppose if we have a SQL Server Standalone instance, can we change(Or upgrade) it into Cluster instance?
Thank You.
Regards,
Raghavender Chavva
June 23, 2011 at 6:55 am
there is no direct upgrade path.
you will need to install a clustered sql instance on top of a windows cluster.
---------------------------------------------------------------------
June 23, 2011 at 7:07 am
There’s no way to easily flip a standalone SQL Server instance to a clustered instance. However moving a standalone instance into a clustered instance isn’t that tough, but it will require some down time to the clients.
If you need to allow the clients to connect to the same name and IP address then this gets a little more complex, but is still easily do able. In this post I’m assuming that you don’t need to keep the name and IP address. I’ll post another post later on which covers that situation.
The easiest and least impacting way to handle this migration is to build the machine which currently isn’t doing anything as a single node SQL Cluster. This will let you build the machine in advance and let you handle the database migration from the standalone machine to the cluster. After you have build the cluster and brought it online, you can detach the database from the standalone machine and attach it to the clustered instance. Once you are sure that the clustered instance is working for you, you can uninstall the standalone instance. You can then add the machine to the cluster, then install the SQL Service on the second node of the cluster.
Regards,
Vamsi Krishna S
MS SQL Server DBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply