Solved

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

Posted on 2011-09-27
5
492 Views
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
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2567713&kbln=en-us

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 2008 R2
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

0
Comment
Question by:bleonardi
[X]
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
5 Comments
 
LVL 2

Expert Comment

by:bkieler
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.

0
 

Author Comment

by:bleonardi
ID: 36714281
screenshot attached


screenshot.JPG
0
 
LVL 2

Accepted Solution

by:
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.
0
 

Author Comment

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

What is "ia64"?
0
 

Author Comment

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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

696 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