none
Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 226, state 6, severity 16.

    Question

  • Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 226, state 6, 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.

    Michael Sun [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, November 10, 2016 3:10 AM

All replies

  • Hi Michael Sun,

    Based on your description, I would assume you are facing this issue during SQL Server upgrade/patching. In this case, it seems your current master database is damaged so you may need to manually rebuild your master database(to bring SQL Server online) by following the instructions here and restore master database from the last- known-good backup. Note that the rebuild process would erase everything from master database so make sure you took a backup first.

    To find out the cause of issue, I would suggest you upload your SQL Server installation log files to a file share service(such as OneDrive) and share the link here so we can have a better understanding about the issue. I would  appreciate that if you could also provide other information such as SQL Server version/edition/patch level and OS version/edition/patch level.

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Friday, November 11, 2016 5:26 AM
    Moderator