none
any impact to SQL Server when upgrade OS

    Question

  • Hi

    my client is planning to upgrade existing OS from Windows Server 2008 Standard to windows server 2012 datacenter. is there nay impact to SQL Server?

    Wednesday, February 15, 2017 10:30 PM

All replies

  • Hi, should be fine, but best to test in a non-Prod environment first and ensure you have backups.

    Considerations should be that Windows Server 2012 in only 64bit so could be a problem if current server is 32bit.

    Hopefully the server doesn't have SQL Server 2005.

    Wednesday, February 15, 2017 11:00 PM
  • thanks for your info. 

    they are using Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Standard Edition (64-bit) and current server is 64bit.


    • Edited by kjleong Thursday, February 16, 2017 12:39 AM
    Thursday, February 16, 2017 12:38 AM
  • In addition to the upgrade, to make SQL as stable as possible, it may be worth testing and applying the latest SQL Server 2012 patches SP3 with CU7
    Thursday, February 16, 2017 12:44 AM
  • I just migrated a 2008r2 server to 2016.. I thought about going down the inplace upgrade path to 2012 but got worried so I built a new server and backed up the old db then created a new SQL server on the 2016 build and imported it.

    I would like to know how it goes however as I have never attempted an upgrade to the OS on a server.

    Thursday, February 16, 2017 1:05 AM