What are the Impact of SQL Server when upgrading Windows

snr22 0 Reputation points
2023-05-08T05:47:58.2+00:00

My company is planning to upgrade from Windows 2008 to Windows 2016.

Are there any considerations for keeping Microsoft SQL Server 2012 as it is?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,808 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,205 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,001 Reputation points
    2023-05-08T06:05:49.0633333+00:00

    Windows 2016 is support as OS for SQL Server 2012.

    https://learn.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows

    You should apply SP4 for SQL Server 2012, if not already done.

    And keep in mind that SQL Server 2012 is already out-of-support:

    https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2012

    0 comments
  2. Gulshan Negi 75 Reputation points
    2023-05-19T13:00:48.5233333+00:00

    Hello, this is Gulshan Negi.

    Well, while updating from Windows Server 2008 to Windows Server 2016 while keeping Microsoft SQL Server 2012, taking into account the following is fundamental:

    1. Confirm the similarity of SQL Server 2012 with Windows Server 2016 and check for any known issues or required refreshes.
    2. Check that the hardware and software requirements for Windows Server 2016 and SQL Server 2012 are satisfied.

    Review the upgrade path and follow Microsoft's documentation for migrating from Windows Server 2008 to Windows Server 2016.

    Check the similarity level of your SQL Server 2012 data sets and think about refreshing them if necessary.

    Before beginning the upgrade, ensure you have a comprehensive database backup strategy.

    After the upgrade, ensure your SQL Server 2012-based applications and services work as intended.

    Plan for future upgrades to newer versions of SQL Server 2012 and consider the support and end-of-life dates.

    You can ensure a successful upgrade while maintaining your SQL Server 2012 installation by considering these factors and adhering to best practices. You should involve your IT team and review the official documentation for specific, environment-specific guidance.

    Thanks

    0 comments