Post reply

Index DeFragging

  • December 18, 2008 at 10:48 am

    #216725

    Hi All

    When I do "Index REBUILDs", my database files GROW. Alot! And the database is in "SIMPLE" recovery mode.

    Is this just the nature of the beast and I just have to have a lot of additional disk space available?

    Plus, after I do the "REBUILD", should I do FULL Database/TransactionLog Backups?

    thanks in advance

  • December 18, 2008 at 11:04 am

    #914772

    rew (12/18/2008)

    Hi All

    When I do "Index REBUILDs", my database files GROW. Alot! And the database is in "SIMPLE" recovery mode.

    Yup. They will. Rebuilds are logged operations (though bulk logged in Simple) and the rebuild needs space to put the new index

    Plus, after I do the "REBUILD", should I do FULL Database/TransactionLog Backups?

    No more than you'd normally do a full backup. You can't back up the tran log in Simple.

    Also, just in case, don't shrink the files afterwards. A shrink will result in worse fragmentation than before the rebuild.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 18, 2008 at 11:07 am

    #914775

    Thanks for your quick response Gail !

    Thats what I needed to know.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply