You are here

Delete 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.
Category: