使用SnapVault进行SCSQL二级备份的保留期限是预期保留期限的一半

适用场景

• 适用于Microsoft SQL Server的SnapCenter插件(SCSQL)
•  使用SnapVault创建二级备份

问题描述

• SCSQL二级备份 会 在预期保留期限的一半时间内被删除
• SCSQL会创建Snapshot副本 、名称末尾为_1 和_2

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 指示Db count in requested Job 大于 Max 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