• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

mssqlsystemresource.mdf file is missing

C

calebclark

Junior Member
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,
 
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?
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top