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

Comments

Popular posts from this blog

SQL Server:Steps to Configure Database Mirroring by T-SQL Script.

SSIS2008R2 Error: 0xC0209303 at Package: