Upgrade SharePoint 2013's SQL Instance from SQL 2k8 R2 to SQL 2014

1. Install SP2 for SQL Server 2008 R2
Refer below versions:
SQL Server 2014 supports upgrade from the following versions of SQL Server:
SQL Server 2005 SP4 or later
SQL Server 2008 SP3 or later
SQL Server 2008 R2 SP2 or later
SQL Server 2012 SP1 or later

Refer: http://msdn.microsoft.com/en-us/library/ms143393.aspx

2. Install SP1 for SP 2013
3. Upgrade from SQL2K8 R2 SP2 to SQL 2014
Refer: http://www.mssqltips.com/sqlservertip/3245/quick-guide-to-upgrading-to-sql-server-2014/
Be careful to select SharePoint instance
4. Restore QTA Backup

5. Install SP2 for SQL 2014


Popular posts from this blog

Using External Content Types with Stored Procedures with Input Parameters

HTTPS Site InfoPath Issue : You do not have permissions to access a web service that provides data required for this form to function correctly

Windows 7 Blue Screen because of ConnectiFy