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
Aniket – Thank you for you response.
I am afraid that these suggestions are speaking of a v2v upgrade on the same SQL server.
I am asking about not only a newer SQL Version, but one that is installed on a completely separate server.
In your opinion, does this make a difference?
Thanks,
Matt
