none
SCCM 2012 R2 SP1 Site database Move to latest sql server

    Question

  • Current hiearchy: SCCM 2012 R2 Sp1
    Current Site Database: Windows Cluster Server, OS Windows 2008 R2, Sql 2008 r2

    We are planning to migrate Site database server to another new cluster hardware. we are considering with OS 2016 and SQl Server 2016.

    Could someone please guide steps to follow to move site dataabse server to new hardware & sql version.

    Do we need to first install sql 2008 r2 on new hardware, move site database then in place upgrade of the sql server? Can we directly install Sql 2016 directly and then move site database to new sql server


    Thursday, April 26, 2018 8:53 AM

All replies

  • Refer to Jason's comments here on a suitable upgrade path as you are in the same situation - 

    https://social.technet.microsoft.com/Forums/en-US/37bf4463-818d-4453-80e1-f7170aab8e65/sccm-2012-sp1-r2-to-sccm-cb1802-migration?forum=configmanagermigration


    Dan Padgett | Blog: http://execmgr.net | Twitter: @danjpadgett

    • Proposed as answer by Garth JonesMVP Friday, April 27, 2018 12:06 PM
    Thursday, April 26, 2018 9:50 AM
  • Thanks Dan..Can you help with below query

    Do we need to first install sql 2008 r2 on new hardware, move site database then in place upgrade of the sql server or Can we directly install Sql 2012/2014/2016 directly and then move site database to new sql server

    Thursday, April 26, 2018 10:34 AM
  • Thanks Dan..Can you help with below query

    Do we need to first install sql 2008 r2 on new hardware, move site database then in place upgrade of the sql server or Can we directly install Sql 2012/2014/2016 directly and then move site database to new sql server

    What is unclear about Jason's reply in this post? https://social.technet.microsoft.com/Forums/en-US/37bf4463-818d-4453-80e1-f7170aab8e65/sccm-2012-sp1-r2-to-sccm-cb1802-migration?forum=configmanagermigration


    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Thursday, April 26, 2018 12:40 PM
  • Hi,

    ->"we are considering with OS 2016 and SQl Server 2016."

    Quoting with Jason:

    ConfigMgr 2012 is not support on Server 2016.

    Best Regards,

    Lorry


    Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, April 27, 2018 7:55 AM
  • Hi,

    You have not update for a long time. 

    Have you solved this problem? Can you share the solutions to help more people?

    Please remember to mark the replies as answer if they help.

    Best Regards,

    Lorry


    Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, April 30, 2018 8:49 AM