Reducing the initial size of the model database in SQL Sever 2005

#1

I've noticed that after increasing the initial size of the model database it
cannot be reduced. I increased it from 3MB to 5MB and although I can later
specify a lower value, say back to 3MB, the change dosen't stick. I'm using
Management Studio on a 2005 default instance. Is this behavior by design?

#2

stuppi (stuppi (AT) discussions (DOT) microsoft.com) writes:

Quote:

I've noticed that after increasing the initial size of the model
database it cannot be reduced. I increased it from 3MB to 5MB and
although I can later specify a lower value, say back to 3MB, the change
dosen't stick. I'm using Management Studio on a 2005 default instance.
Is this behavior by design?

To increase the size of a database you use ALTER DATABASE. But to shrink
a database, you use DBCC SHRINKFILE. (Or SHRINKFILE). Shrinking a database
is (or should be) a much less common operation.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Reducing the initial size of the model database in SQL Sever 2005

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Reducing the initial size of the model database in SQL Sever 2005 - 02-19-2010 , 03:00 PM

Re: Reducing the initial size of the model database in SQL Sever 2005 - 02-19-2010 , 08:52 PM