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.


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

|improve this answer|||||
  • so i can use the backup to restore as valid file until i purge/delete permanently am i correct? – Siva Aug 19 '16 at 10:17
  • 1
    It doesn't have anything to do with being able to 'restore' the backup. It's a protection mechanism to make sure that backup set cannot be overwritten by a new backup until that expiration date. – Scott Hodgin Aug 19 '16 at 10:22
  • Yes, as @Scott Hodgin said, consider it an "Overwrite allow date" and not a "this backup will no longer restore" date. – MguerraTorres Aug 19 '16 at 13:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.