Post reply

Alternate for Shrink Database

  • September 17, 2014 at 1:20 am

    #293321

    Hi All,

    We have a database with 40GB. In that database a table is of size almost 5GB and now that table is unused.

    We have deleted the table.

    We would like to release that 5GB space to windows.

    We dont want run DBCC Shrink file on Datafile.

    Do we have any alternate way to shrink the data file.

    Thank You,

    Regards,

    Raghavender Chavva

    Thank You.

    Regards,
    Raghavender Chavva

  • September 17, 2014 at 2:15 am

    #1745967

    Here is a an alternative solution

    •Create a new filegroup

    •Move all affected tables and indexes into the new filegroup using the CREATE INDEX … WITH (DROP_EXISTING = ON) ON syntax, to move the tables and remove fragmentation from them at the same time

    •Drop the old filegroup that you were going to shrink anyway (or shrink it way down if its the primary filegroup)

    Here's the article this suggestion comes from http://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/

  • September 17, 2014 at 3:13 am

    This was removed by the editor as SPAM

  • September 17, 2014 at 3:47 am

    #1745986

    jacksonandrew321 (9/17/2014)

    U can apply manual method to shrink database easily to utilize that 5 GB space.

    Just remember to reorganize your indexes after

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

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