2008 R2 Express 10G size limit

  • Greetings. I have an instance of 2008 R2 Express on my laptop, and am wondering if the 10G limit is for all the files that make up the instance, or for each database I have in the instance. Could I feasibly have multiple 10G databases on the same instance? Also, does the 10G limit include all the files, logs, backups, data, etc, or is it only for the data files. Thanks.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

  • The maximum size for SQL express 2008 R2 is 10240 MB for each DB.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 2 posts - 1 through 1 (of 1 total)

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