Maximum Capacity Specifications for SQL Server 2008 R2

These are some of the 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


Rows per table Limited by available storage



Tables per database Limited by number of objects in a database