Post reply

Partitioned Tables and file sizes

  • October 25, 2007 at 2:12 pm

    #153920

    Hello all-

    We were experiencing some very long load times for a fairly large table (21 million records), so we partitioned the table into four file-groups. After we trunc'ed and re-loaded, we added about 80 GB of data to the new files. After we shrunk the database, however, the .mdf file stayed close to the same size as before we partitioned the table. We're running into space issues now; any suggestions? Why didn't we reclaim more space after shrinking the database?

    Thanks much,

    Jason

  • October 25, 2007 at 3:09 pm

    #745501

    dbcc shrinkdb will not shrink a data file to a size smaller than the amount of space needed for the data it contains or smaller than it's size when it was created or smaller than the size set with a dbcc shrinkfile command or through SSMS. maybe one of hese is the cause. If you need to shrink just the mdf to smaller than one of these values you can try dbcc shrinkfile.

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

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