August 3, 2007 at 4:16 am
As a throwaway line...I hate the way SSIS has been used for maintenance plans in 2005. Why? wheres the integration and transformation in setting up a backup? Its messy and the presentation is nowhere near as good as good old simple 2000. Maintenance plans should be simple and intuitive, they no longer are.
Anyways I have a 2005 SP2 GDR2 server (9.00.3054) and the maintenance plan clean up tasks are not working (ie delete old backups) but my understanding is on this version maintenance plans should (finally) work. I get no errors but old backups are not deleted. Anyone else finding this?
Output from the job: (names changed to protect the innocent)
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3054
Report was generated on "xxxxxxxxxxx".
Maintenance Plan: xxxxxxxx MaintenancePlan
Duration: 00:00:02
Status: Succeeded.
Details:
Maintenance Cleanup Task (xxxxxxxxxxx)
Maintenance Cleanup on Local server connection
Cleanup Database Backup files
Age: Older than 2 Days
Task start: 2007-08-03T01:30:04.
Task end: 2007-08-03T01:30:04.
Success
Back Up Database (Full) (xxxxxxxxxxx)
Backup Database on Target server connection
Databases: xxxxxxxx
Type: Full
Append existing
Task start: 2007-08-03T01:30:01.
Task end: 2007-08-03T01:30:04.
Success
---------------------------------------------------------------------
August 3, 2007 at 6:19 am
are you able to delete using xp_delete_file procedure manually running it, coz thats the procedure they are calling in the cleanup task.......
[font="Verdana"]- Deepak[/font]
August 3, 2007 at 8:38 am
thanks for the reply.
yes, xp_delete_file works.
I have found the solution. In the clean up task I specified the file extension as .bak, should have been just bak without the leading dot!
Proves my point, would never had made that errror in a sql 2000 maintenance plan, and why did i not get an error saying 'file xxxx..bak does not exist'?
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply