Solved

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

Posted on 2014-09-11
6
393 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
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 95

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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 49

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

What to do when Windows Update is not working correctly? What tools can I use to detect the cause of the malfunction problem? What does this numeric error code mean? These and other questions that you have been asking in the past are answered here (…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

713 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