[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


sql server version need to be install ?

Posted on 2011-05-06
Medium Priority
Last Modified: 2012-06-21
We have operating system  Windows 2008 Enterprise R2, should we install with sql2008 or sql2008 R2 ?
Question by:motioneye
LVL 21

Expert Comment

by:Alpesh Patel
ID: 35705348
yes you can.

Accepted Solution

malikirfan28 earned 400 total points
ID: 35705351
Here is the Hardware and Software Requirements for Installing SQL Server 2008 R2 and if it meets at your side then I will prefer to go with SQL Server 2008 R2.
LVL 18

Assisted Solution

sventhan earned 400 total points
ID: 35705375
( no points)

You can go with SQL server 2008 R2. I've recently done the same.
Industry Leaders: 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!

LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 400 total points
ID: 35705384
you can install any of these 2. if you have the option, install the latest one (R2)
LVL 28

Assisted Solution

imran_fast earned 400 total points
ID: 35705429
You can go with either of the two but better instally sql server 2008 R2
LVL 23

Assisted Solution

OP_Zaharin earned 400 total points
ID: 35706161
- u must know the difference between the two before deciding. i'm sharing with u some info:

: R2 is released in 2010. SQL 2008 a couple of years ago
: R2 support up to 256 logical processors (based on edition) while 2008 support up to 64 logical processors
: Power Pivot with Microsoft Excel and SharePoint integration for more BI feature on R2
: new dashboards in SSMS for DBAs to monitor and manage multiple instances of SQL Server.

I would also suggest R2 :)

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

872 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