Post reply

What is wrong with shirnk then rebuild index?

  • April 2, 2012 at 3:00 am

    #258437

    Hi,

    I've read many articles about why shrinking database files is a bad idea and the overiding reason that i have found is that it causes index fragmentation.

    My question is this: Is there any associated problems with setting up a a maintenance plan to perform a shrink database task and then a subsequent rebuild indexes task?

    Thanks.

  • April 2, 2012 at 3:15 am

    #1467524

    Think the index rebuild will cause your DB files to grow again

  • April 2, 2012 at 3:18 am

    #1467526

    Waste of time and resources. Shrink fragments indexes and reduce the file size. Rebuild removes the fragmentation, growing the data file again.

    See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

    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

  • April 2, 2012 at 3:41 am

    #1467534

    Thanks very much for the prompt replies.

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

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