huy1002 (7/18/2011)
today i have a disk failure on my SQL Server 2000. even though i have built the drive, but i cannot get the server to start still.I get an error starting the service MSSQL$EVENTMASTER_DB Service
"Could not start the MSSQL$EVENTMASTER_DB Service on local computer.
Error 1067. The program terminated unexpectedly."
The second service is SQLAgent$EVENTMASTER_DB
Error 1068 The dependency service or group failed to start.
The first one needs to start before the second one.
I tried to run SQlServerAgent -v
You can't get the agent on the instance to run until the instance is up. To that point, the logs you provided have just enough. Btw, I simply plugged the error into google to bring up the issue.
2011-07-15 16:33:10.17 spid4 Starting up database 'master'.
2011-07-15 16:33:10.18 spid4 Error: 823, Severity: 24, State: 6.
It can't access the drive, it's an I/O error. You'll need to confirm that the drives are behaving themselves. If they are, you've corrupted the master database. It's going to need a restore. This is severe. If you have a more experienced DBA on staff they need to get involved.
This seems to be a good discussion on the issue and a walkthrough of the repairs if you're on your own:
http://www.julian-kuiters.id.au/article.php/sql2000-rebuild-restore-master-db
EDIT: One other question... why did you post this in the MySQL forum?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA