Do not expect new SQL snapshot retention categories to relabel older points

Source facts

In Azure Backup’s SQL Server instance snapshot preview, a retention-setting change applies to existing and future recovery points. However, a weekly, monthly or yearly retention category newly added to an existing policy applies only to future points. Microsoft documents policy management through the Recovery Services vault and says SQL instance snapshot backup management is not supported in Resiliency. Microsoft Learn.

Applicability

Keep this decision specific to SQL Server instance snapshot backup, which the source labels preview. Identify the current policy, proposed category and recovery points whose treatment matters; do not substitute the streaming-database policy procedure.

DSE recommendation

Separate a retention-duration edit from adding a new retention category in the change assessment. Ask the backup owner to state which existing points the change is expected to affect. Compare that expectation with the category boundary before approving a revised policy. If an older point is needed for a recovery obligation, confirm its actual retained status rather than assuming the newly added schedule will cover it. Preserve the original policy and recovery-point inventory for comparison.

Verification

In an approved preview evaluation, record representative existing points before the edit and inspect them afterward. Separately examine points created after the new category takes effect. Compare observed retention with the documented distinction and the approved recovery requirement. Escalate any mismatch before treating the revised policy as evidence of historical coverage; do not delete older recovery data as part of this test.

Official references

Microsoft Learn: Manage and monitor SQL Server database and instance snapshot (preview) on an Azure VM.