Solved

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

Posted on 2008-10-08
5
1,418 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
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Rowley
Comment Utility
0
 

Author Comment

by:williamvail
Comment Utility
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
Comment Utility
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
Comment Utility
None apart from upgrading or getting hold of some software to help...sorry.
0
 

Accepted Solution

by:
williamvail earned 0 total points
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Outsource Your Fax Infrastructure to the Cloud (And come out looking like an IT Hero!) Relative to the many demands on today’s IT teams, spending capital, time and resources to maintain physical fax servers and infrastructure is not a high priority.
David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now