November 10, 2008 at 8:22 am
This might be a newbie question:
When you are using Studio to create a new database, during this process it prompts for some parameters - 3 types.
1st - General contains files for the data and log together with the size and other config.
Some values are prompted by default for example if there is a log file the size is 4 MB.
My question is where these default values are stored and how they can be changed?
And generally what files contain all the values to be filled when a new database is created?
I hope the question is clear.
Thank you,
November 10, 2008 at 12:30 pm
I'm not 100% sure, but I would think that the default values are read from the configuration of the SQL Server instance. Each instance has a default location for data and logfiles which is stored in the registry. You can view and change it if you open the properties for the server and go to database settings.
The filesize for the files is depending on the settings of the model database. If you change the size of the model database, the default values you get should change as well.
[font="Verdana"]Markus Bohse[/font]
November 10, 2008 at 11:02 pm
Thank you Markus,
I am not familiar with MS SQL Server so you can open the properties for the server and go to database settings from Management Studio? Please can you specify how to do it.
Thanks a lot,
November 11, 2008 at 1:51 am
Openmanagemt studio and make a object browser connection to your server.
The right-click on the server name and select properties.
Go to the page Database Settings and there you will see the default paths.
[font="Verdana"]Markus Bohse[/font]
November 11, 2008 at 8:27 am
Actually you can change the default values when you create a new database in a simple manner.
It is suffice to change them for "model System Database" and when you create a new one it will inherit the settings of the model db.
Thanks,
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply