Saturday, April 9, 2011

How to find cluster node and its drive name in Sql QueryAnalyzer

select* from sys.dm_os_cluster_nodes
 --output
NodeName
if nodename have values-->server is clustered

or

select * from fn_virtualservernodes()
--output
NodeName


select* from sys.dm_io_cluster_shared_drives
--output
DriveName

If DriveName column have values-->Drive in sqlclustergroup

No comments:

Post a Comment

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...