locked
Upgrading Win 2003 Ent Server Hosting SQL Server 9.0.1399 (SQL 2005) RRS feed

  • Question

  • hi guys,

    i need to upgrade my win 2003 R2 Ent server to Win 2008 R2 Ent. this server host SQL 2005. Can an inplace upgrade be done with little or no trouble from SQL 2005 or will i have to remove the SQL then upgrade and then re-settup SQL again

    Thanks for comments ! :) 

    Monday, April 2, 2012 4:36 PM

Answers

  • Hi,

    It should be fine to upgrade your OS to Windows 2008 R2 without affecting your current SQL Server 2005 installation.

    This article covers some issues you need to be aware of http://support.microsoft.com/kb/955725

    It would also be highly recommended to have SQL Server backups and if possible an image of your server before the upgrade, just in case something goes wrong.

    • Marked as answer by amber zhang Monday, April 9, 2012 2:59 AM
    Tuesday, April 3, 2012 1:27 AM

All replies

  • as you're upgrading from W2K3 to W2K8R2 if would recommend to upgrade to SQL 2008R2 or 2012 due to the product life cycle of SQL 2005 which had reached Extended Support now.

    BTW as your W2K3 server is probably several years old I would recommend to switch to a complete new server with latest OS and SQL Server version.

    Monday, April 2, 2012 5:20 PM
  • Hi,

    It should be fine to upgrade your OS to Windows 2008 R2 without affecting your current SQL Server 2005 installation.

    This article covers some issues you need to be aware of http://support.microsoft.com/kb/955725

    It would also be highly recommended to have SQL Server backups and if possible an image of your server before the upgrade, just in case something goes wrong.

    • Marked as answer by amber zhang Monday, April 9, 2012 2:59 AM
    Tuesday, April 3, 2012 1:27 AM
  • Thanks guys i will attempt the upgrade soon a tell results.

    I will be sure to backup and make image of server 1st !

    Wednesday, April 4, 2012 6:55 PM
  • Did your upgrade work. I am in the same situation as looking at upgrading Server 2008 with SQL 2012 to Server 2008 r2.
    Thursday, April 26, 2012 8:30 PM