Home Forums Article Discussions Article Discussions by Author Discuss content posted by Abhijit Database Size RE: Database Size

  • January 21, 2010 at 5:33 am

    #1106615

    stewartc-708166 (1/20/2010)

    Beg to differ

    when creating a new SQL2008 db, the mdf defaults to 3MB and the ldf to 1MB.

    On my SQL2008 (Developer Edition, x64), the modeldev.mdf is 2MB and the modellog.ldf is 1MB.

    I wonder if there are differences between editions and platforms?

    What about if it is a named instance?

    My SQL2008 install was to a named instance, with SQL2005 (Developer, x64) running on a different named instance (not a 2005 upgrade to 2008).

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2