Model

Question

Model

sudhakara

SSCrazy Eights

Points: 9425
More actions
May 2, 2010 at 12:54 am

#224086

Is it possible to mention the size of the new databse file & log file size in the model database ?
Thanks in Advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

easiest way is to simply right click on the model database and choose properties; the model by default is small; under 2 meg for the file, and 1 meg for the log;

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 2

Sorry.My Question is not clear.

My question is If we create new database from the server it will create the database based on the model database configuration.

In that case is there any possibilities to specify the data and log file size if i create the new database without specifying the size (Create database New) ? .

If so then what are configuration changes we can do on the model databases other than creating the objects(Table,View,SP's).

Thanks in Advance.

Jeff Moden SSC Guru Points: 1004435 More actions · Answer 3

You can simply change the size of the MODEL database and all new databases will be created according to the MODEL. That will certainly be a waste of space if you want all databases in the future to be fairly large. Personally, I don't let users or Developers create databases especially in production environments. I always take the time to create new DB's for them so that things like Growth are set correctly for the circumstances at hand for the given database. If it's a monthly database that needs to be built, I take the time to gen a script for it with the correct settings.

In other words, I pretty much leave MODEL alone except for the occasional pass-through view in 2k or the occasional synonym to a utility DB in 2k5.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)