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

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
LVL 1
Y YconsultantAsked:
Who is Participating?
 
Lee W, MVPConnect With a Mentor Technology and Business Process AdvisorCommented:
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
 
Vaseem MohammedCommented:
My suggestion would be to check the life cycle of the product and decide accordingly.
http://support.microsoft.com/gp/lifeselectindex
0
 
VishalnarseConnect With a Mentor System Wintel Administrator L2Commented:
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Always the last version unless you have some incompatible issue with that version.
0
 
VishalnarseSystem Wintel Administrator L2Commented:
I don't thing so, however you can test it on the testing environment and then you can try on the production environment.
0
 
Y YconsultantAuthor Commented:
Thank you very much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.