Regarding Maintenance Plans...

• Chowdary's

  SSCrazy

  Points: 2978

  More actions

  May 8, 2014 at 7:22 am

  #293086

  Hi All,

  We are Using SQL 2008,

  Now we are Planning to Create some Maintenance Plans for PD Server.

  Can you please suggest me that what are all the Plans i can create

  My Database is a small DB(>=50) and it's Growing also minimum only.

  Note :For Backups we are having Jobs, So except that Backup Jobs what are all the best.

  Regards...

  Regards
  Chowdary...

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  May 8, 2014 at 7:36 am

  #1711852

  Don't use maintenance plans. Index maintenance and integrity checks are performed in an unreasonable way.

  Use Ola Hallengren's maintenance solution instead.

  -- Gianluca Sartori

• Summer90

  SSC-Dedicated

  Points: 32891

  More actions

  May 9, 2014 at 8:49 am

  #1712211

  On every SQL Server I create a nightly maintenance plan up do DB Intergity checks.... then another Maint. plan to update stats weekly.