February 17, 2011 at 5:26 am
Hi All,
I also noticed one interesting thing here In the Maintenance Plan. When I specify BAK in the "File extension" box it deletes the .bak files correctly and when I specify TXT in the "File extension" (for delete backup history log) box the txt file are not deleting in specified folder. Is it a Bug for SQL 2005 SP2 ? or some issue or need some Hotfix.
I am using SQL STD SP2(9.00.3042.00)
February 17, 2011 at 5:38 am
There were problems with maintance plans and sp 2 Pre version 3159
i dont know if it covers you re problem of not cleaning up the txt files. But i do know for sure that SP 3 has not the problem because my txt files older then 4 weeks are getting deleted in the log dir
February 17, 2011 at 10:00 am
Marco is spot on with the resolution and the specifics of needing a minimum of SP2 for SQL Server 2005. The biggest bug prior to this release was the issue with maintenance plan cleanup of old backup files.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply