We are running SQL 2012 on a WS2008 R2 host.  I'm looking for a process to upgrade the host OS from 2008R2 to 2012 R2.  Is it as simple as stopping SQL and upgrading the host?

Are there any "gotcha's"?

Thank you.

Hi, take a look here

http://blogs.technet.com/b/chrisavis/archive/2013/10/01/performing-an-in-place-upgrade-of-server-2008-r2-to-server-2012-r2.aspx

hope will help

You can watch the following videos:

Upgrade from WIndow Server 2008 R2 to Windows Server 2012

Windows Server 2008 R2 Upgrade/Migrate to Server 2012

In-place upgrade from Windows Server 2008 or Windows Server 2008 R2 to Windows Server 2012 RC

And read the following articles:

How to upgrade Windows Server 2008R2 to Windows Server 2012

Performing an in place upgrade of Server 2008 R2 to Server 2012 R2

We are running SQL 2012 on a WS2008 R2 host.  I'm looking for a process to upgrade the host OS from 2008R2 to 2012 R2.  Is it as simple as stopping SQL and upgrading the host?

Are there any "gotcha's"?

Thank you.

If you want more safer approach. Obtain new hardware install windows server 2012 R2. Thwn install sql server 2012. Move database by backup restore mechanism and logins and jobs by scripting out.

Hi neilchapman,

Besides other post, it is highly recommended to have SQL Server backups and if possible an image of your server if you choose to perform an in-place upgrade.

Also please note that we must apply SQL Server 2012 Service Pack 1 or a later update when running SQL Server 2012 on Windows Server 2012 R2. For more details, please review this KB article: How to use SQL Server in Windows 8, Windows 8.1, Windows Server 2012, and Windows Server 2012 R2.


Thanks,
Lydia Zhang