To identify the Expiration date of database backup file

 Posted by PandianS on 12/8/2010 | Category: Sql Server Interview questions | Views: 4123 | Points: 40
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 

Comments or Responses

Login to post response