(ka*****@gmail.com) writes:
This is the log file for my SP1 on 2005 install. Can anyone please
look at this and tell me if this looks normal?
I'm concerned about the following in the log:
"Failed to read registry key: Debug"
This one may be innocent. My speculation is that it's looking for for this
registry key, which if present will alter the execution path, presumably
to enable some debugging.
AND
all the entries that show "- Not Applied"
I would interpret that as the service pack was not applied for anything
but SQL Native Client.
According to SELECT SERVERPROPERTY('ProductLevel') my service pack is
"SP1", so everything appears "normal".
What does does SELECT @@version say?
If you look at
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe
(or corresponding), what size and date information do you see?
However, I had to apply the service pack a couple times because the
first try gave "locked files" error. I did not reboot after the
initial SQL Server 2005 installation, which I think may have caused a
problem, but I don't know. I reapplied the SP1 two more times after
the reboot. This is the log file from the third try (the second log
file looked identical).
Obviously it's not applying SP1, if you are already there. Then again
it says:
02/23/2007 14:51:57.574 Product: Database Services
02/23/2007 14:51:57.590 Database Services (RTM 1399 ENU) -
Which seems that you had the RTM version and not SP1.
Anyway, SP2 two is out, so the easy way out, may be to download and
install SP2.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx 
