Post reply

Done ShrinkDatabase ! Still no size reduction

  • July 7, 2006 at 9:53 am

    #61445

    Hello All,

    Running sp_spaceused

    I am having:

    Database size: 226622.50 MB 

    Unused space: 110851.80 MB

    I have done, dbcc shrink file using 15 % as the target percentage, with truncateonly. I am currently doing DBCC shrinkfile but thats taking ages as well

    Still no reduction in the database size. IS there anything i can do ?

     

     

    Kindest Regards,

    John Burchel (Trainee Developer)

  • July 7, 2006 at 4:18 pm

    #648094

    Since you've already done NoTruncate (which moves all the data to the left, but doesn't release any space), Try using ShrinkDatabase TruncateOnly. This will not move any data but will take as much off the end as possible.

    Kindest Regards,

    Just a bozo on this bus

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

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