SQL CREATE DATABASE 或 ALTER DATABASE 失败，因为产生的累积数据库大小将超过每个数据库 10240 MB 的许可限制
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/29220897/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database
提问by kosnkov
I have SQL Server not Express and when db grows to 10240 I get error:
我的 SQL Server 不是 Express，当 db 增长到 10240 时，出现错误：
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.
无法为数据库中的对象分配空间，因为“PRIMARY”文件组已满。通过删除不需要的文件、删除文件组中的对象、向文件组添加其他文件或为文件组中的现有文件设置自动增长来创建磁盘空间。
I tried to change Initial size from 10240 to more but then got error:
我试图将初始大小从 10240 更改为更多，但随后出现错误：
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)
CREATE DATABASE 或 ALTER DATABASE 失败，因为产生的累积数据库大小将超过每个数据库 10240 MB 的许可限制。（Microsoft SQL Server，错误：1827）
But this is really not Express but full SQL Server, so how it is possible that it has this limitation?
但这真的不是 Express 而是完整的 SQL Server，那么它怎么可能有这个限制呢？
采纳答案by marc_s
The instance name for SQL Server Express is by default SQLEXPRESS- but it can be anything you choose during installation. If you install SQL Server Express as the default(un-named) instance, then you get MSSQLSERVERas the pseudo instance name for SQL Server Express.
默认情况下 SQL Server Express 的实例名称是SQLEXPRESS- 但它可以是您在安装过程中选择的任何名称。如果您将 SQL Server Express 安装为默认（未命名）实例，那么您将获得MSSQLSERVERSQL Server Express 的伪实例名称。
Hence, you really cannot rely on the instance nameto judge whether your SQL Server is the Express edition or not. You need to use
因此，您真的不能依靠实例名称来判断您的 SQL Server 是否为 Express 版本。你需要使用
SELECT @@Version
to get that information.
以获取该信息。
