>Hi,
> I have run into a problem with DBCC DBReindex. I have a customer with an enormous database and we like to reindex every week, but it has been failing. After looking into it I found that the transaction log was filling up during the process so I added SHRINKFILE to the loop that reindex's each table so that it will shrink the log file after each table is reindexed. But some of my tables have millions of records and the log file grows to an enormous size. It will fail again if the log file runs out of disk space which has happened. My question is: Is there a way to run DBCC DBReindex w/o creating Transaction Log entries, or can I turn the Transaction Log off in my procedure Reindex and then turn it back on?
>
> Thanks in Advance!
> Mike

Yes, set the recovery model to BULK before reindexing and back to FULL after.