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



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

dongdong8 said:



July 23, 2018 11:29 PM

shenyuhang said:


July 23, 2018 11:34 PM

Yeezy Supply said: Jordan 11 Win Like 82 Nike Outlet Store Nike Outlet Store Yeezy Yeezy Moncler UK Yeezy Boost 350 Yeezy Boost 350 V2 Birkenstock Oakley Outlet Nike Outlet Online"> nike clearance Off White Jordan 1 Nike Air Max Yeezy Boost 350 Air Max 97 jordan 12 bordeaux Yeezys Nike Shoes Nike Outlet Air Max 2017 Moncler Jackets Yeezy Boost 350 V2 Jordan 12 Win Like 82 Jordan 11 Win Like 82 jordan 4 Nike Clearance Moncler UK Yeezy Nike Outlet Store Online Shoping Birkenstock Shoes jordan 12 ovo Nike Air Max 2017

July 25, 2018 5:14 AM
New Comments to this post are disabled
Privacy Statement