Home Forums SQL Server 2005 SQL Server 2005 General Discussion DBCC SHRINKFILE shrinks below specified file size RE: DBCC SHRINKFILE shrinks below specified file size
Derrick Smith
SSChampion
Points: 10833
More actions
January 25, 2011 at 2:44 pm
#1278204
If you want the database to stay at exactly 4gb, then just set its initial size to that and disable autogrowth. There is no need to shrink it after that (which is also very bad for the database, as mentioned).