July 26, 2010 at 1:30 pm
I have a database server running Server 2008 R2 x64, with SQL Server 2008 SP1 (build 10.0.2531). We have not applied any updates since SP1 and need to get the SQL build up to 10.00.2775 (using Cumulative Update 8 for Sql Server 2008 SP1 - http://support.microsoft.com/kb/981702). I have tried installing the update several times, and each time it fails with a vague error. (About to retry the install and comment with the exact error.) Any ideas? I've never had a problem installing a service pack or CU before and I am not sure what to do!? I will keep digging, but was hoping that maybe someone else had run into this same problem and already knows what to do about it...
July 26, 2010 at 1:34 pm
I don't apply CU's unless I have a problem that is corrected by the CU.
Now, that that is out of the way, until you post the error message(s) you are getting, not sure if there is much we can do to help.
July 26, 2010 at 1:42 pm
Thanks, Lynn. There was some debate about exactly that (i.e. whether we should apply the CUs or wait until SP2), but in this case, we do feel that the CU will fix a bug that we cannot tolerate in the production environment.
As to the error message, I'm waiting on the server to open up (someone else is using it right now), then I'll retry the install and provide the exact text and error codes.
Thanks for your fast reply!
-Austin
August 4, 2010 at 3:11 pm
Sorry it's taken me so long to get back to this thread... Here is the exact failure text, though.
After install, installer says that CU8 completed successfully and that I need to reboot. However... Windows Event Viewer shows two errors as a result of the installation attempt.
Log Name: Application
Source MSSQLServer
EventID: 912
Level: Error
User: N/A
General:
Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 598, state 1, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
Log Name: Application
Source MSSQLServer
EventID: 3417
Level: Error
User: N/A
General:
Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
In my experience, the server is screwed at this point. We've been trying these install attempts on a copy of our dev server, so we haven't felt the need to go as far as to attempt to repair or fix master (it's a VM with snapshots that allow us to roll everything back to a point in time before the install attempt)... we feel like we should never even encounter this problem, so no sense in trying to fix the aftermath of it.
However, we have tried taking the same VM, uninstalling SQL Server 2008 and then reinstalling SQL Server 2008 again with the standard/default options . This works, which indicates that the install is failing because of some option we turned on, location we placed files, etc. ? Any ideas where to go from here?
August 5, 2010 at 11:45 am
Maybe this will help: http://datazulu.com/blog/post/Sql2008-R2-Upgrade-Fail.aspx
Also, have seen problems when a trial version of SSIS was installed and had expired. In this case, uninstall SSIS to fix.
Shaun
August 24, 2010 at 6:22 pm
During upgrade, sqlagent100_msdb_upgrade.sql tries to create a database. If the default data folder does not exist, the operation will fail. The same failure can be seen when trying to create a DB from SSMS.
Go to SSMS -> right click on server in object explorer -> properties -> Database Settings -> Database Default Locations and make sure the path points to an existing folder and the Sql engine account has access to it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply