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

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

Using External Content Types with Stored Procedures with Input Parameters

Windows 7 Blue Screen because of ConnectiFy