Post reply

shrink files on sql 2005

  • April 16, 2009 at 6:09 am

    #130125

    Hi

    I have try to shirnk a primery file on sql 2005 with this details:

    Total Size UsedSize rezervedspace

    152007.125000 51120.937500100886.187500

    I run the command

    dbcc shrinkfile ('filename',150000)

    The command was finish with no error BUT the file did not shrink.

    I have try to run VIA GUI (MS) and use the option to shrink all unused space, again it finish with no error but the file still not shrink.

    Please if any one have any idea 🙂

    thanks

    Guy

  • April 16, 2009 at 6:19 am

    #978748

    Why do you want to shrink the file?

  • April 16, 2009 at 6:25 am

    #978751

    hi

    my DB is simple mode.

  • April 16, 2009 at 9:09 am

    #978949

    i have more then 100gb unused on this file, most of the table are old and not updatable

  • April 16, 2009 at 10:26 am

    #979021

    It looks like you're barely shrinking it. What's the file size on disk? I might try to shrink it closer to the 13 or 14GB

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

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