March 30, 2006 at 5:31 am
March 30, 2006 at 5:59 am
How many transactions are you expecting?
March 30, 2006 at 8:15 am
March 31, 2006 at 9:16 am
It will depend on what sort of data is being modified, I would imagine-- lots of text or a few tinyints.
It will also depend on how often you run transaction log backups.
Note that rebuilding or reorganizing indexes in FULL recovery mode will cause the transaction log to balloon to the size of your database or larger.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply