I had seen an option while taking a backup i.e. set backup expire date, I have a doubt. What does this mean:
- Backup will be no longer valid after date DD/MM/YYYY?
- Backup declared with option, is it valid file to restore?
- Can we store this backups for 1 year after expire date option is given and restore?
- 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.