Twitter
Google
RSSDelete SQL Server old backups automatically.
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 dose not run, it will not be deleted.
Importance:
- Please ensure you have a 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 a same database , please also ensure these jobs have identical expiration setting and you have a latest full backup after deletion.
