SQL Server 2008 R2 Edition Differences

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?
LVL 1
RobertSystems AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TempDBACommented:
#1. Yes it should be. See the link below:-
http://blogs.msdn.com/b/joaol/archive/2011/07/11/sql-server-2008-r2-setup-failing-on-windows-2008-r2-sbs.aspx

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DMTechGrooupCommented:
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.

http://www.zdnet.com/windows-small-business-server-2008-3039549408/

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

http://www.amazon.com/Windows-Small-Business-Server-Premium/dp/B004I6L420

http://www.dell.com/downloads/us/bsd/bsd/SBS_Premium_Add-on%20Datasheet_Final.pdf
0
David ToddSenior DBACommented:
Hi,

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'.

HTH
  David
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

RobertSystems AdministratorAuthor Commented:
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?
0
RobertSystems AdministratorAuthor Commented:
Thank you for all of the input.  I purchased the SQL Server SBS edition.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.