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.

已完成 已发布的 6 年前 货到付款
已完成 货到付款

We had windows server maintenance this weekend after reboot the server SQL Server could not start. What i noticed that windows update installation had failed.

In the event viewer i have found that 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.

Script level upgrade for database 'master' failed because upgrade step '[url removed, login to view]' encountered error 2627, state 1, severity 14. 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.

I never did this before. i am litterally scared of doing this. in the production environment. Databases are not many only 5/6. Please help.

微软 SQL 服务器 SQL 视窗 Server

项目ID: #16324424

关于项目

3个方案 远程项目 活跃的6 年前

授予:

WambuiEl

With an experience of running and maintaining database servers that are SQL,mysql and postgres and with top notch problem solving skills, i believe i got the right expertise for the task. Feel free to reach out to fu 更多

$30 USD 在1天内
(1条评论)
1.0

有3名威客正在参与此工作的竞标,均价$30/小时

franksanchez91

hello, I'm a database administrator with 8 years of experience if you want I can try to help you with this, if I resolve it, you pay me, Regards.

$35USD 在1天里
(1条评论)
1.3