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
(Visited 75 times, 1 visits today)
Matt, despite the fact that you haven’t yet used SQL Aliases, I believe you’ll find the proper solution involves putting them in place now.
See guidance from Dan Holme and Todd Klindt on the use of aliases for moving databases.
(Visited 1 times, 1 visits today)
