Hello my followers today my post is very simple post but more helpful and more important to know by the easiest way what is the shared disks on SQL Server cluster you manage it .

USE master
FROM sys.dm_io_cluster_shared_drives
FROM fn_servershareddrives()

this script will return the Shared drive names on your SQL Server cluster


Follow the author:

View all my tips , LinkedIn Website Slideshare  , ABOUT ME

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.