Proper order for Re-index and shrink jobs

• Marysa

  Ten Centuries

  Points: 1023

  More actions

  August 19, 2004 at 9:29 am

  #161988

  I have a SQL server that I want to setup jobs to re-index the tables, shrink the database and shrink the log.

  Is there a correct order to do this?

  Right now I have a DB shrink job setup to run on Sundays in the morning.  I have a Log shrink job setup to run Mon\Wed\Fri at night before the backups.  I have backups each night Mon-Fri.

  When would be the best time to fit in table re-indexing?

   

   

• Antares686

  SSC Guru

  Points: 125444

  More actions

  August 19, 2004 at 12:07 pm

  #519860

  Reindexing will cause log file and databse growth while occurring. Do it first then DB and file shirink next.