To identify the Expiration date of database backup file

Answer:

- Normally, when we take a database backup, we can specify that, How long the Database backup file(.Bak) should be valid.
- After that, The backup file(.bak) no longer available...
- So, How to identity the Expiration date of a backup file(.bak) ?

RESTORE HEADERONLY FROM DISK='<Backup File Path.Bak>'

- It will return a result set with 52 columns, we have a columns like ExpirationDate.
- If the ExpirationDate column is null then, you have not specified any Expiration option while you took the backup.
- If the ExpirationDate column is some date then, The backup file no longer valid after the date specified.