December 19, 2011 at 10:43 pm
i just want to know, when we take a backup of any database, there is a option where we can set the value of BACKUP SET WILL EXPIRE.
what is the mean of that? , is it automatically delete the backup file or it is there but not used to restore.
waiting for reply.. :hehe:
thanks
DHIRJU
December 19, 2011 at 10:54 pm
Per BOL:
{ EXPIREDATE = 'date'| RETAINDAYS = days }
Specifies when the backup set for this backup can be overwritten.
December 19, 2011 at 11:03 pm
sory dev but i m not getting 🙁
December 19, 2011 at 11:15 pm
Dhirju (12/19/2011)
sory dev but i m not getting 🙁
No Problem. 🙂
Giving a small exercise to you. Create a backup with tomorrow’s expire date. Then try to overwrite it in another backup operation.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply