Francisco Tapia
fhtapia at gmail.com
Wed Oct 8 11:37:53 CDT 2008
Yes, stuff is always written to the log.. one way to avoid this is to set your database recovery model to Simple, then the changes are actually made to the tempdb, one method that I use to control log growth is to setup a job that will truncate the log when it hits 60% of it's full size... I initially start a full backup before I tackle the index defrag that way I have a recovery point if I need one. :) -Francisco http://sqlthis.blogspot.com | Tsql and More... On Fri, Oct 3, 2008 at 10:12 AM, Arthur Fuller <fuller.artful at gmail.com>wrote: > Suppose that I issue an ALTER INDEX ALL REBUILD command. Does stuff get > written to the transaction log? If so, can I turn that off, and then turn > it > back on after I have rebuilt the indexes? > > I looked in Paul Nielsen's SQL Bible and found nothing relevant. Tried BOL > as well and nothing emerged. > > Arthur > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >