Post reply

DBCCSHRINKFILE returning transport level error when shrinking data file

  • November 30, 2007 at 3:02 pm

    #181832

    Greetings:

    I have a database that is 1.7terabyte in size with 136gb free and throws a "transport level error" telling me to discard the results when I run dbccshrinkfile ('DBNAME', size). I have tried various increments of size, from truncateonly to 1MB below its current value, and nothing works. I have tried to detach and reattach the db, restart the service, restart the server, and none have provided a solution. Any ideas?

    Regards,

    Derek

  • December 3, 2007 at 9:48 am

    #756551

    I have a GREAT idea - don't shrink the file!! There are lots of bad things that come from this, and in this case nothing good that I can see. You have < 10% free space in the database, which isn't enough to begin with. You need free space so that index defrags and data growth have contiguous space to lay down their data pages. See here: http://www.karaszi.com/SQLServer/info_dont_shrink.asp among other places.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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