SQL Server Express database size limits
search cancel

SQL Server Express database size limits

book

Article ID: 161088

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

No new information will be written to database, Symantec Management Platform becomes very slow.

Cause

Database file was close to 12 GB, which is over the size limit by Microsoft

Resolution

SQL Express databases have strict size limits which can cause problems when CMDB grows. 

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

It is recommended to change to Full version of SQL Server without such limitations.

https://docs.microsoft.com/en-us/answers/questions/315117/sql-server-express-database-size-limit-total-or-us.html