Post reply

Maintenance plan for SQL DB maintenance order

  • December 2, 2012 at 11:16 pm

    #285760

    Hi,

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

    Thanks in advance

  • December 2, 2012 at 11:21 pm

    #1564736

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

    Jayanth Kurup[/url]

  • December 3, 2012 at 12:13 am

    #1564747

    Only Full & Trn Backup

  • December 3, 2012 at 1:20 am

    #1564755

    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

  • December 3, 2012 at 1:27 am

    #1564760

    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]

  • December 3, 2012 at 2:17 am

    #1564764

    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

  • December 3, 2012 at 4:02 am

    #1564791

    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