Link to home
Start Free TrialLog in
Avatar of LJG
LJG

asked on

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

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

site: http://www.microsoft.com/en-us/download/details.aspx?id=30438

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.
LJG
Avatar of Aneesh
Aneesh
Flag of Canada image

SQLEXPRWT (With Tools) has Management Studio Added,
SQLEXPRADV (Advanced Services) has Reporting Services Included as well.
get the SQLEXPRADV_x64_ENU.exe  - it includes management studio
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LJG
LJG

ASKER

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.

https://www.experts-exchange.com/questions/27841363/ssms-Drag-and-Drop.html