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.
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
questions or comments about this web site.