Solved

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

Posted on 2011-09-27
5
482 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 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

773 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