Database Size Limit for SQL Express Edition

Question

I am new to SQL Server, so I read that the MS SQL Server 2008 Express Edition database size limit is 10 GB. Now my question is: can I have several databases, such as database A with 8 GB and database B of 10 GB. I mean the size limit for a single database or for the entire size of a SQL Server database.

thanks in advance

Answer 1

Yes, it has been increased from 4 to 10 GB

Please refer to SQL Server Express WebLog

In theory, you can create multiple databases, each of which should be less than 10 GB

Answer 2

Check this script on your SQL server -

SELECT d.server_name , d.sversion_name , d.edition , max_db_size_in_gb = CASE WHEN engine_edition = 4 -- Express version THEN CASE WHEN d.sversion_name LIKE '%2016%' THEN 10 WHEN d.sversion_name LIKE '%2014%' THEN 10 WHEN d.sversion_name LIKE '%2012%' THEN 10 WHEN d.sversion_name LIKE '%2008 R2%' THEN 10 WHEN d.sversion_name LIKE '%2008%' THEN 4 WHEN d.sversion_name LIKE '%2005%' THEN 4 END ELSE -1 END FROM ( SELECT sversion_name = SUBSTRING(v.ver, 0, CHARINDEX('-', v.ver) - 1) , engine_edition = SERVERPROPERTY('EngineEdition') , edition = SERVERPROPERTY('Edition') , server_name = SERVERPROPERTY('ServerName') FROM (SELECT ver = @@VERSION) v ) d 

Output for SQL Server 2005 Express -

 server_name sversion_name edition max_db_size_in_gb ---------------- --------------------------- ----------------- ----------------- SERV1\SQL2005 Microsoft SQL Server 2005 Express Edition 4 

Exit for SQL Server 2012 Express -

 server_name sversion_name edition max_db_size_in_gb ---------------- --------------------------- ----------------- ----------------- SERV1\SQL2012 Microsoft SQL Server 2012 Express Edition 10 

Answer 3

It all db size can not exceed 10GB not depend on the number of db, all db size can not exceed 10GB