Doing some testing with the SQL Server 2008 R2 Express with SP2. It doesn't seem to successfully upgrade a SQL Server 2008 R2 Express with RTM installation. The SQL Server 2008 R2 SP2 (sp only) does successfully upgrade the SQL Server 2008 R2
Express with RTM installation.
Is the SQL Server 2008 R2 Express with SP2 expected to be able to upgrade an existing SQL Server 2008 R2 Express with RTM?
The test environment is:
Windows XP SP3
Default SQL Server instance MSSQLSERVER
Here is the relevant snippet of the details log file where it appears to first hiccup:
2012-07-27 13:29:16 SQLEngine: --MergedDirectoryProperties: ErrorLogDirectory =
2012-07-27 13:29:16 SQLEngine: --MergedDirectoryProperties: TemplateDataDirectory = [DataRootDirectory]\Template Data
2012-07-27 13:29:16 SQLEngine: --MergedDirectoryProperties: SqlInstanceBinnDir = C:\Program Files\Microsoft SQL Server\MSSQL10_50.MS ...
Go to the complete details ...