跳转到主内容

创建时, SMSQL 验证在连接数据库阶段失败 FCI 中的克隆

Views:
11
Visibility:
Public
Votes:
0
Category:
snapmanager-for-microsoft-sql-server
Specialty:
snapx
Last Updated:

适用于

  • SnapManager for SQL ( SMSQL ) 7.2.x 及更高版本
  • SQL 故障转移集群( FCI )

问题

  • 在该过程的连接数据库阶段,验证失败
  • SMSQL 作业报告中显示错误:

    "[23:02:03.353]  [hostname] Attaching database [database_name_Clone]...
    [23:02:03.353]  [hostname] CREATE DATABASE [database_name_Clone] ON PRIMARY (NAME = 'database_name', FILENAME = 'disk_name') LOG ON (NAME = 'database_name_log', FILENAME = 'disk_name.LDF') FOR ATTACH
    [23:02:03.368]  [hostname] [SQL SMO Error]: An exception occurred while executing a Transact-SQL statement or batch.
    Cannot use file 'disk_name' 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 Sql Server does not have a dependency on it.
    [23:02:03.368]  [hostname] DBCC CHECKDB (database_name__Clone') WITH NO_INFOMSGS, PHYSICAL_ONLY
    [23:02:03.384]  [hostname] [SQL SMO Error]: An exception occurred while executing a Transact-SQL statement or batch.
    Could not find database 'database_name__Clone'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.
    [23:02:03.384]  [hostname] WARNING: SQLServer DBCC CHECKDB failed."

  • 通过 SQL Management Studio 执行验证,而不使用 SMSQL 以下命令同样失败,并显示相同错误
    CREATE DATABASE [database_name] ON PRIMARY(NAME = N'database_name', FILENAME = N'database_path.mdf'  ) LOG ON(NAME = N'database_name_log', FILENAME = N'N:\SQLLOG\database_path_log.ldf')"

 

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device