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

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)