Good day experts,
I have a SQL Server 2008 R2 Express installation. According to Microsoft's website, this edition has a database size limit of 10GB.
My applications and the SQL Server machine's windows event log are reporting errors related to exceeding licensed database size limit of only 4096MB.
The exact error in the eventlog recorded against my SQL Server instance name is: "CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database."
When I run SELECT @@VERSION, the following is returned:
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
I'm assuming this is a common problem. How do I rectify this?