none
SQL2005维护计划 RRS feed

  • 问题

  •  

    大家好:

           请问大家SQL2005的维护计划中,History Cleanup Task和Maintenance Cleanup Task这两个工具有什么区别?

    2008年6月11日 0:51

答案

    • The History Cleanup Task deletes maintenance information generated prior to a specified date in the msdb database. It deletes historical data about Backup and Restore, SQL Server Agent and Maintenance  Plan Operations. The user interface allows you to specify the type and age of the data to be deleted. The  One new and much appreciated feature in the tasks themselves is that you can view the T-SQL statement to be issued when the task is executed.

     

    • The Maintenance Cleanup Task is a way of deleting physical backup files, although this task can be used to clean up other files as well. It removes files left over from executing a Maintenance Plan.

     

    For detailed screen shot, scripts, sample and explainations:

    http://www.mssqltips.com/tip.asp?tip=1094

     

    Hope this helps. And if you have more questions, just let us know.

     

    2008年6月11日 5:44

全部回复

    • The History Cleanup Task deletes maintenance information generated prior to a specified date in the msdb database. It deletes historical data about Backup and Restore, SQL Server Agent and Maintenance  Plan Operations. The user interface allows you to specify the type and age of the data to be deleted. The  One new and much appreciated feature in the tasks themselves is that you can view the T-SQL statement to be issued when the task is executed.

     

    • The Maintenance Cleanup Task is a way of deleting physical backup files, although this task can be used to clean up other files as well. It removes files left over from executing a Maintenance Plan.

     

    For detailed screen shot, scripts, sample and explainations:

    http://www.mssqltips.com/tip.asp?tip=1094

     

    Hope this helps. And if you have more questions, just let us know.

     

    2008年6月11日 5:44
  • Maintenance Cleanup Task doesn't clean up plan's log file, it's known issue for long time but Microsoft still didn't fix it.

    2008年6月11日 14:03
  • 大家好!

          我弄明白这两个工具的作用了History Cleanup Task这个工具是删除在MSDB数据库中的备份历史记录,这个Maintenance Cleanup Task是删除物理存在的备份。

     

        可是还有一个问题我想不明白,History Cleanup Task这个工具删除在MSDB数据库中的备份历史记录的目的是什么呢?对数据库性能有帮助吗?

    2008年6月13日 8:04
  • It'll keep msdb in reasonable size. And yes, will help to maintain performance. 

    2008年6月13日 13:52