Mdf file sql server 2008

[harleybooth]

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,

[agentfazexx]

I think you'd be better off with Microsoft Premier support or on the Technet forums.

[Proclivitas]

I would think your DBA would be able to roll the update back.

[agentfazexx]

[QUOTE=Proclivitas;49275456]I would think your DBA would be able to roll the update back.[/QUOTE]

Big question is why is a network admin installing SQL shit?

[Proclivitas]

[QUOTE=agentfazexx;49275663]Big question is why is a network admin installing SQL shit?[/QUOTE]

Probably did an automatic windows update. Probably should fire that guy.

[agentfazexx]

[QUOTE=Proclivitas;49278123]Probably did an automatic windows update. Probably should fire that guy.[/QUOTE]

Yup. I manage our WSUS for our enterprise. Never do I ever install the DBA's patches.

[larrywalls]

Some useful links from Internet space:
[url]https://sql.recoverytoolbox.com/[/url] Recovery Toolbox for SQL Server - in case any solution cant assist you, you make use of this tool

There is a manual solution to fix this problem, but you need to have Microsoft SQL Server Management Studio for that. If you have it, you need to follow the steps given below:

Open Microsoft SQL Server Management Studio on your system.
Now click on New Query button.
A new query page will be opened. Write the SQL scripts (shown below) on the page:

EXEC sp_resetstatus [YourDatabase];
ALTER DATABASE [YourDatabase] SET EMERGENCY
DBCC checkdb ([YourDatabase])
ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC DATABASE ([YourDatabase], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [YourDatabase] SET MULTI_USER

Now click on Execute.

Now you can see the file is not tagged as Suspect.