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 |
|
troyster
Starting Member
2 Posts |
 Posted - 2006-08-16 : 14:09:15
|
| I am currently using sql server 2005 standard edition. I just completed a maintenance plan using the wizard to perform a full backup nightly of a user database. I noticed there was no option to delete backups greater then a number of days old like we have with plans in sql server 2000. Is there a way of doing this through the plan in sql server 2005? |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-08-16 : 16:22:16
|
| Create a new maintenance plan. Drag the "Maintenance Clean up Task" into the design space, double click the cleanup task and add the file extension that you would like to delete (bak) and the period.RegardsNThe revolution won't be televised! |
 |
|
|
|
|
|
maintenance plans & backups