[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Shared Drives of a SQL Failover Cluster

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.