DBMaintPlan-Optimization

I have a DB Main plan for a 20GB database that does optimization weekly. The optmization task is set to Reorganize data and index pages and Change free space per page percentage to 10%.
Each week when the optimization job runs (for about 75 mins), the log backup immediately after this task is completed is approx. 20Gb. Is this normal for the log to grow to the size of the database during this optimizatoion process?
TIA.<<Is this normal for the log to grow to the size of the database during this optimizatoion
process?>>
Yes, I'm afraid so. Just think about it: the reorg process (DBCC DBREINDEX) will move all the data
except datapages which doesn't have a clustered index. This movement need to be logged.
You might want to run DBCC INDEXDEFRAG instead.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Magic" <anonymous@.discussions.microsoft.com> wrote in message
news:ECD34B62-0703-4A58-AA19-0F4E51CB5235@.microsoft.com...
> I have a DB Main plan for a 20GB database that does optimization weekly. The optmization task is
set to Reorganize data and index pages and Change free space per page percentage to 10%.
> Each week when the optimization job runs (for about 75 mins), the log backup immediately after
this task is completed is approx. 20Gb. Is this normal for the log to grow to the size of the
database during this optimizatoion process?
> TIA.