You are currently offline, waiting for your internet to reconnect

How to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

This article was previously published under Q295732
SUMMARY
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:
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.
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.

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.
MORE INFORMATION
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:
  1. Open the Cluster Administrator.
  2. Make sure that all the physical disk resources that contain SQL Server databases are in the same group as the SQL Server resource.
  3. Right-click the SQL Server resource, and then bring the resource into an Offline state by clicking Bring Offline.
  4. Right-click the SQL Server resource, and then click Properties.
  5. Click the Dependencies tab.
  6. Click Modify to add the disk to the dependencies list for that resource.
  7. Bring the SQL Server resource back online, and then put the SQL Server files on that shared cluster disk.
Properties

Article ID: 295732 - Last Review: 06/07/2006 15:55:13 - Revision: 7.2

Microsoft SQL Server 2000 Enterprise Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition

  • kbhowto kbsql2005cluster kbinfo KB295732
Feedback
/html>tml>p;did=1&t=">