Database Size Limitation in Microsoft SQL Express

As We know that there is a limit in SQL Server Express Edition with respect to the size of the database. There have been many confusions around this area. Now we are going to mention about size of database to clear these doubts.

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

If we would cross that the limits of data sizes mentioned above so we will get below error.

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *