locked
What does the 10G limitation mean? RRS feed

  • Question

  • Dear all,

    the SQL Server express 2008 R2 now has 10G database storge, what does it exactly mean?

    Does it mean each database file has the size limitation of 10G? so I can create n>1 databases, and each database with the limitation of 10G, however actually the data managed by SQL Express can be more than 10G, is it right?

    Thanks!

    Friday, January 14, 2011 6:34 AM

Answers

  • Yes, it's right: each database is limited to 10G but overall, you can have more than that by using multiple databases.


    Sylvain Lafontaine, ing.
    MVP - Access
    Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
    Independent consultant and remote programming for Access and SQL-Server (French)

    Friday, January 14, 2011 7:09 AM
  • Hello Penn,

    It mean's each database (not file, a database can have more then 1 data file; it's the sum of all files of a db) can have a size of max 10 GB and yes, you can create n database where each db can have a size of 10 GB.


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Friday, January 14, 2011 7:11 AM

All replies

  • Yes, it's right: each database is limited to 10G but overall, you can have more than that by using multiple databases.


    Sylvain Lafontaine, ing.
    MVP - Access
    Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
    Independent consultant and remote programming for Access and SQL-Server (French)

    Friday, January 14, 2011 7:09 AM
  • Hello Penn,

    It mean's each database (not file, a database can have more then 1 data file; it's the sum of all files of a db) can have a size of max 10 GB and yes, you can create n database where each db can have a size of 10 GB.


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Friday, January 14, 2011 7:11 AM
  • Get it!

    Thank you all!

     

    Friday, January 14, 2011 8:33 AM