Post reply

Help! DB running out of space

  • November 3, 2011 at 11:16 am

    #251066

    I kicked off a copy of tables from one database to another database on the same server. I didnt realize those 4 tables = 40GB. Well sadly I did not have 40GB of free space. I was able to stop the xfer mid way but now my drive is down to 2GB. So I decided to drop the newly copied tables from the database until i get more space however dropping the tables did not free up any space.

    Do I need to run a DBshrink?

  • November 3, 2011 at 11:31 am

    #1402817

    Yes. Run a once-off shrink of just the file that now has the free space, preferably run it with TRUNCATEONLY.

    If you only run the shrink with TRUNCATEONLY, you won't need to rebuild your indexes afterwards.

    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

  • November 3, 2011 at 12:34 pm

    #1402868

    Thanks Gail! This makes perfect sense. I do appreciate it!

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

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