Home Forums SQL Server 2005 Administering Changing the initial size of db file RE: Changing the initial size of db file
Mike John
SSCertifiable
Points: 7186
More actions
January 19, 2009 at 6:31 am
#929175
DBCC SHOINKDATABASE will not allow a shrink below the original size, but DBCC SHRINKFILE will allow you to shrink to any desired size. (provided this size is larger than the currently used space!)