June 25, 2008 at 10:58 am
Using Sql Server 2000, how does one manage the size of the model.mdf database?
The dB size has exceeded 1 Gb in size and what mechanisims are there to control it.
I am concerned that drive on which model.mdf resides will soon run out of space (dB storage is not the only cause).
Thanks
June 25, 2008 at 12:57 pm
The purpose of the model database is to be a template for any new databases you create. I'd take a close look at what's in it that's taking up so much space, and what is that being used for.
Do you really have 1 Gig of data that has to be in every new database you create? Would a "Common" or "Utility" database be a better option? (Instead of having the same 1 Gig of data in every database, have one database with all that data, and query it from there.) Those are the questions I'd ask.
I bet that someone is misusing the model database for something other than what it's meant for. Perhaps as a dev environment or something like that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply