Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Database Size Expand / Collapse
Author
Message
Posted Wednesday, January 20, 2010 9:29 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:03 AM
Points: 1,154, Visits: 866
Comments posted to this topic are about the item Database Size
Post #850988
Posted Wednesday, January 20, 2010 10:05 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:19 AM
Points: 3,985, Visits: 5,239
Beg to differ
when creating a new SQL2008 db, the mdf defaults to 3MB and the ldf to 1MB.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #850996
Posted Wednesday, January 20, 2010 10:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 7:12 AM
Points: 366, Visits: 455
I agree with Stewartc, In 2008 intial size for mdf is 3 MB and for ldf its 1 MB, so initial size of DB would be 4 MB and not 3 MB.....We want our points back
Post #851001
Posted Wednesday, January 20, 2010 11:21 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:47 AM
Points: 2,296, Visits: 1,427
In Sql Server 2000 New Database Size is 2.00 MB
and unallocated spcae is o.43 mb...so the in the question you specify the versions 2000,2005,2008 Can u give right marks to 2 MB ALSO....

In 2008 intial starting size for mdf is 3 MB and for ldf its 1 MB, so initial size of DB would be 4 MB so it is..?


FOR PAST 2 DAYS QUESTIONS WERE DOEN'T UNDERSTANDING ?

WHAT HAPPEND TO SQL CENTRAL SERVER ?
Post #851028
Posted Wednesday, January 20, 2010 11:44 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:58 PM
Points: 330, Visits: 623
This statement doesn't make sense to me:

"The default size for an mdf is 2MB and 1MB for an ldf, based on the model database".

It can't default to 2mb/1mb AND default to the values in the model db. How can it default to 2 different things?? It has to be one or the other, surely...

If it is based on the model database, then the default size is whatever is specified in the model db, in my case 100mb/10mb.
Post #851034
Posted Wednesday, January 20, 2010 11:49 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
b0b555 (1/20/2010)
This statement doesn't make sense to me:

"The default size for an mdf is 2MB and 1MB for an ldf, based on the model database".

It can't default to 2mb/1mb AND default to the values in the model db. How can it default to 2 different things?? It has to be one or the other, surely...

If it is based on the model database, then the default size is whatever is specified in the model db, in my case 100mb/10mb.


If unaltered, then the default settings would be the 2 and 1 in the model database. But this doesn't apply to SQL 2008 as it has been pointed out (and I have not tested in 2008). However, my SQL 2005 instance conformed to those settings.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #851035
Posted Wednesday, January 20, 2010 11:53 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
I decided to go back and test this on SQL 2008 after my last post.

I verified both Model database settings, and created a new database. I have not altered any Model database settings and for me, the sizes I see in both model and the new database correlate to the correct answer displayed in the QOD.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #851039
Posted Wednesday, January 20, 2010 11:57 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:19 AM
Points: 3,985, Visits: 5,239
each version and edition is different

the question should have been a bit more precise, i.e. specifying for which version / edition it was being asked


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #851041
Posted Thursday, January 21, 2010 12:02 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
stewartc-708166 (1/20/2010)
each version and edition is different

the question should have been a bit more precise, i.e. specifying for which version / edition it was being asked


That is true. Specifying version and edition would have been very helpful in this question.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #851042
Posted Thursday, January 21, 2010 12:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 8:47 AM
Points: 2,296, Visits: 1,427
i agree with CirquedeSQLeil Spicifying Version and edition ...lot of viewers are in confusion
Post #851045
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse