Skip to Content
author's profile photo Former Member
Former Member

SQLAgent$SBSMonitoring service not running, corrupt master.mdf file.

Hi, is everyone ok??

Well, basically i over-look the operation of several servers for various companies. One of the servers however will not send me reports. Ive checked the problem out and it appears that the SQLAgent$SBSMonitoring service is not running. When i open services.msc and try to start it, it comes up with the formentioned error. (Error 1068: The dependency service or group failed to start) Ive checked this out further and i believe that the master.mdf file is corrupt. As, the server is a new setup carried out by a colleague, no backups were created. Are they any suggestions for repairing the service?? We do not have any SQL repair software at hand.....

Cheers for the feedback, it is greatly appreciated!!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2015 at 04:05 PM

    When you can’t restore .sql data via standard solutions make use of guide below or if even the guide can’t help you, it might be that your sql data was severely corrupted and you may get more powerful tips on next sources Recovery Toolbox for SQL Server

    Restore With Graphical Interface

    Step 1

    Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box.

    Step 2

    Click the “Add” button to open the Locate Database Files dialog box.

    Step 3

    Type in the full name of the .MDF file, including the full device and directory path, as the following example illustrates:
    c:\data files\my_data.mdf
    Click the "OK" button. SQL Server Management Studio loads the database from the .MDF file.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 19, 2015 at 04:18 PM

    Hi Aaron,

    Usually when dealing with database corruptions in SQL Server, Microsoft is the best resource to find out options and solutions.

    You have here Mark Weber's blog at MSDN:

    And this blog post might give you some sort of help: The Easiest Way To Rebuild The master Database - Fort SQL - Site Home - TechNet Blogs

    And this blog post at SAP on Microsoft Platform in MSDN: Corruption Handling in SAP Databases - Running SAP Applications on Microsoft Platform - Site Home - MSDN Blogs

    Best Regards,

    Luis Darui

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.