Post reply

shrink individual tables

  • May 8, 2008 at 1:02 pm

    #121979

    is it possible to shrink tables one at a time instead of the whole database viw DBCC shrinkdatabase? most of the tables dont have a lot of unused space so I dont want to cause the interuption of running DBCC shrinkdatabase.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • May 8, 2008 at 1:20 pm

    #812645

    Reorganizing your clustered index (and other indexes) will "shrink" the table to it's optimal size, but it will not give anything back to the operating system. It just leaves empty space in the database file.

  • May 8, 2008 at 9:35 pm

    #812788

    worked perfectly. Thanks alot Michael

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

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

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