Dear Sue,
Thank you for your replied. I was looking for the Cleanup History on maintenance plans but could not be found. How can I find it on other way.
Thank you in advance.
Best Regards,
Keetawat C,
Don't know for sure as I don't use Maintenance Plans myself and I don't have a SQL 2005 server to test out what you are looking for - sorry.
Look at sysmaintplan_logdetail. I could be wrong but I think that may have the tasks and/or commands for the maintenance plans.
Sue
Dear Sue,
I did not found any of History Cleanup in any of Maintenance Plan. Do we have any of setup to prevent or expand the period of SQL Backup History.
Thank you very much.
Best & Regards
Keetawat C.