Post reply

sqlmaint utility vs Maintanance Plan

  • May 5, 2005 at 7:46 am

    #164198

    Hi,

    Is there any bebifit in using sqlmaint Utility in CmdExec command line rather than Maintanance Plan for rebuilding indexes and such. I see lots of times folks are using one over the other.

     

    Thanks

     

  • May 5, 2005 at 7:53 am

    #557057

    Maintenance plan runs xp_sqlmaint which actually calls sqlmaint.exe

  • May 5, 2005 at 7:57 am

    #557061

    in other words, it's exactly the same thing as creating one in GUI, just for the those of us who like typing?

  • May 5, 2005 at 8:18 am

    #557074

    I think so.

  • May 5, 2005 at 8:21 am

    #557077

    OK, thanks.

  • May 5, 2005 at 4:57 pm

    #557242

    Actually there is more benefit to not using either of them. With the appropriate DBCC commands you can rebuild indexes and run consistency checks on individual tables. With sqlmaint you either do all or none.

     

    --------------------
    Colt 45 - the original point and click interface

  • May 6, 2005 at 12:27 am

    #557274

    That is right philcart, It is better to use our own preventive and maintenance plan rather than sqlmaint. If no plan is there Sqlmaint is to be used as a better than nothing approach.

Viewing 7 posts - 1 through 6 (of 6 total)

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