sql server 2005免费版可以支持4个或更大的数据库 [英] sql server 2005 free edition can support more than 4 or bigger database

问题描述

hi
我有3.9GB的数据库，它通过添加数据来增加大小，因此在功能上它变得超过4GB.
并且我使用sql server 2005 Express Edition(它的免费版本)可以支持更大的数据库.

问题是sql server 2005是否可以支持4或5GB的数据库...

hi
i have database of 3.9GB and it increase it size by adding data so in feature it becomes more than 4GB.
and i use sql server 2005 express edition (it''s free version) can support in feature bigger database..

problems is can sql server 2005 support 4 or 5GB of database...

推荐答案

SQL Server Express Edition的大小限制为4GB，无法覆盖(请参见: http://msdn.microsoft.com/en-us/library/ms345154( v = sql.90).aspx [ ^ ]).

一种可能性是，如果要使用免费版或标准版，则升级到SQL Server 2008 R2 Express.在SQL Server 2008 R2中，数据库大小的限制已增加到10GB，请参阅: http://msdn. microsoft.com/en-us/library/cc645993.aspx [ ^ ].

还请记住，您可以在向后兼容模式下运行2008 R2版本，因此即使应用程序依赖于2005年的特定行为，也不会对应用程序造成问题.

SQL Server Express Edition has a size limitation of 4GB which cannot be overridden (see: http://msdn.microsoft.com/en-us/library/ms345154(v=sql.90).aspx[^]).

One possibility is to upgrade to SQL Server 2008 R2 Express if you want to use free edition or to Standard Edition. In SQL Server 2008 R2 the limitation of the database size has grown to 10GB, see: http://msdn.microsoft.com/en-us/library/cc645993.aspx[^].

Also remember that you can run the 2008 R2 version in backward compatible mode so it shouldn''t be a problem for the application even if it relies on 2005 specific behaviour.

SQL Server Express Edition的大小限制为4GB，无法覆盖(请参阅:http://msdn.microsoft.com/zh-cn/library/ms345154(v=sql.90).aspx[^]).

一种可能性是，如果要使用免费版或标准版，则升级到SQL Server 2008 R2 Express.在SQL Server 2008 R2中，数据库大小的限制已增加到10GB，请参阅:http://msdn.microsoft.com/zh-cn/library/cc645993.aspx[^].

还请记住，您可以在向后兼容模式下运行2008 R2版本，因此，即使它依赖于2005年的特定行为，对于应用程序也不应该成为问题.

SQL Server Express Edition has a size limitation of 4GB which cannot be overridden (see: http://msdn.microsoft.com/en-us/library/ms345154(v=sql.90).aspx[^]).

One possibility is to upgrade to SQL Server 2008 R2 Express if you want to use free edition or to Standard Edition. In SQL Server 2008 R2 the limitation of the database size has grown to 10GB, see: http://msdn.microsoft.com/en-us/library/cc645993.aspx[^].

Also remember that you can run the 2008 R2 version in backward compatible mode so it shouldn''t be a problem for the application even if it relies on 2005 specific behaviour.

这篇关于sql server 2005免费版可以支持4个或更大的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！