Solved

Should I install SQL Server 2008 R2 on Windows Server 2008 R2 or 2012 R2?

Posted on 2014-09-11
6
395 Views
Last Modified: 2014-09-14
I am going to make a VM to run SQL Server 2008 R2. The host is Windows Server 2012 R2 Hyper-V role.
I have two options for the VM's OS - Windows Server 2008 R2 or 2012 R2. Which one is better?

Thanks
0
Comment
Question by:techcity
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 12

Expert Comment

by:Vaseem Mohammed
ID: 40316381
My suggestion would be to check the life cycle of the product and decide accordingly.
http://support.microsoft.com/gp/lifeselectindex
0
 
LVL 96

Accepted Solution

by:
Lee W, MVP earned 250 total points
ID: 40316412
If you have CALs for 2012 and don't want to use it for something else (like an RDS server) then use 2012.  Otherwise, use 2008R2.  BUT FIRST, consult your application requirements.
0
 
LVL 4

Assisted Solution

by:Vishalnarse
Vishalnarse earned 250 total points
ID: 40316440
If you are going to use Hyper V platform then please use  windows 2012 R2 or you can us 2008 R2 but I my suggestion is 2012 Rs is best and good for Hyper V hyper-visor platform.

Please refer the blow link for windows 2012 R2

http://www.infoworld.com/slideshow/104337/10-great-new-features-in-windows-server-2012-r2-hyper-v-220067#slide5

and

http://www.infoworld.com/slideshow/108930/10-excellent-new-features-in-windows-server-2012-r2-222024

Please revert if you need any further assistance.
 
Thank you.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40316566
Always the last version unless you have some incompatible issue with that version.
0
 
LVL 4

Expert Comment

by:Vishalnarse
ID: 40316585
I don't thing so, however you can test it on the testing environment and then you can try on the production environment.
0
 
LVL 1

Author Closing Comment

by:techcity
ID: 40322066
Thank you very much!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Basic to Dynamic disk 4 62
Creating a View from a CTE 15 49
Windows 2008 standard, Disk Cleanup, and Winsxs 30 61
WannaCry ransomware worm 2008 and 2012 server 1 145
Resolve DNS query failed errors for Exchange
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question