メインコンテンツまでスキップ

作成時にデータベースの接続フェーズで SMSQL の検証が失敗します FCI 内のクローン

Views:
69
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."

  • 検証は、を使用して SMSQL をインストールしていない SQL Management Studio で実行されます 以下のコマンドも同じエラーで失敗します
    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