SnapCenter Backups report success but no snapshot created on storage
Applies to
- Snapcenter 4.3.X and higher
- Snapcenter Plug-in for SQL Server [SCSQL] 4.3.X and higher
Issue
SnapCenter reports backup as successful up to version 4.4, even though SCSQL is unable to quiesce the SQL database and the snapshot operation creation is skipped, not backing up any databases and with no snapshots created on the storage.
SnapCenter 4.5 and higher fail the backup.
Underlying errors seen are:
- SmSQL_<JOB_ID>.log
INFO SmSql_14174 PID=[6476] TID=[38] Database: [<INSTANCE>\<Database>]ERROR SmSql_14174 PID=[6476] TID=[38] Could not load file or assembly 'SmSqlVdiCore.dll' or one of its dependencies. is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)ERROR SmSql_14174 PID=[6476] TID=[38] Quiesce function failed to executeDEBUG SmSql_14174 PID=[6476] TID=[38] Quiesce Done- Smcore _<JOB_ID>.log
DEBUG SMCore_14174 PID=[8040] TID=[3] Invoked service successfullyINFO SMCore_14174 PID=[8040] TID=[3] Activity - Creating Snapshot copy, Checking CanExecuteDEBUG SMCore_14174 PID=[8040] TID=[3] SkipSnapshot? : TrueDEBUG SMCore_14174 PID=[8040] TID=[3] Returning from CanExecute of CreateSnapshotINFO SMCore_14174 PID=[8040] TID=[3] Activity - Creating Snapshot copy, SkippedINFO SMCore_14174 PID=[8040] TID=[3] Activity - Unfreeze database(s), Checking CanExecute
