<div>
Thank you QPR - This is exactly what I was looking for
</div>


Thank you QPR - This is exactly what I was looking for

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
I have a two-server SharePoint 2010 farm consists of the following:<br />
<br />
1) SQL Server 2008 R2 server<br />
2) Application Server (SharePoint 2010)<br />
<br />
I need to upgrade the SQL Server from 2008 R2 Enterprise to 2012 Enterprise.<br />
<br />
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.<br />
<br />
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)<br />
<br />
Please note that this is a Production environment, so I don't want to mess with it.<br />
<br />
Thank you
</div>
</div>


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

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

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.