Solved

On a Sharepoint server, need to upgrade MS SQL 2008 Express to MS SQL 2008 R2 Std

Posted on 2014-02-24
5
330 Views
Last Modified: 2014-02-26
Hello, thank you for taking the time to read this posting.

We have the following:
Windows Sharepoint Foundation server 2010
On Win 2008 R2 with MS SQL 2008 Express

Want to:
install our MS SQL 2008 R2 Std license onto this server

1) Can we not just do an upgrade of the SQL software?
2) Could we export the database, uninstall the software and reinstall, with the same names etc and it would be ok?
3) otherwise, whats the best approach?
0
Comment
Question by:plexusdev
[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
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 250 total points
ID: 39887389
There's no need to detach and reattach the databases at all - you can just perform an edition upgrade on the database instance. Using your SQL 2008 Standard Edition media, launch setup and, under "Maintenance", select "Edition Upgrade" - this is the supported method for changing your edition of SQL Server from something to something higher (express -> standard, standard -> enterprise, trial -> standard, etc.).

For some more details, this arcticle lists out the concerns, but there's nothing major to worry about:

http://sqlblog.com/blogs/tibor_karaszi/archive/2011/01/27/upgrading-from-express-edition-to-standard-edition.aspx

The edition change is a quick operation - it's not a reinstallation of SQL Server at all, but just changing a few files to reflect the new edition, and it should only take a couple of minutes. At most, it would require a restart of the SQL Engine after the setup completes to get it to pick up the new SKU and enable the proper features/remove limitations of express.
0
 

Author Comment

by:plexusdev
ID: 39887415
This is safe for a Sharepoint server? I read someone said it would affect the farm databases
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 39887555
There's no need to detach and reattach the databases at all - you can just perform an edition upgrade on the database instance.
I would agree with you except that they are going from SQL Server 2008 Express to SQL Server 2008 R2 Standard Edition.  That is a version upgrade as well as a SKU change.

In my view they should first do an in place version upgrade to SQL Server 2008 R2 Express Edition and then follow your advice.
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 39888790
Hmm - I'd missed that they were also upgrading versions, but read the issue as just an edition upgrade. I'd probably recommend the edition change and then the upgrade, but that means you'd have to have a copy of the SQL 2008 Standard media to do the edition change, and they may not have it handy.

To the Author's other question, the edition change will have no impact on the databases or on Sharepoint - however, changing the version of SQL (upgrading from 2008 to 2008 R2) would impact the databases. What exact version an SP of SharePoint are you using? I suspect that 2008 R2 is supported by your build of SharePoint, but there may be a service pack involved as well in getting the versions to match up.
0
 

Author Closing Comment

by:plexusdev
ID: 39889185
Thank you!!!!
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

636 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