Article ID: 295732 - View products that this article applies to.
This article was previously published under Q295732
After you install a SQL Server 2000 or SQL Server 2005 virtual server instance, you may want to create databases, or move existing data or log files onto a secondary shared cluster disk. To create databases, or move existing data or log files, the other disk that SQL Server is to use must be added as a dependency to the SQL Server resource in the Cluster Administrator.
If you attempt to create a database on another shared cluster drive when the SQL Server resource is not dependant on that disk, you may receive an error similar to:
A similar error is displayed when you try to move or add files to an existing database onto a shared cluster drive that is not in the SQL Server group and that also does not have the SQL Server resource dependence.
Server: Msg 5184, Level 16, State 2, Line 1. Cannot use file '%.*ls' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used.
Server: Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.
Additionally, if you try to create a full-text index catalog on a disk on which the SQL Server resource is not dependant, the following error is displayed:
Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line 61 Full-text catalog in directory 'Y:\FTDATA' for clustered server cannot be created. Only directories on a disk in the cluster group of the server can be used.
To add a disk as a dependency to the SQL Server, the shared cluster disk must reside in the same group in the Cluster Administrator as the SQL Server resources.
To move the shared cluster disk, select the disk you want to move to the SQL Server group, and then right-click that resource. Click Change Group. After the disk is in the same group in which the SQL Server resource resides, follow these steps to add it as a SQL Server dependency:
Article ID: 295732 - Last Review: June 7, 2006 - Revision: 7.2
Contact us for more help