• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

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
0
techcity
Asked:
techcity
2 Solutions
 
Vaseem MohammedCommented:
My suggestion would be to check the life cycle of the product and decide accordingly.
http://support.microsoft.com/gp/lifeselectindex
0
 
Lee W, MVPTechnology 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
 
VishalnarseSystem 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
techcityAuthor Commented:
Thank you very much!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now