Shrinking a Data file of a database

  • 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 ...?

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

    Regards,Yelena Varsha

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

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