September 12, 2002 at 2:52 pm
Is there a maxium database size in SQL Server 2000 Enterprise Edition? I have a database that has grown to 4 gig and I am being told by people that it has reached its max for Sql Server. Is this true? If so, what is the appropriate action.
Thanks
September 12, 2002 at 2:59 pm
The max database size is 1,048,516 TB Cubed
This information can be found in BOL under "Maximum Capacity Specifications"
-------------------------
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 12, 2002 at 6:08 pm
No maximum for any version. The limit is the Hard disk size. (OLTP)
September 12, 2002 at 7:14 pm
The only version of the SQL Server engine with a reachable limit is MSDE. It is limited to 2GB. MSDE is a stripped down version with self-imposed restrictions, and that's the reason for the limit. As indicated by others, the limit is pretty much the sky.
We currently have a DB here that's > 20 GB and growing by about a GB a month. I know some have databases in the TB range.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
September 13, 2002 at 6:04 am
My SQL Advanced Server 2000 database is currently 161 GB and growing daily. I have 1100 GB of space and expect to use most of it for my database.
-SQLBill
September 16, 2002 at 5:51 pm
You have a long way to go. We currently have a 3.8 TB database and while there are some issues with having enough time to rebuild indexes after large 40GB+ data loads there does not seem to be performance issues at all.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply