Solved

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

Posted on 2008-10-08
5
1,429 Views
Last Modified: 2012-05-05
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!!
0
Comment
Question by:williamvail
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Rowley
ID: 22668236
0
 

Author Comment

by:williamvail
ID: 22669138
I have followed your link, and the person asking the question has a very similar problem. However, rebuildm.exe is not installed in sbs2003. Ive tried downloading the various .dll's for the program but to no avail...Any ideas??


Cheers
0
 

Author Comment

by:williamvail
ID: 22669532
Ok, ive done a little more research. Turns out sbs2003 doesnt use rebuildm.exe anymore, it can repair the database files using the setup provided on the cd's. However, i am unsure on how to go about doing this. I found a link to some possible useful information, (http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic22156.aspx) but im unsure what to do. Do i execute that command from the cmd prompt??What is 'instancename'??


Cheers,
0
 
LVL 13

Expert Comment

by:Rowley
ID: 22669634
None apart from upgrading or getting hold of some software to help...sorry.
0
 

Accepted Solution

by:
williamvail earned 0 total points
ID: 22677580
Ok, I have researched this further. Im going to have to manually back up the active directory before reinstalling all of SBS 2003 on the corrupt machine. Thanks for your feedback.

~Andy
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Server 2016 installation on Dell r720 12 119
S1200BTL GPUs 2 83
Monitoring solutions 8 110
Problem to Citrix 2 74
Quality of Service (QoS) options are nearly endless when it comes to networks today. This article is merely one example of how it can be handled in a hub-n-spoke design using a 3-tier configuration.
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question