?
Solved

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

Posted on 2011-09-27
5
Medium Priority
?
523 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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

752 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