Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Shrinking a SQL Server Database Expand / Collapse
Author
Message
Posted Thursday, May 22, 2008 7:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 05, 2013 6:33 AM
Points: 9, Visits: 34
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?
Post #505173
Posted Thursday, May 22, 2008 7:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 05, 2013 6:33 AM
Points: 9, Visits: 34
I have already tried DBCC ShrinkFile and DBCC ShrinkDatabase with no luck. It basically only shrinks to the size of the Intial Size setting.
Post #505176
Posted Thursday, May 22, 2008 8:41 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:31 PM
Points: 32,780, Visits: 14,941
Can't go below original size, AFAIK.

Build a new db, script things out, xfer data.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #505227
Posted Thursday, May 22, 2008 8:42 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:31 PM
Points: 32,780, Visits: 14,941
And if you shrank the database, you might have caused a lot of fragmentation. Be sure you reindex.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #505228
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse