SCSQL克隆操作-找不到备份
适用场景
适用于SQL的SnapCenter插件(SCSQL)
问题描述
- 数据库的SnapCenter拓扑视图会显示"0"个备份计数、但会列出所有成功的备份：
- 对数据库执行SCSQL数据库克隆操作失败、并显示错误""
Failed to find backup '<BACKUP NAME>' for resource '<INSTANCE NAME\DATABASE NAME>'。
SnapManagerWeb_XXXXXX.log：
2024-05-20T15:58:43.8173367+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] DALHelper - GetBackup Start2024-05-20T15:58:43.8223377+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] Querying primary backup <nsm_Backup_Id #>2024-05-20T15:58:43.8236791+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] Querying objects2024-05-20T15:58:43.8244039+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] Querying objects from host resource mapping2024-05-20T15:58:43.8244039+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] Querying SQL Database <INSTANCE NAME\DATABASE NAME> registered with host <OLD WINDOWS CLUSTER NAME>2024-05-20T15:58:43.8353361+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] Object queried is <INSTANCE NAME\DATABASE NAME> host is <OLD WINDOWS CLUSTER NAME>2024-05-20T15:58:43.8353361+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] Checking hostResource.AppObjects.First().Host <ORIGINAL/STALE nsm_sm_oject_id #> object type 22024-05-20T15:58:43.8393340+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] GetSqlResourceBySmObjectId Start2024-05-20T15:58:43.8403344+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] FindDatabaseBySmObjectId Start2024-05-20T15:58:43.8743357+02:00 INFO SnapManagerWeb_XXXXXX PID=[23616] TID=[56] SmSqlDb with database name=<DATABASE NAME>2024-05-20T15:58:43.8753361+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] GetSqlResourceBySmObjectId End2024-05-20T15:58:43.8763329+02:00 DEBUG SnapManagerWeb_XXXXXX PID=[23616] TID=[56] SmObject is <INSTANCE NAME\DATABASE NAME> clonelevel is 02024-05-20T15:58:43.8863361+02:00 ERROR SnapManagerWeb_XXXXXX PID=[23616] TID=[56] Failed to create clone request. System.Exception: Failed to find backup '<BACKUP NAME>' for resource '<INSTANCE NAME\DATABASE NAME>'at SnapManager.SMSDAL.CloneHelper.GetBackupInfo(SmBackupInfo backupInfo, SmCreateCloneRequest inputRequest, SmCloneConfiguration cloneConfiguration)at SnapManager.SMSDAL.CloneHelper.CreateCloneRequestsForHosts(SmCreateCloneRequest inputRequest)