Microsoft SQL Size Limitations by Version

SQL Server 2008 R2 Standard

This SQL is used mostly for offices with multiple locations, and want to replicate their data between them. This version will be installed on the main office server. The satellite office, SQL Server 2008 R2 Express will be used.

Database Size Limit: 524,272 Terabytes

Link: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms143432(v=sql.105)

SQL Server 2008 R2 Express

This SQL is used for single location offices. This is also used on the satellite location of a replicated office.

Database Size Limit: 10 GB

Link: https://blogs.msdn.microsoft.com/sqlexpress/2010/04/21/sql-server-2008-r2-express-database-size-limit-increased-to-10gb/

SQL Server 2005 Standard - Outdated for TDO

This SQL is outdated for TDO. We use version 2008.

This SQL is used mostly for offices with multiple locations, and want to replicate their data between them.  

Database Size Limit: 524,258 Terabytes

Link: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms143432(v=sql.90)

SQL Server 2005 Express - Outdated for TDO

 This SQL is outdated for TDO. We use version 2008.

This SQL is used for single location offices. This is also used on the satellite location of a replicated office

 Database Size Limit: 4 GB