Default parameters changing when new database is created

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Default parameters changing when new database...

Default parameters changing when new database is created

Rate Topic

Display Mode

Topic Options

Author

Message

dimad72

Posted Monday, November 10, 2008 8:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 14, 2008 7:37 AM
Points: 3, Visits: 20

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,

Post #599909

MarkusB

Posted Monday, November 10, 2008 12:30 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:03 AM
Points: 4,218, Visits: 3,874

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.

Markus Bohse

Post #600123

dimad72

Posted Monday, November 10, 2008 11:02 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 14, 2008 7:37 AM
Points: 3, Visits: 20

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,

Post #600407

MarkusB

Posted Tuesday, November 11, 2008 1:51 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:03 AM
Points: 4,218, Visits: 3,874

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.

Markus Bohse

Post #600475

dimad72

Posted Tuesday, November 11, 2008 8:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 14, 2008 7:37 AM
Points: 3, Visits: 20

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,

Post #600699

« Prev Topic | Next Topic »

Permissions