| Dedicated Server - MSSQL 2005 versions Quick Comparison Guide |
Article ID:475 |
This article is intended for 3Essentials customers who are evaluating versions of MSSQL Server 2005 to include in their 3Essentials Dedicated Server.
MSSQL Server 2005 Quick Comparison Guide
| Version |
Express |
Workgroup |
Standard |
| Cost |
Free |
$ |
$$$ |
| multiCPU support |
No |
Yes |
Yes |
1 GB max memory limit
for buffer pool |
Yes |
No |
No |
| 4GB max database size |
Yes |
No |
No |
SQL Server Agent
|
No - As a result:
- no automated backups
- no scheduled maint tasks, incl:
- db shrinking
- reindexing
- etc..
|
Yes |
Yes |
| Full Text Search |
No |
Yes |
Yes |
| IMPORT/EXPORT |
No |
Yes |
Yes |
Integration Services with
Basic Transforms |
No |
No |
Yes |
Integration Services with
Advanced Transforms |
No |
No |
Yes |
Summary:
- MSSQL 2005 Express, while a free option, does have some important limitations for you to consider with respect to management and integration features. If those features are not important to your specific implementation, then MSSQL 2005 Express can deliver a powerful database solution for, well, n
- Keep in mind if you go with MSSQL 2005 Express on your dedicated server, there will be NO automated backup of your MSSQL databases. To get a MSSQL backup of your database made, you will need to submit a support request, asking for backup to be made.
- Further details on important limitations in MSSQL 2005 Express are covered here.
- MSSQL 2005 Workgroup offers the management features by including SQL Server Agent, but lacks some of the higher level integration features, but does this at a more affordable price point.
- MSSQL 2005 Standard is robustly featured, but at a significant price increase.
- We STRONGLY recommend you review Microsoft's comprehensive MSSQL 2005 version chart available here to help you make the most informed decision on features and limitations of the version you are considering including in your 3Essentials hosted dedicated server.
|
| Downloads associated with this article: |
| No downloads associated with this article |
 Back
to Search or Browse |
