Post reply

DB Maintenance Plan

  • December 8, 2003 at 12:35 am

    #160994

    Hi!

    What are the most important options I need to include in creating DB Maintenance Plan? Like how often do I need to reorganize data/index pages, remove unused space? Is it good to choose 'Attempt to repair minor problems' in Check DB integrity section or do I just leave it unchecked? Any cons on these options?

    Thanks a lot!

    Diana

  • December 8, 2003 at 3:59 pm

    #485207

    A couple of things to consider when setting up the maintenance plan,

    1) What's the uptime requirement for the database?

    2) How important is the data that is contained in the database, ie: How early do you want to trap integrity errors?

    3) How big is the database?

    4) How much activity is taking place when the maintenance will run?

    From experience, I never check "Attempt to repair..". I had a SQL 6.5 database that was trashed by DBCC running amok. That said it may be a lot better in 7.0 and 2000, but once bitten twice shy.

    Points 3 & 4 become important if your database needs to be available 24/7 and can have heavy periods of activity. A reindex can cause timeout problems in client applications, so scheduling the reindex can be tricky.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

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

  • December 8, 2003 at 6:16 pm

    #485220

    Thanks a lot Phill!

  • December 8, 2003 at 6:16 pm

    #485219

    Thanks a lot Phill!

Viewing 4 posts - 1 through 3 (of 3 total)

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