Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1442
  • Last Modified:

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!!
0
williamvail
Asked:
williamvail
  • 3
  • 2
1 Solution
 
williamvailAuthor Commented:
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
 
williamvailAuthor Commented:
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
 
RowleyCommented:
None apart from upgrading or getting hold of some software to help...sorry.
0
 
williamvailAuthor Commented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now