I am exploring an option to create SQL cluster with active/passive node on an already existing cluster.
Here is the scenario:
Existing: Server 1 is Active and server 2 is passive
Required: I need to add discs and on separate resource group I want to create Server 2 as active with different SQL server instance, of course, and Server 1 will be passive node for this cluster.
I have done a lot of research on this and I think is it possible.
Please provide some points to consider before going ahead with this plan, I cant afford to mess up on this one.
Response is much appreciated.