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

I have SQL Server not Express and when db grows to 10240 I get error:

Could not allocate space for object in database because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

I tried to change Initial size from 10240 to more but then got error:

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database. (Microsoft SQL Server, Error: 1827)

But this is really not Express but full SQL Server, so how it is possible that it has this limitation?

sqlsql-serversql-server-2008


Solution 1:[1]

I had the same error in my Express Edition as the official documentatios says, to fix it without shrink the DB I upgraded my version, from Express to Developer edition. Go to SQL Server Installation Center->Maintenance->Edition upgrade.

Solution 2:[2]

You need to upgrade from "SQL Server Express" edition to "SQL Server Developer" Edition from "SQL Server Installation" under "Maintenance".

Solution 3:[3]

please Check This link

Change Product Key for SQL Server 2017 / 2016 / 2014 Installation

Solution 4:[4]

You need to upgrade your SQL server version.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Ros
Solution 2 Rajender Gottipamula
Solution 3 Community
Solution 4 shabab

Related Questions