Best practice regarding the dependency to the SQL Server resource for the additional disk.

If a non-SQL Server resource needs to be added to the SQL Server group and depends on the SQL Server resource being available, Microsoft recommends that you add a dependency on the SQL Server Agent resource instead of adding a dependency on the SQL Server resource.

In the case where, by mistake, you change the dependency of one disk of SQL Server, you will get the error message below.

Error 5184: Cannot use file '%.*ls' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sq...

So take care when you play with the dependency to the SQL Server resource.


See also :
- How to: Add Dependencies to a SQL Server Resource
- How to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed


Michel Degremont| Microsoft EMEA
Product Support Services Developer -SQL Server Core Engineer |