Post reply

DB size in SQL Express.

  • February 19, 2009 at 2:37 am

    #205760

    Dear All,

    I am told that database can be maximum size of 4GB.

    Suppose I have 5 databases. so each database can be of 4GBs..? also Is LDF file included in that ..?

    Regards,

    swmsan

  • February 19, 2009 at 8:41 am

    #946787

    swmsan (2/19/2009)

    Dear All,

    I am told that database can be maximum size of 4GB.

    Suppose I have 5 databases. so each database can be of 4GBs..? also Is LDF file included in that ..?

    Regards,

    swmsan

    1. Yes each can have 4GB mdf file. ldf file size is not counted on that number.

    2. You can have multiple databases each of 4GB.

    Now be careful to run and use it for big things because you will be unpleasantly surprised:

    - It is only available on 32Bit

    - It can only use 1GB of BufferPool memory

    - It will only use 1 CPU

    I know you can try to overcome some of these by adding instances (up to 16 ) but you should make sure that your app is ready for the limitations.


    * Noel

  • February 20, 2009 at 3:20 am

    #947389

    Thank You.

  • February 20, 2009 at 6:58 am

    #947463

    It is only available on 32Bit

    I should add the SQL Server 2008 Express comes in x64 but not itanium and the SQL Server Express 2005 is only x86 that is 32bits but comes in a binary that can be installed in WOW64 of a 64bits box.

    http://www.microsoft.com/express/sql/download/

    http://blogs.msdn.com/sqlexpress/archive/2008/08/07/what-s-up-with-sql-server-2008-express-editions.aspx

    Kind regards,
    Gift Peddie

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply