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 !!

Answer 1

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.

Answer 2

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.

Answer 3

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.

Answer 4

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 

Answer 5

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.