作成時にデータベースの接続フェーズで SMSQL の検証が失敗します FCI 内のクローン
- Views:
- 195
- 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')"