IndexDefrag - best practice

• jblovesthegym

  Ten Centuries

  Points: 1048

  More actions

  June 28, 2012 at 7:12 am

  #262908

  Hi all,

  Got a few Db's to defragment and wanted to check my plan with you all....

  1) Take full backups;

  2) Switch recovery model from Bulk to Simple, OR increase log shipping frequency from 15 to 2 mins;

  3) Run Defrag script (for all indices on all db's);

  4) Switch back to bulk-logged or 15 mins shipping;

  5) Run ShowContig (for all indices on all db's).

  How's this look??

  Cheers,

  JB

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  June 28, 2012 at 8:06 am

  #1506636

  I posted an answer to this on SQLTeam

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176259