mssqlsystemresource.mdf file is missing

[calebclark]

Our network admin applied a service pack for SQL Server 2008 on the db server.
Now the SQL server main service and agent service will not start. Looked at the log file which indicates that mssqlsystemresource.mdf file cannot be opened. I went and looked in the BINN folder and sure enough it's not there.

How do I recover this?

What to do?

Thx,

 

[Ken g6]

I found this post with identical text, which contains a potential solution. But assuming this is the same person, I guess that didn't work for them?

 

[sbpromania]

We had some similar issues missing mdf files. In order to fix this did you tried the following:
* Stop all SQL services
* Copy the mssqlsystemresource.mdf from another system that has SQL installed to your location (On x64 is should be here: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data)
* Start your services

L.E: also make sure to check if mssqlsystemresource.ldf is there.