Can I Upgrade SharePoint Content Database from SQL 2008 R2 to SQL 2012?
Posted on 2015-02-03
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.