Retention period for SCSQL secondary backup using SnapVault is half the expected
Applies to
- SnapCenter Plug-in for Microsoft SQL Server (SCSQL)
- Taking secondary backups using SnapVault
Issue
- SCSQL secondary backups are deleted in half the expected retention period
- SCSQL creates Snapshot copies with
_1
and_2
at the end of the name
cluster1::> snapshot show
---Blocks---
Vserver Volume Snapshot Size Total% Used%
-------- -------- ------------------------------------- -------- ------ -----
svm1_cluster1
sql1_db
ResourceGroup_SQL1_09-03-2024_00.58.34.6046_1
660KB 0% 0%
ResourceGroup_SQL1_09-03-2024_00.58.34.6046_2
220KB 0% 0%
SmSql_<JOBID>.log
indicates thatDb count in requested Job
is greater thanMax Db Per SnapShot
DEBUG SmSql_<JOBID> PID=[<PID>] TID=[<TID>] Max Db Per SnapShot is: 100
DEBUG SmSql_<JOBID> PID=[<PID>] TID=[<TID>] Db count in requested Job: 105, DB count in running jobs: 0