• don't shrink it, it will just grow again on the next reindex. Either back the log up more frequently, put the database in bulk logged mode during the reindex or simply ensure you have enough disk space to handle the reindex load.

    ---------------------------------------------------------------------