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
Sorry about that…confusing my Windows and SQL versions.
JD
Hi,
Just to claify i dont think there is any version called sql server 2012 R2.
http://sqlserverbuilds.blogspot.com.au/
http://sqlmag.com/sql-server-2012/sql-server-2012-editions
Matt.. if i were on your place i will create a new sql server with latest version in your case sql 2012 if posisble.
Patch the sharepoint server 2010 which supports this latest version.
Create alias based on the old sql server name as it was discussed on the sharepoint stackexchange.
Create a dummy web app and verify it if it goes to the new sql server.
Then move the content database and see of that works for me and then Move all the databases.
i don’t prefer V2V as i cant guarantee if something goes wrong with that upgrade how i would get all my data back.
if you have a good management which help you out to play the scenarios on the temp VMs then there is nothing like that.
Best Luck Mate.
Hi Matt,
With SP2, SharePoint 2010 can work with SQL Server 2012 but it doesn’t support SQL Server 2012 R2.
Regards,
JD
After you configure the new server farm, you can restore the backup copies of the databases on one of the following: Microsoft SQL Server 2008 R2, SQL Server 2008 with Service Pack 1 (SP1) and Cumulative Update 2, and SQL Server 2005 with SP3 and Cumulative Update 3. Note that you must restore to a 64-bit version of SQL Server 2008 R2, SQL Server 2008 with SP1 and Cumulative Update 2, and SQL Server 2005 with SP3 and Cumulative Update 3. Start with one database, and then verify that the restoration has worked before you restore the other databases.
More Information : http://technet.microsoft.com/en-in/library/cc287634%28v=office.14%29.aspx
