I need to confirm for my SQL DBA that in FACT you cannot move/upgrade all SharePoint 2010 Databases from one SQL Server 2005 SP3 Server to a New SQL 2012 R2 Server.
*note: we did not use SQL Aliases.
Can someone who knows confirm that for me and provide a brief explanation? …Any references to the fact from Microsoft are also appreciated.
Thank you.
Matt
Hi Matt,
With SP2, SharePoint 2010 can work with SQL Server 2012 but it doesn’t support SQL Server 2012 R2.
Regards,
JD