none
Can i detach Sharepoint 2007 Databases from a SQL Server 2008R2 and attach on SQL Server 2014 without migrate Sharepoint? RRS feed

  • Question

  • Hi,

    I would like to known if i can detach Sharepoint 2007 Databases from SQL Server 2008R2 (Windows Server 2008R2) and attach on SQL Server 2014 (Windows Server 2012R2) without migrate Sharepoint?

    Assuming it's possible, here's what I would do:

    • Stop Sharepoint Services and IIS on my WFEs
    • Detach the Sharepoint DBs from SQL SERVER 2008R2
    • Attach all Sharepoint DBs on SQL Server 2014
    • Fire up all the Sharepoint Services and IIS again

    Anyone have any recommendations?

    Tks,

    _Kenny


    Keny Maciel da Silva DBA SQL Server MCSA - Administering a Microsoft SQL Server 2012/2014 Database MCSA - Querying Microsoft SQL Server 2012/2014 MCTS - SQL Server 2008, Installation and Maintenance Email: kenymaciel@gmail.com

    Friday, March 15, 2019 5:06 PM

All replies

  • SharePoint 2007 does not support SQL 2014. You can go up to SQL Server 2008 R2, max.

    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Friday, March 15, 2019 5:11 PM
  • Hi Trevor, Thanks for the feedback

    Sharepoint will continue to be 2007, I will only migrate the Databases from SQL 2008 to SQL 2014.

    I can't do it?


    _Kenny


    Keny Maciel da Silva DBA SQL Server MCSA - Administering a Microsoft SQL Server 2012/2014 Database MCSA - Querying Microsoft SQL Server 2012/2014 MCTS - SQL Server 2008, Installation and Maintenance Email: kenymaciel@gmail.com

    Friday, March 15, 2019 5:28 PM
  • That's correct. SharePoint 2007 does not support SQL 2014. You can go up to SQL 2008 R2.

    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Friday, March 15, 2019 6:14 PM
  • Right, in this case I have to migrate Sharepoint 2013 as well?


    Keny Maciel da Silva DBA SQL Server MCSA - Administering a Microsoft SQL Server 2012/2014 Database MCSA - Querying Microsoft SQL Server 2012/2014 MCTS - SQL Server 2008, Installation and Maintenance Email: kenymaciel@gmail.com

    Friday, March 15, 2019 6:26 PM
  • Yes, SharePoint 2013 with Service Pack 1 supports SQL 2014.

    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Friday, March 15, 2019 6:35 PM
  • ok Travor,

    So, first i'll migrate from Sharepoint 2007 to Sharepoint 2013.

    Thanks.


    Keny Maciel da Silva DBA SQL Server MCSA - Administering a Microsoft SQL Server 2012/2014 Database MCSA - Querying Microsoft SQL Server 2012/2014 MCTS - SQL Server 2008, Installation and Maintenance Email: kenymaciel@gmail.com


    Friday, March 15, 2019 6:39 PM