SharePoint 2013 moving our databases from SQL 2012 to 2014. Best practices, suggestions or problems. What are your thoughts?
Thanks and I appreciate it.
Most Important don’t forget to make new SQL server instance to be MAXDOP =1.
The best approach is a backup and restore that would work for this situation.
However, below are some informative links which lets you how to move databases specially content database of SharePoint server. You can select appropriate SharePoint version.
Move all databases in SharePoint 2013
Migrate SharePoint’s SQL Server to another SQL Server
You may also get help from this guide for moving SharePoint Content Databases to a New Server. Also check this earlier thread having suggested solutions for moving databases from SQL Server 2012 to SQL Server 2014.
Additionally, here is a list of content migration tools for SharePoint: https://collab365.directory/office365-sharepoint/best-sharepoint-migration-tools/
Hope this helps!
Why you wanted to move to SQL 2014?
Do you have a sql alias for your current farm?
If you have you can move databases to the new sql server and switch the sql alias to the new server.
If not then you have to make your existing sql server name as sql alias to point to the new sql 2014 server.
There is a gotcha with SQL 2014 and SharePoint 2013. Your SharePoint version will be at least at this version level:
https://support.microsoft.com/en-us/kb/2878240
otherwise the UPS Sync will not work.
