Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smog
Starting Member
6 Posts |
 Posted - 2006-09-15 : 10:27:56
|
| Hi all. I'm new to the forum as I've just moved from SQL 2000 to 2005.My question is, where can I control the automated deletes of backup files in the job control system. I used to be able to do this in SQL 2000 in the 'complete backup' tab of database maintenance plan. It let you delete files if they were older than a specified date. Where can I find this in 2005 ? Thanks. |
|
|
EugeneZ
Starting Member
26 Posts |
Posted - 2006-09-17 : 15:55:59
|
| You can delete backup files older than "x" days by adding a maintenance cleanup task to your maintenance plan, this does require that SP1 has been installed. This task needs to be added within the studio (right click your plan and select modify), it is not available in the maintenance plan wizard. You will need to create an additional task to delete your logs every 24 hours it is named Maintenance cleanup task, for example:http://img.photobucket.com/albums/v472/Schmedrick/mainttask.gif |
 |
|
|
smog
Starting Member
6 Posts |
Posted - 2006-09-19 : 10:40:09
|
| Cool. I'll try that. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Automated delete of old backups