I've noticed a huge transaction log size after having run an
index defragmentation. Does a defrag get written to the transaction
log really? (Assuming the full recovery model.)I've noticed a huge transaction log size after having run an
index defragmentation. Does a defrag get written to the transaction
log really? (Assuming the full recovery model.)
See this ...Link (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx)
Showing posts with label written. Show all posts
Showing posts with label written. Show all posts
Sunday, March 11, 2012
Does index defrag get logged?
Subscribe to:
Posts (Atom)