Post reply

re sql server express 1gb limit

  • July 31, 2008 at 5:39 am

    #123646

    Hi,

    i am using sql server express 2005, i am using multiple databases on it, i checked microsoft website and found that it has maximum database limit fo 1gb now what i am confused about is. does that mean

    db1+db2+db3+ db4..=1GB

    or each database can be of maximum 1gb size

    please recommend

    Thanx

    ltoso

  • July 31, 2008 at 6:00 am

    #851186

    no SQL Express support till 4 GB for database size!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • July 31, 2008 at 7:54 am

    #851262

    SQL Server Express can handle multiple databases each up to 4Gb in size (this excludes logfiles).

    I think the 1Gb limit that you mentioned refers to the fact that SQL Server Express can only access 1Gb of server RAM.

  • July 31, 2008 at 8:32 pm

    #851629

    Hi,

    yes i checked the database limit it is 4GB now what i am confused about is can i have multiple database in which each can expand to 4gb or all the database sizes added together shouldn't increase 4GB.

    PLease recommend

    Thanx ltoso

  • August 1, 2008 at 1:29 am

    #851677

    No one database in Express can be larger than 4 GB, but there is no limit on the number of databases you can use in Express.

    From: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1082707,00.html

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

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