October 2, 2007 at 4:47 am
I urgently need some help to find out where this functionality has been moved to. Once upon a time, when creating a transaction log on a schedule in Enterprise Manager, one had the option to automatically delete transaction log/back files which were over a certain date via the schedule. Does anyone know where this is now? How do I get round this so I can still do this without having to manually delete the files?
October 2, 2007 at 5:25 am
There are two types of clean up tasks. The "History Cleanup Task" removes history information from the MSDB database relating to maintenance plans. The "Maintenance Cleanup Task" removes old files.
After you go through the maintenance wizard, you will have an SSIS package for your maintenance plan. Drag a "Maintenance Cleanup Task" from the toolbox. Drag the green arrow from the last task in your package to the cleanup task. Edit that task and configure it.
Maintenance cleanup changed a bit along with scheduling in sp2 for MS SQL 2005, so make sure you are on the latest service pack.
I still don't think it is embedded in the wizard anywhere (no idea why), but it is easy to configure.
Also note that you don't have to put this in a maintenance plan package that does anything else. You can just create a single maintenance plan task on it's own schedule to do the file cleanup.
With flexibility, we got something a bit more complex. Once you get used to it, it is worth the trade.
October 2, 2007 at 6:27 am
Thank you for that insight. I would have never guessed in a million years where to find this. I am kinda stuck as I don't seem to have any tools in my toolbox despite having selected various options. I suspect I either haven't installed it or I need to upgrade the SP. How do I find out what SP I am currently running with at the moment?
October 2, 2007 at 10:21 am
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply