1) How do I check the Cluster Configuration: Active/Active or Active/Passive - without trying to failover databases and running them - is this information stored as a property on in the registry somewhere? 2) Also I have noticed someone has created 2 servers or instances named 'DBA' and 'DBARREPORTS' - is this just 2 instances? I'm not sure but can they create a named instance with a slightly different virtual server name - such as DBAR and not DBA??? Thanks
In cluster you should have different virtual names for two instances... In your case it is active/active, you check Service Management where you can see two SQL instances. Now it not called active/active or active/passive anymore...it is called single/mulit node cluster....