Maximum Capacity Specification for SQL Server 2005 and 2008

  • Article

I came across this link - https://technet.microsoft.com/en-us/library/ms143432(SQL.100).aspx.  Its amazing to see the max capacity specification for SQL Server.    These are for SQL Server 2008, but they haven't changed from SQL Server 2005's limit.      I would love to see systems with near capacity in below specifications:

SQL Server Database Engine object Maximum sizes/numbers SQL Server (32-bit) Maximum sizes/numbers SQL Server (64-bit)
Database size 1,048,516 terabytes 1,048,516 terabytes
Databases per instance of SQL Server 32,767 32,767
Filegroups per database 32,767 32,767
Files per database 32,767 32,767
File size (data) 16 terabytes 16 terabytes
File size (log) 2 terabytes 2 terabytes

This is for SQL Server 2005 - https://technet.microsoft.com/en-us/library/ms143432.aspx  which is similar to SQL Server 2008.