Installing SQL Server 2008 service pack 1 on SQL Server Express 2008 (with Advanced Services)

Notice:

The recently released Service Pack 1 of Microsoft SQL Server 2008 can be consumed to upgrade existing instances of the product in all of it's flavours and editions.

We are here documenting our experience upgrading an existing SQLExpress 2008 with Advanced Services RTM instance to the service pack 1 level, already installed including Reporting Services, FullText search feature, SQL Server Replication and, obviously, the shared tools like SQL Server Management Studio (Basic) and Business Intelligence Development Studio.

Current goals:

Service Pack 1 release notes do not indicate Windows XP sp2 as a supported operating system version, but the successive checks do not claim about it

In this case we indicated to udate the whole installed instance

Running the SQLServer2008SP1-KB968369-x86-ENU.exe executable, the user is engaged with the traditional SQL Server 2008 Setup experience.

Soon after accepting the SQL Server 2008 service pack 1 licence terms, the user is required to specify the feature(s) to update

In this case we indicated to udate the whole installed instance

A sytem check for files in use is performed in order to verify the update can be executed.

When ready to upgrade, a summary i rendered to aknoledge the running action

We are finally ready to start and the Update Progress dialog informs the user about the current action progress

A nasty thing the upgrade install did not report was our Virtual Machine would run out of disk space and the installation was partially rolled back.
We actually expected this space violation would have been reported at the very first system check, but this was not the case.
After cleaning up the machine removing all the possibile unused bits (and perhaps some required as well) we re-executed the service pack installation, and to our surprise, it just started where it previously interrupted without apparent problems, reporting us with a friendly Compleated updating 'SQLExpress' message

SQL Server Configuration Manager does not provide any info about the patching action, as expected

but accessing SQL Server Management Studio does, indicating our instance has been updated to 10.0.2531 build from the original (RTM) 10.0.1600 build, and so does the tool itselft, updated to 10.0.2531.0 build from the original (RTM) 10.0.1600.22 ((SQL_PreRelease).080709-1414 ) indications.

Running a few SERVERPROPERTY statement we can further investigate the instance state, such as:

SELECT SERVERPROPERTY('Edition') AS [SERVERPROPERTY('Edition')];
SELECT SERVERPROPERTY('ProductVersion') AS [SERVERPROPERTY('ProductVersion')];
SELECT SERVERPROPERTY('ProductLevel') AS [SERVERPROPERTY('ProductLevel')];
SELECT SERVERPROPERTY('ResourceLastUpdateDateTime') AS [SERVERPROPERTY('ResourceLastUpdateDateTime')];
SELECT SERVERPROPERTY('ResourceVersion') AS [SERVERPROPERTY('ResourceVersion')];
--<------------
SERVERPROPERTY('Edition')
---------------------------------------
Express Edition with Advanced Services

SERVERPROPERTY('ProductVersion')
---------------------------------------
10.0.2531.0

SERVERPROPERTY('ProductLevel')
---------------------------------------
SP1

SERVERPROPERTY('ResourceLastUpdateDateTime')
---------------------------------------
2009-03-29 12:30:27.077

SERVERPROPERTY('ResourceVersion')
---------------------------------------
10.00.2531    
    

and so does Business Intelligence Development Studio info in Visual Studio IDE show the upgrade was succesful as well