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
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.
Matt,
I haven’t tried this specific move before as we are using 2008 R2 or newer for everything. You will need to make sure SP 2010 is patched to the latest service pack at least.
You could then detach all the SQL DBs, copy them to the new SQL server, attach them to SQL and bring them online, use CLIconfg on each SP server to basically map old sql server name to new sql server name. This will reroute database communication to the new SQL server. Then see if SP works. If it doesn’t, just roll back the CLIConfg change.
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
Hi There,
I cant find the better article but this is for sp2007 from 2005 to 2008 sql version
this is the interesting talk about the upgrade but you can choose the steps Steve provide.
I cant say what to tell to the DBA but you have to plan different approaches. And also do the thorough test in dev/test environment.
