• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Can I Upgrade SharePoint Content Database from SQL 2008 R2 to SQL 2012?

Hello experts,

I have a two-server SharePoint 2010 farm consists of the following:

1) SQL Server 2008 R2 server
2) Application Server (SharePoint 2010)

I need to upgrade the SQL Server from 2008 R2 Enterprise to 2012 Enterprise.

Question: Is that a straightforward process using the SQL installer, or do I need to do other tasks on the SharePoint server, since all databases of the farm are residing on the SQL server.

Also, is there any way I can take backup of the entire farm, so in case things went wrong, I can restore my farm back to the previous state (with SQL 2008 R2)

Please note that this is a Production environment, so I don't want to mess with it.

Thank you
1 Solution
MehawitchiAuthor Commented:
Thank you QPR - This is exactly what I was looking for
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

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now