SQL Server Express File Size Limitation

Recently while working on a project I ran into the SQL Server Express File Size Limitation. After tracking it down I thought it would be worth documenting here for the next time someone needs this.

• Microsoft SQL Server 2005 Express edition has a database size limit to 4GB
• Microsoft SQL Server 2008 Express edition has a database size limit to 4GB
• Microsoft SQL Server 2008 R2 Express edition has a database size limit to 10GB
• Microsoft SQL Server 2012 Express edition has a database size limit to 10GB
• Microsoft SQL Server 2014 Express edition has a database size limit to 10GB
• Microsoft SQL Server 2016 Express edition has a database size limit to 10GB
• Microsoft SQL Server 2017 Express edition has a database size limit to 10GB
• Microsoft SQL Server 2019 Express edition has a database size limit to 10GB

Are you running into the 10GB limit on SQL Server Express?

Related Links:

• Database Health check for SQL Express limit.

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!