You would like to know what versions of SQL is supported by Vault and the differences between the versions.
How To
The following versions of SQL are supported:
Microsoft® SQL Server™ 2005 Express (SP2) 32-bit or 64-bit Microsoft SQL Server 2005 Standard (SP2) 32-bit or 64-bit Microsoft SQL Server 2005 Enterprise (SP2) 32-bit or 64-bit Microsoft SQL Server 2005 Workgroup (SP2) 32-bit or 64-bit SQL Server 2008 Standard Edition x86 on Windows Server 2008 Standard x86 32-bit or 64-bit SQL Server 2008 Standard Edition x64 on Windows Server 2008 Standard x64 32-bit or 64-bit
Note: Express and Workgroup versions are not supported in a Multi-Site environment.
SQL 2005 and 2008 – Comparison of key capabilities:
Feature
2005 Express
2005 Workgroup
2005 Standard
2005 Enterprise
2008 Standard
Number of CPUs
1
2
4
No Limit
4
RAM
1 GB
3 GB
Operating system maximum
Operating system maximum
Operating system maximum
x64 Support
WOW (Windows on Windows)
WOW
Yes
Yes
Yes
Max. Database Size
4 GB
No Limit
No Limit
No Limit
No Limit
Note that SQL 2005 Express is only suitable for small workgroups. If used for large workgroups the RAM and CPU limitations will result in poor performance. Also the database size may be exceeded which will cause Vault to stop functioning.
