Home » Categories » Setup / IT information

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

 

 

 

0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Carestream 1200 and 1500 Intraoral Camera Setup
Viewed 866 times since Nov 15, 2018
Encryption of TDO Database
Viewed 534 times since Nov 26, 2018
HIPAA Compliance Protection to TDO Users
Viewed 2462 times since Mar 18, 2015
How to disable UAC in Windows Registry
Viewed 13645 times since Jul 30, 2014
Ping server to find IP address
Viewed 2529 times since Sep 3, 2014
X-Ray Integrations, TWAIN and 3D Images setup in TDO
Viewed 6094 times since Jun 11, 2015
Adding Dental Exchange information into TDO
Viewed 2134 times since Jun 8, 2015
TDO Version 11 Installation
Viewed 6446 times since Dec 22, 2014