none
CU4 installation failed on SQL server 2008R2 SP2 - SQL Server Setup has encountered the following error: The NT service 'MSSQL$SHARE' could not be stopped.

    Question

  • Hello,

    I would certainly appreciate a helping hand on this :

    Upgrading SQL2008R2SP2 from CU3 to CU4 (10.50.4266 to 10.50.4270). Setup ended with error message :

    SQL Server Setup has encountered the following error:
    The NT service 'MSSQL$SHARE' could not be stopped.
    Error code 0x84B20001.

    after host reboot SQL service didn't start :

    Log Name:      Application
    Source:        MSSQL$SHARE
    Date:          13.02.2013 17:57:02
    Event ID:      17204
    Task Category: Server
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:     

    Description:
    FCB::Open failed: Could not open file L:\MSSQL_SHARE\MSSQL10_50.SHARE\MSSQL\Binn\mssqlsystemresource.mdf for file number

    1.  OS error: 2(The system cannot find the file specified.).

    ********************

    resource db is gone !!

    Wednesday, February 13, 2013 9:12 PM

Answers

All replies

  • Would you please check-out below related threads

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/95e92910-156e-4da9-91f7-5a5e1512050d

    http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/d0dbad5e-da84-4c41-9dda-71913d9e9911


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Thursday, February 14, 2013 1:54 AM
    Moderator
  • Thanks for your answer.

    I'll try to run repair in the next maintenance window. Now I managed to start SQL service by copying mssqlsystemresource.mdf and mssqlsystemresource.ldf from an different instance from another host, though these are versions 10.50.4266 and server is now- Microsoft SQL Server 2008 R2 (SP2) - 10.50.4270.0 (X64)   Nov 30 2012 17:11:43   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) .

    I'll let you know how this will go.


    • Edited by edwag Thursday, February 14, 2013 3:25 AM
    Thursday, February 14, 2013 3:22 AM
  • Hello Edwag,

    From the error message:

    FCB::Open failed: Could not open file L:\MSSQL_SHARE\MSSQL10_50.SHARE\MSSQL\Binn\mssqlsystemresource.mdf for file number

    OS error: 2(The system cannot find the file specified.).

    Make sure that the file mssqlsystemresource.mdf file is presnt at the location mentioned above.

    Friday, February 15, 2013 11:08 AM
  • Hello Don,

    Did that, but the 2 files *.mdf and *.ldf are not to be found on host .

    I installed an Instance with the name as the broken one (CU4) and copied resource db from there. I'll watch close the system now.

    found this in:

    http://blogs.msdn.com/b/sqljourney/archive/2012/04/10/mssqlsystemresource-database-corruption-yes-it-s-possible.aspx 

    Sunday, February 17, 2013 11:45 PM
  • Hello Edwag,

    Yes, this should work. Replacing resource db files from the working machine (make sure that they are on the same build) should work.

    Monday, February 18, 2013 9:03 AM