What file(s) do I need - SP2 for SQL Server 2008 R2 - Express Edition

Posted on 2012-08-28
Last Modified: 2012-08-29
I'm confused what file(s) I need to upgrade 2008 R2  Express Edition to SP2.  On the following site it shows 4 possible files.  I 'm currently running version 10.50.25 and having a couple of things that are giving me problems and would like to update to SP2


Files I might need to download
SQLEXPR_x64_ENU.exe                    122.4 MB      
SQLEXPRADV_x64_ENU.exe         1,008.6 MB      
SQLEXPRWT_x64_ENU.exe         340.5 MB      
SQLManagementStudio_x64_ENU.exe      161.0 MB

What I know
64 = 64 bit operating system (I'm on Windows 7)
ENU = English

Any help would be greatly appreciated.
Question by:LJG
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    SQLEXPRWT (With Tools) has Management Studio Added,
    SQLEXPRADV (Advanced Services) has Reporting Services Included as well.
    LVL 1

    Expert Comment

    get the SQLEXPRADV_x64_ENU.exe  - it includes management studio
    LVL 75

    Accepted Solution

    None of the above.  In order to apply Service Pack 2 you need the file SQLServer2008R2SP2-KB2630458-x64-ENU.exe that you can download here:
    LVL 2

    Author Closing Comment

    AcPerkins - Thanks so much for the link.  People like you make my life easier.

    Jut two things for anyone reading this.
    1) Service packs should not be so hard to locate.
    2) Upgrading to SP2 for 2008 R2 didn't solve my problem of dragging & Dropping talked about in the following question.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
    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…
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

    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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now