Post reply

DBCC Shrinkfile and DBCC ShrinkDB which Creates more fragmentation?

  • May 19, 2011 at 6:30 am

    #240627

    DBCC Shrinkfile and DBCC ShrinkDB which Creates more fragmentation.

    I have one database of 350 GB I take regular backup,what should Id do to redcue the size?

    Thanks

  • May 19, 2011 at 6:33 am

    #1327000

    Delete unsused data.

    Otherwise leave it alone.

    Shrink is shrink, it's the same process.

    It makes sense to shrink after you've archived or dumped a massive % of the data in the db AND you'll never reinsert a similar amount.

  • May 19, 2011 at 6:44 am

    #1327014

    forsqlserver (5/19/2011)

    DBCC Shrinkfile and DBCC ShrinkDB which Creates more fragmentation.

    ShrinkDB just runs ShrinkFile on each and every file in the DB. Nothing fancier than that.

    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 3 posts - 1 through 2 (of 2 total)

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