Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to know the instance is a failover cluster? Expand / Collapse
Author
Message
Posted Thursday, August 5, 2010 4:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 5, 2015 2:01 AM
Points: 134, Visits: 574
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
Posted Thursday, August 5, 2010 4:29 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 41,874, Visits: 38,536
SELECT SERVERPROPERTY('IsClustered') as IsFailoverClusterNode




Gail Shaw
Microsoft Certified Master: SQL Server, 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
Posted Wednesday, August 11, 2010 5:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, August 11, 2010 5:22 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 41,874, Visits: 38,536
The T-SQL I posted above does exactly that.


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

Add to briefcase

Permissions Expand / Collapse