?
Solved

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

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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Loops Section Overview
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

839 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