CODEWITHSUNDEEP
sql-serversql-server-2014-express
osiris_v6
osiris_v6

Reputation: 462

SQL Server 2014 Express edition database growing beyond 10 GB limit

I have a strange situation on a SQL Server 2014 Express edition server. The database reached 10 GB limit, but it continued to auto-grow the data file to a current size of 80 GB. There are a lot of auto-growing events.

I checked sp_spaceused and I have a few unallocated MB, also checked sys.master_files. In logs, I get the error:

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

enter image description here

enter image description here

enter image description here

How can the data file grow beyond 10 GB? What am I missing?

Upvotes: 0

Views: 210

Answers (0)

Related Questions