Managing SQL Backups in SQL 2008 R2

[hoppyintheuk]

I wonder if anyone could give me some advice regarding sql backups on sql 2008 r2.

I am currently backing up 4 databases on a subplan, but, cant get the server to delete/truncate sql backups after 60 days has passed.

Does anyone know what I have to adjust in the Server Management Studio, in order to achieve this?

 

[Little_Crow]

That seems an awfully long time to keep backups on disk....

You just need to add a 'maintenance cleanup task' to your maintenance plan.
Just paste in the folder your backups go to, set it to delete bak files older than 60 days, and you're done.

You'll need an additional task to also delete trn backups if you use them.

 

[Madmrcopper]

Ive also had similar issues in the past.

Usually find the plan stops working after a large system change and no tweaking or changes to the the plan will start to backup again. Only way I've found to fix it is to backup the old contents of the file dump to a new location and then delete the old plan and create from scratch.