Will DBCC checkDb command genrate a big teansaction log? I've shirked the transaction log file ( one time)and start hourly transaction log backup yeasterday.. it shriked down to 1GB. But this morning it bounced back to 10gb again.. DBCC checkDB ran yesterday night. I now DBCC reindex can generate a big transaction log file.. how about DBCC checkDB process?
The shrink of the database is what is doing it to you, then. When you move data from the end of a file (so you can shrink), the move is logged. If you are not hurting for diskspace, I would suggest not shrinking the database(s).