Question

SQL Server服务启动后自动停止了，并没有报错，查看日志后以下内容，请问该如何恢复

2018-03-26 09:12:46.24 登录 错误: 17187，严重性: 16，状态: 1。2018-03-26 09:12:46.24 登录 SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [客户端: 169.254.41.112]2018-03-26 09:18:41.31 登录 错误: 18401，严重性: 14，状态: 1。2018-03-26 09:18:41.31 登录 Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [客户端: ::1]2018-03-26 09:18:42.77 spid7s 错误: 15002，严重性: 16，状态: 1。2018-03-26 09:18:42.77 spid7s 无法在事务中执行过程 'sys.sp_dbcmptlevel'。2018-03-26 09:18:42.83 spid7s 错误: 574，严重性: 16，状态: 0。2018-03-26 09:18:42.83 spid7s 在用户事务内不能使用 CONFIG 语句。2018-03-26 09:18:42.83 spid7s 错误: 912，严重性: 21，状态: 2。2018-03-26 09:18:42.83 spid7s Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 574, state 0, severity 16. 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.2018-03-26 09:18:42.84 spid7s 错误: 3417，严重性: 21，状态: 3。2018-03-26 09:18:42.84 spid7s 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.





Answer 1

SQL升级失败，重新升级一下试试

追问

请问要如何手动升级？