Download SQL Server 2008 Full Mediafire link

Key Features Offered By SQL Server 2008 R2 SP2 Express:

Supports stored procedures, triggers, functions, and views
Store all kinds of business data with native support for relational data, XML, FILESTREAM and spatial data
Improved performance, usability, visualization, in addition to integration with the Microsoft 2007 Office System in SQL Server Reporting Services
Simplify development efforts by leveraging existing T-SQL skills, ADO.NET Entity Framework and LINQ
Closely integrated with Visual Studio and Visual Web Developer

SQL Server 2008 R2 SP2 Express Editions:

SQL Server 2008 R2 Express with Tools

Core edition of Express that supports development. Includes SQL Server 2008 Database Engine and SQL Server Management Studio Express

SQL Server 2008 R2 Express with Advanced Services

Extends SQL Server 2008 Express with tools to include support for Integrated Full-text Search and Reporting Services

SQL Server 2008 R2 Express (Runtime Only)

Includes the SQL Database Engine only and is designed for deployments and ISV redistribution

SQL Server 2008 R2 SP2 Management Studio Express

Free, easy-to-use graphical management tool for configuring, managing, and administering SQL Server 2008 R2 SP2 Express. It can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2008 R2 SP2.

Customers looking to download SQL Server Express and SQL Server Management Studio Express for the first time, please download the bundle: SQL Server 2008 Express with Tools.

KB article 2630458 provides additional information about key fixes in SQL Server 2008 R2 SP2 for all SQL Server Editions. To learn more about SQL Server 2008 R2 SP2 please review SQL Server 2008 R2 SP2 Release Notes.