Wednesday, March 21, 2012

Database max size in 2000 and 2005

Anyone knows what is the max database size in MSDE, SQL 2000 and SQL 2005 ?From BOL
Maximum Capacity Specifications
Both SQL Server 2000 and 2005
Database Size 1,048,516 Terabytes
SQL Server 2000 MSDE
Database Size 2 GB
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:

> Anyone knows what is the max database size in MSDE, SQL 2000 and SQL 2005
?
>
>|||In addition to that, SQL Server 2005 Express Edition (which is the 2005
successor to MSDE) has a maximum DB size of 4GB (from
http://www.microsoft.com/sql/prodin...e-features.mspx).
*mike hodgson*
http://sqlnerd.blogspot.com
Ben Nevarez wrote:
[vbcol=seagreen]
>From BOL
>Maximum Capacity Specifications
>Both SQL Server 2000 and 2005
>Database Size 1,048,516 Terabytes
>SQL Server 2000 MSDE
>Database Size 2 GB
>Ben Nevarez, MCDBA, OCP
>Database Administrator
>
>"Alan" wrote:
>
>|||Using SQL 2000 MSDE, I was able to restore a 30GB DB.
"Alan" wrote:

> Anyone knows what is the max database size in MSDE, SQL 2000 and SQL 2005
?
>
>|||See the below URLS:
SQL 2005
http://www.yukonxml.com/Reference/d...aspx?t=Capacity
For SQL 2000 and older version see:-
http://msdn.microsoft.com/library/d...br />
8dbn.asp
Thanks
Hari
SQL Server MVP
"SQL ADMIRER" <SQL ADMIRER@.discussions.microsoft.com> wrote in message
news:92DE7187-E52A-4DD2-BEC0-E1CA39F4EF05@.microsoft.com...[vbcol=seagreen]
> Using SQL 2000 MSDE, I was able to restore a 30GB DB.
> "Alan" wrote:
>

No comments:

Post a Comment