SQL Script to check SQL Server Shared Drive Information

Leave a comment (0) Go to comments

In past, I have already posted an Article on SQL Script to check SQL Server cluster Nodes, this time, I want to share SQL Script for finding Cluster Shared Drives.

SQL Script to Find SQL Server Cluster Shared Drives

-- SQL Script to Find SQL Server Cluster Shared Drives, Using Function
SELECT * FROM fn_servershareddrives()

-- SQL Script to Find SQL Server Cluster Shared Drives, Using DMV
SELECT * FROM sys.dm_io_cluster_shared_drives
EOF - SQL Script to check SQL Server Shared Drive Information, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.