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.
Asked In: Many Interviews |
Alert Moderator