Moving SharePoint from one SQL instance to another

1.       Shutdown SharePoint Front-End Server after stopping all SP Services
2.       Stop the SQL Server Service in SQL02
3.       Copy all database files from SQL02 – MDF, LDF files pertaining to the SharePoint instance
4.       Move these database files to SQL01’s D Drive (whichever drive has higher space)
5.       Install SQL Server 2012 with SP2 or SQL 2014 Std edition on SQL01
6.       Then attach these files to SQL01’s SQL Instance
7.       Restart the SharePoint Front-End Server and start all SP services
8.       Run PowerShell Commands to re-map the SharePoint Server to point to the new SQL Server

9.       Test whether the SharePoint environment works fine


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