SQL Server 2008 R2 Edition Differences

Posted on 2013-09-24
Medium Priority
Last Modified: 2016-11-23
My company wants to upgrade from SQL Server 2008 R2 Express Edition with Advanced Services to the 2008 R2 Standard Edition.  Before making any purchases, I just want to verify a few things:

1) The Dell server is running Windows Small Business Server 2011.  Will the "SQL Server 2008 R2 Standard Edition for Small Business" qualify as a valid edition upgrade?  I would normally assume it would, but given the cost of this product, I don't want to make any assumptions.

2) Besides price, what's the difference between the Standard Edition and the Standard Edition for Small Business?
Question by:Robert
LVL 25

Accepted Solution

TempDBA earned 1000 total points
ID: 39520339
#1. Yes it should be. See the link below:-

#2. Both are functionally same with the difference in the server where you need to install them.
LVL 24

Assisted Solution

DMTechGrooup earned 1000 total points
ID: 39520340
SQL is the same as a standalone or as SBS.. in fact MS gives you a separate server license if you want to put SQL on its on server.


You would need SBS 2001 premium add on for the SQL part.


LVL 35

Expert Comment

by:David Todd
ID: 39522463

A key difference between these two editions of sql, is that normally SQL and Exchange don't work well together on the same box. There are subtle changes to each for SBS so they will 'play nicely'.

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Author Comment

ID: 39522642
Thank you for the helpful information.  Based on the comments, it seems that I can either purchase SQL Server 2008 R2 Standard Edition for Small Business, or purchase the Windows Server 2001 Premium Add-on.

My preferred goal is to upgrade the current edition... not to backup the DB, remove the Express edition, install the new edition, and restore the DB.  With the SQL SBS setup, I should be able to upgrade the existing edition.  Will I be able to upgrade the edition with the Premium Add-on as well, or will I have to remove the Express edition first?

Author Comment

ID: 39533269
Thank you for all of the input.  I purchased the SQL Server SBS edition.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

There’s hardly a doubt that Business Communication is indispensable for both enterprises and small businesses, and if there is an email system outage owing to Exchange server failure, it definitely results in loss of productivity.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question