Index rebuilding increasing log size
Posted on 2007-04-02
Very rarely do much SQL Server 2k maintenance and am feeling rather dense about this ...
Have set up a weekly job to rebuild the indices in several databases (OK indexes if you'd rather!), but the log size grows rapidly during this rebuild. Questions are:
1. Does this matter (it's not growing to the extent that there's any concern over HDD space)?
2. If it matters can I just schedule a database shrink (or should that be a log shrink?) immediately after the rebuild?