May 22, 2008 at 7:33 am
I recently redid some of the schema in my database, normalizing data better. The database size was 110GB at the time that I did this. The data including indexes is now only 55 GB. I cannot get SQL Server to shrink the database back down to the 55 GB size(or even 60). Nothing I do will shrink the data files. The Initial Size of the database got set to 110 GB. Is there any way to reset the initial size of the database?
May 22, 2008 at 7:35 am
I have already tried DBCC ShrinkFile and DBCC ShrinkDatabase with no luck. It basically only shrinks to the size of the Intial Size setting.
May 22, 2008 at 8:41 am
Can't go below original size, AFAIK.
Build a new db, script things out, xfer data.
May 22, 2008 at 8:42 am
And if you shrank the database, you might have caused a lot of fragmentation. Be sure you reindex.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply