THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Backup and the evil RETAINDAYS option

This blog has moved! You can find this content at the following new location:

Published Sunday, July 8, 2012 3:25 PM by TiborKaraszi

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Jeff Bennett said:

Thanks, Tibor.

That has always been confusing.  Appreciate the insight.

July 9, 2012 2:12 PM

Ian Yates said:

We're an ISV who uses SQL Server and I had noticed some of our client's IT staff had set this option in the maintenance plans and then complained that SQL wasn't cleaning up the old backups.  Rather than have a debate with them about it I've just started using Ola's scripts - they're great :)

July 10, 2012 12:22 AM

Roger said:

Clean, useful and experience-based explanation, thanks.

December 18, 2012 4:45 AM

sanjay dobriyal said:

thanks Tibor, very clear and nice article.

February 12, 2013 2:26 AM

Shivram said:

Thanks Tibor...yes, this option has been confusing. thanks for the insight.

September 17, 2013 7:44 AM

kishor said:

Hi Tibor..

Please Look into this ... i created a backup with expiration date.. after that date i used the same expired backup to restore a db and it worked.. SO what is the use of EXPIRATION here

December 19, 2013 2:33 PM

TiborKaraszi said:

The expiredate option *do not* make a backup non-restoreable after the date. The only thing it does is to prohibit overwriting it using INIT before the date occurs. As I stated, pretty useless...

December 19, 2013 2:38 PM

zzyytt said:">">">

June 8, 2018 7:38 PM

dongdong8 said:



June 29, 2018 2:50 AM

linying123 said:



July 16, 2018 8:34 PM

Leave a Comment

Privacy Statement