MSSQLSERVER_3417
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 3417 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | REC_BADMASTER |
| Message Text | 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. |
Explanation
SQL Server can't start the master database. If the master or tempdb databases can't be brought online, SQL Server can't run. This error is typically preceded by other errors. Review error logs for those errors to find the root cause.
This error may be encountered during an upgrade of SQL Server to a Cumulative Update or Service Pack. The upgrade scripts may fail due to an underlying issue and may cause the master database to not recover. Again the underlying cause is to be found in the latest SQL Server error log prior to this message.
User Action
- Restore backup of the master database. Or rebuild the system databases followed by attaching or restoring the remaining databases (
msdb, user databases,SSISDB, etc.) - If you see this error during an upgrade failure, refer to Troubleshoot common SQL Server Cumulative Update installation issues and error 912 - MSSQLSERVER_912.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for