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 |
|
rocksteer
Yak Posting Veteran
69 Posts |
 Posted - 2012-02-20 : 06:13:08
|
| Hi,I just upgraded from SQL Server 2000 to 2008. I have backups scheduled that have expiration periods, but the expired files are not deleted like they were with SQL Server 2000, and my backup disk is filling.My backups have date extentions.I see that there is a cleanup maintenance task and it looked like I can delete files based on creation date. Looks like I have to make it the same for all my backups, unless I give them a different extension.I am trying to create a cleanup task, but the schedule area remains disabled including the change button. DoI have to run this task manually?We have standard edition of SQL Server 2008.Also, how do I get the Maintenance Plan wizard to open against an already existing maintenance plan, like it did with SQL 2000? All I seem to get is a data flow diagram layout. How would I modify it, or do I have to delete the maintenance task and start from scratch to see the maintenance plan in wizard format? |
|
|
|
|
|
Cleanup Maintenance Schedule Disabled