We keep the size of the log down and the recovey easy by setting up a database maintenance task to back up the transaction logs at regular intervals. Depending...

We have tried rebuilding the indexes throughout with a fill factor of 90 (disastrous) and also rebuilding the indexes only on the affected table (77m) rows. Each time we saw...