大网数据广告活动
数据库与应用安全

Create databases or change disk file locations

· 52CE 我爱测

This article describes how to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed.

This article describes how to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed.

Original product version:   SQL Server
Original KB number:   295732

Summary

After you install a SQL Server virtual server instance, you may want to create databases, or move existing data or log files on to 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 dependent 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 selecting Bring Offline.
  4. Right-click the SQL Server resource, and then select Properties.
  5. Select the Dependencies tab.
  6. Select 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.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 10/30/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。