SQL Server 2008 R2 Enterprise database has unexpected 4GB database size limit
- by Jesse
I have SQL Server 2008 R2 Enterprise installed on a local Windows 7 x64 workstation. When I create a database on the server, it unexpectedly has a 4GB size limit (Database properties in SQL Server Management Studio say size = 3934.38 MB, space available = 47.13 MB).
Unfortunately the database needs more than 4GB, and Enterprise is not supposed to…