SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Size


Database Size

Author
Message
abmore
abmore
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2225 Visits: 931
Comments posted to this topic are about the item Database Size
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35276 Visits: 7698
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”
jshailendra
jshailendra
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1182 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 :-D
Arjun SreeVastsva
Arjun SreeVastsva
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4614 Visits: 1711
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 ?
b0b555
b0b555
SSC-Addicted
SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)SSC-Addicted (460 reputation)

Group: General Forum Members
Points: 460 Visits: 942
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.
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: General Forum Members
Points: 143721 Visits: 18651
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Learn Extended Events

SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: General Forum Members
Points: 143721 Visits: 18651
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Learn Extended Events

Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35276 Visits: 7698
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”
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: General Forum Members
Points: 143721 Visits: 18651
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Learn Extended Events

Arjun SreeVastsva
Arjun SreeVastsva
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4614 Visits: 1711
i agree with CirquedeSQLeil Spicifying Version and edition ...lot of viewers are in confusion
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search