Shrinking a Data file of a database

  • U J

    SSCrazy

    Points: 2420

    Dear All,

    I want to shrink my data file so which is the best method from following to gain the physical space to O.S.

    Method 1)

    1)shrink the data file then

    2)execute the index rebuild

    ---------or--------

    Method 2)

    1)execute the index rebuild then

    2)shrink the data file 

    ----or--------

    is there any good method other than thsese two ...?

  • Yelena Varshal

    SSC-Dedicated

    Points: 34215

    I would vote for Method 2 - rebuild index first and then shrink

    Regards,Yelena Varsha

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

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