Failover Node manually

  • When you Failover Node manually to another node, do we login to the server with virtual name

    or physical name or would it matter at all?

    And once we failover cluster to another node and to re-start the server we remote in with physical name?

  • The name associated with the cluster will always log you into the active node; the server's dns name will always log you onto the server.

    Assume you have 2 servers:

    SERV-SQL01

    SERV-SQL02

    They are members of a cluster group:

    CLUSTER-SQL

    Assuming SERV-SQL01 is active, you could access it with either SERV-SQL01 or CLUSTER-SQL.

    When you fail the node to SERV-SQL02, you could access the ACTIVE node with either SERV-SQL02 or CLUSTER-SQL.

    If you want to log into the passive node, you need to use the node name of the passive server.

    Hope that helps! if i misunderstood the question, please clarify.

  • PJ_SQL (4/17/2015)


    When you Failover Node manually to another node, do we login to the server with virtual name

    or physical name or would it matter at all?

    If you want to fail over the instance then logon to one of the cluster nodes via their nodename, then move the group.

    If you logon using the clustered instances Virtual Networkname you'll get disconnected when the resource goes offline.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply