Solved

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

Posted on 2014-09-11
6
385 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 46

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

914 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now