SQL 2005 - Maintenance Plans - Only Keep 5 Backups? 1

[gavm99]

Hi all,

With SQL 2000 I used to configure my maintenance plans so that only the last 5 backups are stored on the local machine.

With SQL 2005 there does not appear to be this option when using the Maintenance Plan wizard, therefore I will potentially fill up all my diskspace and cause another headache.

Any ideas if this option is avaliable in 2005? If so where?

Thanks.

 

[ptheriault]

There is a Maintenance Cleanup Task that you have to add to your maint plan. That is where you specify how many backups to save.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[gavm99]

Your bang on the money Paul, just found it!!

Thanks!!