locked
Windows upgradation RRS feed

  • Question

  • Hello,

    Our windows team has planned to upgrade the OS level from Windows 2003 standard and standardx64 edition on standalone SQL database servers to windows 2008 R2.

    What should be the prerequisite (like db backups mandatory)and general guidelines from DBA standpoint during the upgrade ,Can the database be online or should the sql services be suspended during the entire time the OS is into upgradation.

    What should i emphasis with my Windows counterpart to be agile on any shared responsibility we might undertake during this.

    Regards

    Eben

    Friday, April 10, 2015 1:46 PM

Answers

  • Hello,

    You can perform an in-place upgrade to Windows 2008/2008R2 if Windows 2003 has SP1 applied, just stop SQL Server services using SQL Server Configuration Manager and set them to manual. Do not upgrade from Small Business Server 2003 and 2003 R2. However, a clean installation of Windows 2008/2008R2 in a new server is recommended.



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, April 10, 2015 2:45 PM

All replies

  • One more point to add is some will be upgraded to 2008 as well and not only 2008R2
    Friday, April 10, 2015 1:50 PM
  • Please post this question in windows server forum. This is migration forum for SQl Server

    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 Article

    MVP

    Friday, April 10, 2015 2:22 PM
  • Hello,

    You can perform an in-place upgrade to Windows 2008/2008R2 if Windows 2003 has SP1 applied, just stop SQL Server services using SQL Server Configuration Manager and set them to manual. Do not upgrade from Small Business Server 2003 and 2003 R2. However, a clean installation of Windows 2008/2008R2 in a new server is recommended.



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, April 10, 2015 2:45 PM