Here I am planning to upgrade my stand alone server(Server A) to Active-Passive cluster. I have already got four SQL R2 instances on my stand alone server and now my requirement is not to take offline the existing 4 instances for more than 2 hrs while make it cluster.
OS : Windows R2 Enterprise
SQL : SQL Server 2008 R2 Enterprise
My approach is :
1. First making a windows cluster by adding a windows node(Server B) with existing server (Server A). (Still the SQL Server instances are not cluster aware and running on server A) Now the cluster is windows cluster NOT Sql server cluster ware.
2. Install four SQL Server single node cluster instances on Server B (not adding the other node)
3. Detach databases from SQL Instances on server A and attach them to Single node cluster instance on Server B and Server B will be active node (now my services will point to the cluster)
4. Later will add SQL cluster nodes on Server A using ADD node installation option.
Please let me know will this approach will work?
Thanks for your help.