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

Comments

Popular posts from this blog

Using External Content Types with Stored Procedures with Input Parameters

NAV 2009 Issues in Role Tailored Client