Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-08
5
Medium Priority
?
1,436 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

Looking for the Wi-Fi vendor that's right for you?

We know how difficult it can be to evaluate Wi-Fi vendors, so we created this helpful Wi-Fi Buyer's Guide to help you find the Wi-Fi vendor that's right for your business! Download the guide and get started on our checklist today!

Question has a verified solution.

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

Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
An article on effective troubleshooting
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

715 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