Maximum Capacity Specifications for SQL Server 2008 R2
- Database size: 524,272 terabytes
- Databases per instance of SQL Server: 32,767
- Filegroups per database: 32,767
- Files per database: 32,767
- File size (data): 16 terabytes
- File size (log): 2 terabytes
- Rows per table: Limited by available storage
- Tables per database: Limited by number of objects in a database