Might have to chalk that one up to the SQL gremlins, unless someone else has any ideas

That is totally random.

And nothing in the .2 log that indicates anything I expect.

Nothing in the SQL logs either?

There should be a bootstrap log for the SP2 installation. There's no benefit in separating the master data and log files.

Why were you installing across the network? You really should...

If you run a select for that name against

select * From msdb.dbo.sysjobs_view do you get results?

Anything in the SQLAGENT.1 log?

Are there any stack dumps sitting in the same folder?

Take a look through those would be your best bet.

2008-12-29 09:58:43.07 spid4s Starting up database 'mssqlsystemresource'.

Check that the files for mssqlsystemresource are in the same folder as the master database and check the install...

Glad it worked. 🙂

From the logs that you've attached it looks like there is an error when trying to patch Full Text Indexing.

Here is the relevant portion of the log:

MSI (s) (B4:CC) [09:29:53:656]:...

Look at this thread, it's regarding a prior issue very similar to the one that you are having

http://www.sqlservercentral.com/Forums/Topic531767-149-2.aspx

What entries are in the bootstrap log?

If you are renaming the SQL Server you should also rename the physical server so as not to confuse things greatly.

The physical layer is what allows the user to connect...

Have you tried

INSERT INTO [newdb].dbo.[ta_news]

SELECT [ID], [Content] FROM [olddb].dbo.[ta_news] WHERE [Id] = 100000000795

Wish some kind of fix was in he offing.

Please post whatever you do to get a final resolution for the problem.

Just be careful with the tool, it can do bad things.

One final thing, download the installer cleanup util and remove anything sql

http://support.microsoft.com/kb/q290301/%5B/url%5D

Having a ctp on there and it not having cleaned up properly could well be the issue.

Are there any files or folders left in the program files\microsoft sql\ server folder?

Is this a named instance?

Does the following exist in the registry?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL

Server\