how to know the instance is a failover cluster?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » how to know the instance is a failover...

how to know the instance is a failover cluster?

Rate Topic

Display Mode

Topic Options

Author

Message

MSQLDBA

Posted Thursday, August 05, 2010 4:20 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 21, 2012 8:49 AM
Points: 129, Visits: 551

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.

Learning is a path with no destination...

Post #964109

GilaMonster

Posted Thursday, August 05, 2010 4:29 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 37,686, Visits: 29,943

SELECT SERVERPROPERTY('IsClustered') as IsFailoverClusterNode

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #964116

mohd.sql

Posted Wednesday, August 11, 2010 5:07 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, March 18, 2013 1:54 AM
Points: 12, Visits: 177

Hi Gail,

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

Post #967307

GilaMonster

Posted Wednesday, August 11, 2010 5:22 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 37,686, Visits: 29,943

The T-SQL I posted above does exactly that.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #967314

« Prev Topic | Next Topic »

Permissions