Post reply

Getting error during DBCC SHRINKDATABASE

  • October 25, 2010 at 12:02 am

    #99425

    Hi everyone,

    MY Database is tempdb, which i want to shrink

    Suppose database size is 32.50 MB

    Unallocated Space is 17.84 MB

    reserved is 1184 KB

    data 504 kb

    index_size is 592 kb

    unused 88 kb

    ---------------------------------------------------------------------------------------------------------

    I am running below like command

    DBCC SHRINKDATABASE (tempdb, 15)

    GO

    --------------------------------------------------------------------------------------------------------------

    Error comming like

    DBCC SHRINKDATABASE: File ID 1 of database ID 2 was skipped because the file does not have enough free space to reclaim.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  • October 25, 2010 at 2:50 am

    #1241451

    It's a total waste to try and shrink to reclaim around 10MB of space. The DB is tiny already. Leave it alone.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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