Post reply

Shrinking a file doesn't releases space

  • June 1, 2010 at 6:08 am

    #147247

    i shrink a datafile using DBCC command ( That also had TruncateONLY Option) and I also Reorganize all the indexes then after.

    But still i t doesn't releases unused space.

    Can anyone tell me why it happens so????

  • June 1, 2010 at 6:30 am

    #1174733

    Check the Utilization% of the file.

    And in-case if there is some space you can check if there is any active or sleeping SPID on the db if yes then either wait for it to get resolved or kill it....

    ~RD

  • June 1, 2010 at 2:10 pm

    #1175000

    janki_2886 (6/1/2010)

    i shrink a datafile using DBCC command ( That also had TruncateONLY Option) and I also Reorganize all the indexes then after.

    But still i t doesn't releases unused space.

    Can anyone tell me why it happens so????

    This was more of a problem in older versions of SQL Server, but I ran across it in SQL Server 2005 a time or two as well. Check out this link. Maybe it will help.

    http://johnnynine.com/blog/HowToImmediatelyShrinkSqlServerLogFilesLDFFiles.aspx

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

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