Backup set expire option – Backup SQL Server 2012

Posted on

Question :

I had seen an option while taking a backup i.e. set backup expire date, I have a doubt. What does this mean:

  1. Backup will be no longer valid after date DD/MM/YYYY?
  2. Backup declared with option, is it valid file to restore?
  3. Can we store this backups for 1 year after expire date option is given and restore?
  4. can Expired Backups(not deleted/purged) restored, any cons or limitations?

Any links to this concept also appreciated, which helps many junior DBA’s.

Thanks to all.

Answer :

Answered here by @JamesAnderson

The “Backup set will Expire” option is used to indicate how long a backup should be prohibited from being over written. It will not clean up old backup files. You can use the “Maintenance Clean up Task” in your maintenance plan to clean up backups files older than a certain number of days.

What is the use of “Backup set will Expire:” option while creating Backup Database task in Maintenance plan

Leave a Reply

Your email address will not be published. Required fields are marked *