locked
SQL Server Compatability Issues / Clarifications RRS feed

  • Question

  • Hello Team

    We have SQL Server installed on our project servers running on Windows 2008 Servers and the details are as below.

    Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
    Dec 28 2012 20:23:12 
    Copyright (c) Microsoft Corporation
    Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

    This is running on Windows Server 2008 (Virtual Server i.e Cloud Server) and the RAM is 16 GB of which maximum memory allocated to this SQL instance is 10 GB.

    Microsoft is discontinuing the support of Windows Server 2008 from March 31, 2017. So on we are upgrading the servers to Windows Server 2016 Standard and Data Center Editions.

    On this I would like to know if the existing SQL server environment which is already available on Windows 2008 is compatible to new Windows 2016. Do we have any process for upgrading this from existing environment. We also have SQL Server Reporting functionality configured on it.

    Any process to upgrade all at a time ? Please suggest on it. Thanks

    Friday, March 3, 2017 4:21 AM

Answers

  • Hello Team

    We have SQL Server installed on our project servers running on Windows 2008 Servers and the details are as below.

    Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
    Dec 28 2012 20:23:12 
    Copyright (c) Microsoft Corporation
    Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

    This is running on Windows Server 2008 (Virtual Server i.e Cloud Server) and the RAM is 16 GB of which maximum memory allocated to this SQL instance is 10 GB.

    Microsoft is discontinuing the support of Windows Server 2008 from March 31, 2017. So on we are upgrading the servers to Windows Server 2016 Standard and Data Center Editions.

    On this I would like to know if the existing SQL server environment which is already available on Windows 2008 is compatible to new Windows 2016. Do we have any process for upgrading this from existing environment. We also have SQL Server Reporting functionality configured on it.

    Yes SQL Server 2012 is fully supported on windows server 2016 BUT you need to first apply SQL Server 2012 Sp2 and then do whatever upgrade you want to. So your step should be like

    1. Upgrade SQL server 2012 to Sp2 and check your application and other functionalities

    2. Install windows server 2016 

    3 Install SQL Server 2012 with Sp2. Then backup database from old machine and restore it on new machine. You cna backup system and user databases(except tempdb which is not allowed) and restore it on new machine and then you are good to go.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Proposed as answer by Teige Gao Monday, March 6, 2017 9:45 AM
    • Marked as answer by DRI USER Wednesday, March 8, 2017 9:41 AM
    Friday, March 3, 2017 5:55 AM

All replies

  • Hello Team

    We have SQL Server installed on our project servers running on Windows 2008 Servers and the details are as below.

    Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
    Dec 28 2012 20:23:12 
    Copyright (c) Microsoft Corporation
    Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

    This is running on Windows Server 2008 (Virtual Server i.e Cloud Server) and the RAM is 16 GB of which maximum memory allocated to this SQL instance is 10 GB.

    Microsoft is discontinuing the support of Windows Server 2008 from March 31, 2017. So on we are upgrading the servers to Windows Server 2016 Standard and Data Center Editions.

    On this I would like to know if the existing SQL server environment which is already available on Windows 2008 is compatible to new Windows 2016. Do we have any process for upgrading this from existing environment. We also have SQL Server Reporting functionality configured on it.

    Yes SQL Server 2012 is fully supported on windows server 2016 BUT you need to first apply SQL Server 2012 Sp2 and then do whatever upgrade you want to. So your step should be like

    1. Upgrade SQL server 2012 to Sp2 and check your application and other functionalities

    2. Install windows server 2016 

    3 Install SQL Server 2012 with Sp2. Then backup database from old machine and restore it on new machine. You cna backup system and user databases(except tempdb which is not allowed) and restore it on new machine and then you are good to go.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    • Proposed as answer by Teige Gao Monday, March 6, 2017 9:45 AM
    • Marked as answer by DRI USER Wednesday, March 8, 2017 9:41 AM
    Friday, March 3, 2017 5:55 AM
  • Ok Thankyou


    Sambaraju Kiran

    Monday, March 6, 2017 11:16 AM
  • Hi DRI USER,

    Have you solved your problem? If you are satisfied with the reply of Shanky_621, could you please mark his reply as Answered?

    Best Regards,
    Teige

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, March 8, 2017 6:11 AM
  • Yes, it solved my problem and I marked it as answer. Thankyou

    Sambaraju Kiran

    Wednesday, March 8, 2017 9:41 AM