Maintenance plan for SQL DB maintenance order

  • Hi,

    Best maintenance plan order for Production Database(>100GB) sqlserver 2005.

    Thanks in advance

  • Could you please list the tasks that you perform as part of the maintainence plan

    Jayanth Kurup[/url]

  • Only Full & Trn Backup

  • Those two should be scheduled based on your backup strategy and your SLAs.

    You also need integrity checks and index maintenance at a minimum.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I usually prefer not to use a maintainence plan to perform backups. Try using a script instead. Also if you have the option use a third party tool for more reliable and faster backups.

    Jayanth Kurup[/url]

  • Hi Thanks for updates

    Gail please let me know these (integrity checks and index maintenance)tasks before or after Backups.?

    And for DB maintenance what else can be done for Production

  • Index maintenance whenever you have time. Integrity checks probably before the backup. It's nice to know whether the DB is corrupt or not before backing it up.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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