Maximum Capacity Specification for SQL Server 2005 and 2008
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.