November 29, 2014 at 5:19 am
System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database. (Microsoft.SqlServer.Express.Smo)
November 29, 2014 at 8:37 am
SQL Server Express has a limit of 10 GB per database.
Actually, in SQL Server 2005 the limit was 4 GB, so you must be using some version from 2008R2 up.
-- Gianluca Sartori
November 30, 2014 at 2:13 am
we use window 2007,
can i used window server 2008 for solve this.
November 30, 2014 at 7:15 am
No such version as Windows 2007...
The size limit in SQL Express for all versions 2008 R2 and above is 10GB. If you need a larger DB than that, you need to purchase a licence for one of the paid editions of SQL, probably Standard edition. (or developer if this is a development-only environment)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply