March 27, 2007 at 3:01 pm
I read in the What's News of SP2 that
"The Maintenance Plan Wizard now includes the highly sought after Maintenance Cleanup task that was in SQL Server 2000."
I do use this function, so after I installed SP2 I ran the Maintenance Plan Wizard and I still did no see the Maintenance Cleanup task as an option. Does anyone know where this is or why it doesn't appear to be included in the Wizard? Hope I'm not missing something right in front of my eyes! Thanks
March 27, 2007 at 10:31 pm
I can Maintenance cleanup task in MP wizard...
What sql build you are on?
MohammedU
Microsoft SQL Server MVP
March 27, 2007 at 10:34 pm
You'll find the Maintenance Cleanup Task is a standard task in the Business Intelligence Studio (where you write SSIS packages).
I haven't used the wizard myself, but you could manually add the task to an existing maintenance package, or create a new packages with just it.
Hope that helps.
Julian Kuiters
juliankuiters.id.au
April 3, 2007 at 1:11 pm
The version # is Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07. I didn't restart after applying it because it gave me the option to shut down all services to avoid a restart - maybe I should go ahead and restart it.
I was able to manually add the mainteance cleanup task to a maintenance plan but wish I could use the Wizard, as the documentation for SP 2 says that was added to the Wizard.
April 4, 2007 at 1:57 pm
In SP2 of SQL 2005 basically what it is is they added it as a task you can put a check in the box to execute the cleanup task as a step in the maintence plan wizard. Unlike in 2000 on the db backup screen it was there to delete old backups. In 2005 it is a seperate task that you pick to include.
April 5, 2007 at 1:21 pm
When I run the Wizard I only see checkboxes for the following:
Check DB Integrity, Shrink DB, Reorganize Index, Rebuild Index, Update Stats, Clean Up History, Execute SQL Server Agent Job, Backup DB (Full), Backup DB (Diff), Backup DB (Trans Log)
Isn't this where I should see the new task listed?
April 6, 2007 at 6:23 am
Remember, if you are using the Mgt. Studio on a PC and NOT the server you will not see the new option. The client tools on any PC will need SP2 applied to it. The only problem is that then you will not be able to Admin pre-SP2 then from that workstation.
If you log onto that SP2 server and fire up Mgt studio and the Maint. wizard you will see the option called Maint. Cleanup task. ... The Maintenance Cleanup task removes files left over from executing a maintenance plan.
That is the task to delete old backup files.
April 6, 2007 at 8:34 pm
Just a side note:
There were 2 major bugs found and fixed with SP2 & maintenance plan.
MUST for all production servers running SP2 and maint plans.
933508 - Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended
http://support.microsoft.com/kb/933508
934458 - FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply