October 16, 2009 at 8:29 am
We have two different servers that we're trying to get SP1 installed on. One is a virtual, the other a physical server. Both are experiencing some odd behavior. I'm working with one of our system DBA's on this issue. Here's his input:
We ran the SQLServer2008SP1-KB968369-x64-ENU.exe (which we have run several times without any issues prior). After the install it says it completed successfully and that a reboot is needed. After the reboot SQL will not come back up and the attached errors are in the application log on the server the other log is from SQL. The patch uninstalls (thank God) and SQL comes back up and is fine. We cannot get this installed on STG or PRD, both give the same errors on all instances that we try to patch.
I've attached the output and a log from the errors. We did not change the 'sa' login.
Anyone have any idea what's up?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 19, 2009 at 1:41 pm
I had the same issue on one of my VM's i was testing 08 on awhile back, you should be able to run Repair feature of setup through the SQL Server Installation Center
October 20, 2009 at 6:24 am
Thanks. We'll try that too.
For some reason when we turned implicit transactions off, we were able to get the install to run. I'm still trying to find out why one of our admin guys thought of that. It worked on the virtual. Next up is the physical box. We're working on scheduling down time for that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply