June 13, 2012 at 12:29 pm
Hello,
I am running SQL2k8 R2, non clustered. I have just updated the instances with SP1 and all but one of the instances had started. I had the following error..
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.”
Another error states that the master database needs restoring from backup, but other sites say this is misleading. I have followed some advice that says that starting the server in single user mode will allow the process to finish, and I should be able to start the service up without problem. I am in single user mode now, and when first started the in single user mode, alot ran through the cmd windows, I see an entry in there that states...
execution of UPGRADE_UCP_CMDW_DISCOVERY.SQL completed
and the next said recovery complete.
Since then I notice that the user that runs the RS service was trying to log in, but of course could not, so I stopped the RS service to prevent that. Now the command window is just there with a blinking cursor. I cant type anything into it, so now I do not know which way to go. Could someone please help me?
Regards,
D.
June 13, 2012 at 12:46 pm
I'm not personally feeling all that able to help you on this one, but I've nudged a few of the other long time posters here and hopefully one of them will be able to get with you in the near future. Just didn't want you to be left hanging with silence.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 13, 2012 at 12:50 pm
The window where you started SQL Server is just running SQL and outputting messages, nothing more. If you want to connect to it and run queries you need to open another command window and run SQLCMD, connect to the SQL Server and run queries from there.
What else did the error log (or the service pack install logs) say about the failure? There should be more detail than just that message.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 13, 2012 at 12:51 pm
Thanks, I'm hanging in here, basically I am in single user mode in the command window, which has not prompt so I cant even type anything, I cant start the engine in services either ( I didnt think I would).
The command window is reprting that the backups are failing because its in single user mode, its like its just telling me why things are not going to work. I need to get out of this and see if I can get the instance to start in multi user and get back to normal (hopefully).
Regards,
D
June 13, 2012 at 12:52 pm
Hello Gail,
I was writing the other post during your answer, I'll just go to the logs and see if I can get more detail.
Regards,
D.
June 13, 2012 at 12:58 pm
If all you want to do is kill the single user mode and restart the service normally then just Ctrl-C in the SQL window, then go to services (or SQL Service manager) and start the service. Whether it will start correctly is another matter though...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 13, 2012 at 12:59 pm
Gail,
Thank you for getting back, the tail end of the log only seems to give what I had wrote above.
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.”
It seems to have gone fine apart from the last bit. I can see in the application log on the server that all the databases system and user all passed the DBCC without errors.
I will open another command window, I am not sure what to type in, should I type the command to bring it out of single user mode?
Regards,
D.
June 13, 2012 at 1:10 pm
Gail,
Even though I started the server in single user mode via the cammand window, can I start it up in multi user mode using the configuration manager? I cannot find the command to use to switch back to multi-user mode.
Regards,
D.
June 13, 2012 at 1:16 pm
Kill the single-user mode in the command window (Ctrl-C), then start the service. Unless you messed with the service startup parameters is will come up as it always does.
There's no command to bring SQL out of single user mode. It's in single user mode because you specified the -m switch when you started it in the command window and that parameter only applies to that specific execution of the SQLServr.exe executable.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 13, 2012 at 1:19 pm
Ok, I hit control C and I am asked if I want to shut down SQL server, presumably I will answer yes, and (hopefully) restart the service? No, I didnt mess around with the start up parameters. Please excuse me, this is a first for me.
Regards,
D.
June 13, 2012 at 1:23 pm
Yes and yes. If it doesn't start find the error log and look at what it says.
Btw, are you willing to open a support case with MS if the service won't restart?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 13, 2012 at 1:28 pm
Hi Gail,
It does appear to have started, but in answer to your question, it would have been a yes. Thank you so much for your help, you are totally awsome as always.
Kind regards,
D.
June 13, 2012 at 1:30 pm
CheckDB all databases (especially master), if clean take backups of all system databases (other than TempDB). You don't want to have to go through this again...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 13 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply