question

angela avatar image
angela asked

what is need to do in sql server 2008 r2 database server if we want to upgrade window 2008 to window 2012?

what is need to do in sql server 2008 r2 database server if we want to upgrade window 2008 to window 2012?
sql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
MAXKA avatar image
MAXKA answered
All you need to look is what is supported in windows server 2012 for SQL server 2008R2. Very first thing to note what edition of SQL server 2008R2 are you talking here? 1. Because as per MS, in express editions you will face issues and error while setting them up. Other points to note: a) You must apply Microsoft SQL Server 2008 R2 Service Pack 1 or a later update. b) The RTM installation of the product is supported. However, you have to install the respective service packs after the initial setup is complete. c) As stated by MS: > Windows Server 2012 R2 and Windows Server 2012 have three feature states, or modes: Full Server Minimal Server Interface Server Core > You can switch between these feature states at any time. You can switch from Server Core or Minimal Server Interface to Full Server when one or more instances of SQL Server 2014 or SQL Server 2012 are installed. However, be aware that you cannot switch from Full Server to Minimal Server Interface or Server Core when one or more instances of SQL Server 2014 or SQL Server 2012 are installed. > > > To switch from Full Server to Minimal Server Interface or Server Core when one or more instances of SQL Server 2014 or SQL Server 2012 are installed, you must uninstall SQL Server 2014 or SQL Server 2012, switch modes, and then reinstall SQL Server 2014 or SQL Server 2012. However, you can turn on SQL Server 2014 or SQL Server 2012 installation prerequisites in Full Server mode, switch to Server Core mode, and then install SQL Server 2014 or SQL Server 2012. d) check for the .Net framework support while upgrading on windows server 2012. e) You may need to check with app owners for the applications hosted currently on windows server 2008R2 that might change when you upgrade to windows server 2012. f) see System Center Advisor rule information from link below: https://support.microsoft.com/en-gb/kb/2681562
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.