Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

mssqlsystemresource.mdf file is missing


  • Please log in to reply
2 replies to this topic

#1 calebclark

calebclark

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:10:58 PM

Posted 27 May 2015 - 08:14 AM

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,



BC AdBot (Login to Remove)

 


#2 caelholden

caelholden

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:10:58 PM

Posted 27 May 2015 - 02:44 PM

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.

 

Some useful links from Internet space:

http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1462-sql-server-2005-database-lost - great solutions and a lot of users who can share their knowledge about sql databases

https://sql.recoverytoolbox.com/ Recovery Toolbox for SQL Server - in case any solution cant assist you, you make use of this tool

http://forums.techguy.org/windows-xp/1137458-creating-new-database-using-mdf.html#post8996088



#3 malynensi

malynensi

  • Members
  • 145 posts
  • OFFLINE
  •  
  • Local time:08:58 PM

Posted 28 May 2015 - 07:31 AM

can you post useful links to learn mysql? thanks






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users