Shared disks that can be used to hold data and log for a failover cluster

Applies to:  SQL Server 2005, SQL Server 2000.

The following dynamic management view in SQL Server 2005 (DMV) returns all of the shared disks that can be used to hold data and log for a failover clsuter instance of SQL Server.

The user must have the VIEW SERVER STATE permission to access this DMV.
 

USE Master

SELECT * FROM sys.dm_io_cluster_shared_drives

Meanwhile, the following system function has the same results in SQL Server 2000

SELECT * FROM fn_servershareddrives()
 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.