Post reply

cleaning sysdbmaintplan_history system table

  • April 27, 2006 at 10:40 am

    #172301

    I set max no of rows to 1000. Database Maintanance Plan History is not showing current errors or success status as it exceeded 1000 rows. Can I clean this table? Any thing will happen if I clean this table?

    This is a production server , so can I clean this table in regular hours? Does  it take any resources?

  • April 28, 2006 at 4:50 am

    #634778

    there are a number of tables in msdb which do not clear down, most dba's write routines to delete the data from a certain date. Deleting data always has an overhead and also generates fragmentation - just like a user database. Handle it just like you would a user database.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply