Backup Issue

[lah3233]

Is there anyway in Enterprise Manager to remove old backup files like you see as an option in the maintenance plan?

 

[lah3233]

Here's a scenario of what our client wants:

Daily:
One full DB backup (approx 6 am)
3 Differential backups (12pm, 6pm, 9pm)
3 Transaction Log backups (9am, 3pm, 7:30pm)
3 File backups (10am, 4pm, 8pm)

Is there anyway to schedule this in enterprise manager w/o having to write out the T-SQL code??

Thanks!

 

[ecobb]

Here you go, it's an FAQ I wrote on scheduling backups: faq962-3646

Also, when scheduling your backups, you can tell SQL Server to delete bakups over "x" hours/days/weeks/months old.

Hope this helps!