All geek questions in one place

Difference between SQL Server 2008 Express R2 and SQL Server 2008 Enterprise R2

What is the difference between SQL Server 2008 Express R2 and SQL Server 2008 Enterprise R2? In fact, I want to know all the exact limitations in the Express version that are not in the Enterprise version. Like the maximum DB file size, etc.

+6
source share
2 answers

Check out SQL Server Version Comparison , which lists detailed descriptions of each edition’s limitations.

The most important limitations of SQL Server 2008 R2 Express are:

  • uses only 1 processor
  • can use a maximum of 1 GB of RAM.
  • limited to 10 GB database size
+10
source

In fact, I want to know all the exact limitations in Express

There is a way for many differences between the free version of Express and the version of Enterprise, so just go to this Microsoft SQL Server Compare Editions tool.

+1
source

Source: https://habr.com/ru/post/897621/

More articles:


All Articles