February 10, 2009 at 2:21 pm
Hi,
Even though I can change the size to 2MB but it does not take any effect, once i reopen the model DB properties its still showing the DB size as 3 MB.
Requirement
I need to create a user DB of initial size 2MB
I restarted the SQL server to see if it takes any effect still the same. Googled a bit but did not see anywhere mentioned about this.
Detials
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
Or is it that size of model in SP3 is 3MB by default?
Thanks in advance!!!
February 10, 2009 at 2:28 pm
You can specify the SIZE at creation time.
If you need to get that size automatically every time you create a new DB and your model is 3MB you will have to shrink it (with TSQL the UI does not supports shrinking)
* Noel
February 10, 2009 at 3:54 pm
If you need to get that size automatically every time you create a new DB and your model is 3MB you will have to shrink it
Yes, thats true! But I was unable to change the initial size for model DB to 2 MB unless I shrunk it.
What could be the reason?
So, If I want to change the initial size for model DB then I would have to shrink it ?
Why is the initial size for model DB is 3 MB by default?
Are there any performance implications if we shrink the model DB data file?
(with TSQL the UI does not supports shrinking)
it does support through UI
February 10, 2009 at 4:34 pm
Why is the initial size for model DB is 3 MB by default?
The sizes of these files can vary slightly for different editions of SQL Server 2005
Are there any performance implications if we shrink the model DB data file?
No but why would you shrink it?
Is it a big difference that the new DBs by default are 3MB instead of 2MB?
it does support through UI
You can use Right-click->Tasks->Shrink... BUT you cannot use the Dialog where you set the initial size to "reduce" the value you are seeing.
* Noel
February 10, 2009 at 4:40 pm
Alright that's cool.
No it really does not matter but I was doing a test on what is the impact on the system if autogrowth is enabled. But then I was stuck with this problem cos in theory i wanted it as 2MB.
Now resolved. Million Thanks !!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply