Rebuild Index effect Transaction Logs 1

[ousoonerjoe]

Using SQL 2008 R2.

Does rebuilding the indexes while On Line create transaction entries?

--------------------------------------------------
Stubbornness is a virtue -- if you are right. --Chuck Noll
--------------------------------------------------

 

[MartinCroft]

Yes both offline and online activity cause transaction log activity

http://msdn.microsoft.com/en-us/library/ms190981(v=SQL.100).aspx