GilaMonster (3/27/2013)
opc.three (3/27/2013)
At 50% I would rebuild. If you're having trouble with log size look into partitioning your table and indexes so you can rebuild smaller subsets of your index, ie only the partitions that need it.Or switch to bulk-logged recovery model if possible.
True. That will help keep log size down but could increase tran log backup sizes.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato