SQL Server Express database size limits
search cancel

SQL Server Express database size limits

book

Article ID: 161088

calendar_today

Updated On: 05-07-2025

Products

IT Management Suite

Issue/Introduction

No new information will be written to database if the database size limit is reach and your Symantec Management Platform will become very slow.

Environment

ITMS 8.x

Cause

Database file was close to 12 GB, which is over the size limit offered 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
Microsoft SQL Server 2019 Express edition has a database size limit to 10GB
Microsoft SQL Server 2022 Express edition has a database size limit to 10GB

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

Additional Information