Categories

Follow our news:

Follow canonburysvcs on Twitter Follow Canonbury Services on Facebook Follow Canonbury Services' news by RSS Follow Canonbury Services' news by Atom Follow Canonbury Services' news by email

NEWS & TECH BLOG

Deleting old backups in SQL 2008

15/02/2011 – in OS / Environment

Many people have found that SQL maintenance plans in SQL Server 2008 won’t delete old backups.

The solution is to pay careful attention to the extension that the plan is being told to look for. By default, most people type in ‘.bak’, ie with a dot. Don’t. Just tell it to look for bak without the dot and it should work.

Share