SCSQL clone operation - Failed to find backup
- Views:
- 53
- Visibility:
- Public
- Votes:
- 0
- Category:
- snapcenter
- Specialty:
- snapx
- Last Updated:
- 5/27/2024, 5:36:15 PM
Applies to
SnapCenter Plugin for SQL (SCSQL)
Issue
- SnapCenter topology view of a database shows a count of “0” backups however all the successful backups are listed:
- SCSQL database clone operations for the database fail with error, "
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)