Solved

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

Posted on 2008-10-08
5
1,422 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
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Exchange 2010 smtp and senderbase ratings 3 62
backup computers on Workgroup 10 61
NAS with google authentication 6 100
Cannot Change Local DNS 9 44
How to set-up an On Demand, IPSec, Site to SIte, VPN from a Draytek Vigor Router to a Cyberoam UTM Appliance. A concise guide to the settings required on both devices
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
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.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

777 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