Solved

How to upgrade editions with SQL Server 2008 R2 SP 2?

Posted on 2014-03-17
3
199 Views
Last Modified: 2014-03-21
Hello,


I have SQL Server 2008 R2 SP2 Standard Edition installed.  I like to switch to the Enterprise Edition.  I have the license key, but do I need the Enterprise install program that has SP2?

Thanks,

Paul
0
Comment
Question by:PBIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 500 total points
ID: 39935311
"How to perform an SQL Server Edition Upgrade":

http://blogs.msdn.com/b/petersad/archive/2011/01/24/how-to-perform-an-sql-server-edition-upgrade.aspx


Just MAKE SURE you take and keep a SAFE FULL Database backup of all your user databases.
0
 

Author Comment

by:PBIT
ID: 39935355
Do I need the Enterprise Install with SP2?  How do I handle the SP2, if I just use an install program that does not include the SP2?
0
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 39935402
You will install SP2 on the top of your SQL 2008 R2 Enterprise.
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

724 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