A key feature of SQL Server Backup is that it can delete expired backup automatically. This feature can save and reuse your storage space, need not worry about the storage space problem.
When a job's backup is expired, it is deleted at the end of the job. If this job does not run, it will not be deleted.
Importance:
When a job's backup is expired, it is deleted at the end of the job. If this job does not run, it will not be deleted.
Importance:
- Please ensure you have the latest full backup, or the database can be risky because database restoration required a full backup at least.
- If backup and log shipping jobs are defined on the same database, please also ensure these jobs have identical expiration settings and you have the latest full backup after deletion.