• Once the rebuild of any index has used up space in your transaction log, that space won't be freed up again until the transaction log is backed up. You have several options:

    (1) Allow more space for your transaction log

    (2) Back up your log more frequently during index maintenance

    (3) Use an index maintenance script that only rebuilds or reorganises indexes that are fragmented.

    John