SQL Server 2000 Max database size?

[Smeglor]

The max database size listed on microsofts website says that SQL Server 2000 is 1,048,516 terabytes. Thats over a million terabytes.

http://www.microsoft.com/sql/evaluation/overview/default.asp

But I often see info, including from Microsoft, that the max database size is 1 terabyte on SQL Server 2000 Standard and 2 terabytes on SQL Server Enterprise. Thats a sheer drop from the info page stating that the max database size is over a million terabytes. Whats the real answer?


I don't know sir...I guess its broke.

 

[Joeybear23]

We have Standard and are running a larger than 1TB database.

The only difference between Stabndard and Enterprise is how users connect to the database.

SQL/SAP DBA

 

[SQLBill]

Where do you see this:

But I often see info, including from Microsoft, that the max database size is 1 terabyte on SQL Server 2000 Standard and 2 terabytes on SQL Server Enterprise. Thats a sheer drop from the info page stating that the max database size is over a million terabytes.

-SQLBill

Posting advice: FAQ481-4875

 

[Smeglor]

Thanks fellas

I don't know sir...I guess its broke.

 

[mrdenny]

There are some other differences between standand and Enterprise.
For Example:
Enterprise support clustering.
Enterprise supports more CPUs than standard.
Enterprise supports more RAM than standard.
Enterprise supports federated databases.


Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)