SQL Server 2005 Cluster on WIndows 2003 Server

  • Hi,

    How to know which node is active and which node is passive without using any GUI tool of cluster? Can I find the information of failover and failback in any log file when failover\failback happened ?

    Thanks in advance.

  • The cluster.log file holds detailed information on cluster actions. This file is found in

    C:\Windows\Cluster

    To check the status of cluster groups and which node they are online on, use the following from a command prompt

    cluster group /stat

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

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

  • beejug1983 (7/9/2011)


    Hi,

    How to know which node is active and which node is passive without using any GUI tool of cluster? Can I find the information of failover and failback in any log file when failover\failback happened ?

    Thanks in advance.

    If you want to do this without code you would need to view the relevant cluster group in 'Cluster Administrator.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • He didn't want to use the GUI tool 😉

    Use:-

    Select ServerProperty('ComputerNamePhysicalNetBIOS')

  • jasonmorris (7/12/2011)


    He didn't want to use the GUI tool 😉

    Use:-

    Select ServerProperty('ComputerNamePhysicalNetBIOS')

    ooops, my bad.

    read to quickly.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

Viewing 5 posts - 1 through 4 (of 4 total)

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