SQL Server 2008 R2 - which is thee correct update to download?

Posted on 2011-09-27
Last Modified: 2012-05-12
I have a brand new install of SQL Server 2008 R2 on Windows Server 2008 on Dell T710.  After migrating database, and trying to edit existing jobs, I got errors which research indicated could be corrected by installing cumulative updates.  So, I am interested in applying the latest update - which is 9.  The update may be downloaded here:
SQL Update Download list

My question:  Which of these is the one I should download and install?  Why?

...additional detail from the Help>About on SQL Server Management Studio:

Microsoft SQL Server Management Studio        10.50.1600.1
Microsoft Analysis Services Client Tools    10.50.1600.1
Microsoft Data Access Components (MDAC)        6.1.7601.17514
Microsoft MSXML                    3.0 6.0
Microsoft Internet Explorer            8.0.7601.17514
Microsoft .NET Framework            2.0.50727.5446
Operating System                6.1.7601

Question by:bleonardi
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

ID: 36714257
I can't see the update list, but I think there are 2 cumulative updates available.  The 2nd update should cover everything since the release of SQL 2008 R2, so you won't need the first update.

If that doesn't answer your question, post a screenshot of what you see.


Author Comment

ID: 36714281
screenshot attached


Accepted Solution

bkieler earned 500 total points
ID: 36714379
It looks to me like the 5th one from the top is your best bet.

1)  Nothing you've posted indicates that you have a 64-bit machine, so anything with an x64 can be ignored.
2)  The previous items list special SQL services.  For example, the second one lists ReportBuilder.
3)  The 5th one just mentions SQL Server 2008 R2 and is 32-bit.

Author Comment

ID: 36714391
I actually do have x64, so then applying same logic it would be 10th one down.  Correct?

What is "ia64"?

Author Comment

ID: 36714559
It was the 10th one down.  Installed very easily.  Thanks for your help.

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Copy Database Wizard 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.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

728 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