Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-03-13 : 11:03:27
|
| Hi,Is there a way to find out the original sizes (during first time implementation) of system tables and dbs like master, Model, MSDB etc. Since these sizes have changed, I need to know the minimum size.Thanks,Sarat. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-13 : 12:14:19
|
| I don't know how you are going to find the minimum sizes of these unless you do a fresh install. The minimum value for size is 512 KB, but I doubt that's what is used for the system databases, except model which is probably created very, very small.Tara |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-03-19 : 12:13:24
|
| Hey,I found this on BOL looking for something else: Default size, typical setupmaster primary data Master.mdf 11.0 MB master log Mastlog.ldf 1.25 MB tempdb primary data Tempdb.mdf 8.0 MB tempdb log Templog.ldf 0.5 MB model primary data Model.mdf 0.75 MB model log Modellog.ldf 0.75 MB msdb primary data Msdbdata.mdf 12.0 MB msdb log Msdblog.ldf 2.25 MB I think I will use this as a baseline.Thanks,Sarat |
|
|
|
|
|
|
Sizes of model db & system tables