Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth RE: Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth

  • November 28, 2012 at 1:49 am

    #1562976

    Index rebuilds

    Rebuilding an index offline, using ALTER INDEX REBUILD (or the deprecated DBCC DBREINDEX in SQL Server 2000) drops the target index and rebuilds it from scratch (online index rebuilds do not drop the existing index until the end of the rebuild operation).

    Hi Gail,

    I copied and paste above paragraph from this article. From reading it, i got the wrong impression that offline reindex rebuild drops target index and then rebuild, whilst online index does not drop existing index until the of index rebuild.

    You're right,alter index rebuild reads from existing index pages even if they're corrupted pages.

    Thanks for clarification.

    Simon

    Simon Liew
    Microsoft Certified Master: SQL Server 2008