Which is the best OS to install for MSSQL 2008 R2

Home Forums Other Microsoft Servers and SaaS SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 Which is the best OS to install for MSSQL 2008 R2

This topic contains 1 reply, has 2 voices, and was last updated by Avatar Ossian 2 weeks, 1 day ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Avatar
    BumbleBee
    Participant
    #624936

    Greetings SQL Heros,

    Our current MSSQL version is 2008 R2.

    I’m about to move the DB to a new server. Which OS version will be the best to fit the good old 2008 R2 SQL version? Is it Windows Server 2008 R2, Windows 2012, Windows 2016 or Windows 2019?

    Thanks!

    • This topic was modified 2 weeks, 1 day ago by Avatar BumbleBee.
    Avatar
    Ossian
    Moderator
    #624938

    According to this source (https://www.sqlskills.com/blogs/glenn/operating-system-support-for-sql-server-versions/) you are good up to 2012R2, but it is not a supported combination on Server 2016.

    I would not use 2008R2 as the OS because of the lack of support lifetime

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.