Post reply

how to know the instance is a failover cluster?

  • August 5, 2010 at 4:20 am

    #142139

    Hi Friends,

    I want to know how to know my current instance is a failover cluster instance?

    sorry for my bad english.

    Thanks in advance.

    M.I.

    ________________________________________
    M.I.
    [font="Times New Roman"]

    Learning is a path with no destination...
    [/font]

  • August 5, 2010 at 4:29 am

    #1202610

    SELECT SERVERPROPERTY('IsClustered') as IsFailoverClusterNode

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 11, 2010 at 5:07 am

    #1205274

    Hi Gail,

    I want to know through which command i can know that my server instance is clustered or not....in SQL Server 2005

  • August 11, 2010 at 5:22 am

    #1205279

    The T-SQL I posted above does exactly that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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