Hi Jan -

Thank you for your feedback. If I first create windows cluster, then how I would add storage of the existing nodes to the cluster if the drives are...

Perry -

I know this is an older post, but I want to ask about what if I setup a primary cluster, then add the two nodes to the cluster? When...

Jack - Many thanks to you, the query worked great.

Note: As I stated, I am using student/parent tbls scenario as an example. Once again, thanks.

Matt, thank you for your input, so I assume the answer is no for making an existing instance a primary node for the cluster. The primary cluster has to be...

Yes, that much I know and thank you for explaining it. I just still use the old terminology. However the question was not about how to setup the nodes. The...

Got it, thank you!

definitely.. I am taking backups prior to the upgrade and restore them else were in case of emergency. I already have two servers for that purpose.

Grant - Thank you. I already setup another environment to restore to in case of failure as I understood that there is not an easy way to rollout in-place upgrade...

Let me correct myself, there is a rollout plan however it is not simple. The process involved uninstalling SQL 2012, reinstalling SQL 2008 and restoring databases. I just did not...

Gail, I initially was confused but now I am clear. I already suggested moving the instance to other node. Thank you very much for clarification.

Perry -

Thanks for the clarification, I will then propose moving the instance.

As I stated, node 2 is passive. I understand you can just right click on the instance and tell it to move to second node.

The goal is to make...

Perry - Thank you.

Steve -

Question for you, I know this is an old post but I was curious about where you have two different nodes (node1 and node2) and having two sql instances...

Gail -

Thanks for your reply, that what the intension is but I guess due to licensing we might not do so.