<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Abhijit
»
Database Size
89 posts, Page 1 of 9
1
2
3
4
5
»
»»
Database Size
Rate Topic
Display Mode
Topic Options
Author
Message
abmore
abmore
Posted Wednesday, January 20, 2010 9:29 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:06 AM
Points: 1,134,
Visits: 818
Comments posted to this topic are about the item
Database Size
Post #850988
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Wednesday, January 20, 2010 10:05 PM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 3,129,
Visits: 4,312
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
jshailendra
jshailendra
Posted Wednesday, January 20, 2010 10:14 PM
Old Hand
Group: General Forum Members
Last Login: Friday, December 21, 2012 5:24 AM
Points: 366,
Visits: 436
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
Sree Arjun Div
Sree Arjun Div
Posted Wednesday, January 20, 2010 11:21 PM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:44 AM
Points: 2,173,
Visits: 1,350
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
b0b555
b0b555
Posted Wednesday, January 20, 2010 11:44 PM
Old Hand
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:40 PM
Points: 326,
Visits: 472
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
SQLRNNR
SQLRNNR
Posted Wednesday, January 20, 2010 11:49 PM
SSCoach
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733,
Visits: 12,332
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 2008
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
SQLRNNR
SQLRNNR
Posted Wednesday, January 20, 2010 11:53 PM
SSCoach
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733,
Visits: 12,332
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 2008
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
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Wednesday, January 20, 2010 11:57 PM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 3,129,
Visits: 4,312
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
SQLRNNR
SQLRNNR
Posted Thursday, January 21, 2010 12:02 AM
SSCoach
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733,
Visits: 12,332
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 2008
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
Sree Arjun Div
Sree Arjun Div
Posted Thursday, January 21, 2010 12:10 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:44 AM
Points: 2,173,
Visits: 1,350
i agree with CirquedeSQLeil Spicifying Version and edition ...lot of viewers are in confusion
Post #851045
« Prev Topic
|
Next Topic »
89 posts, Page 1 of 9
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
