Microsoft SQL Server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server and other platforms » MySQL » Microsoft SQL Server 2000

Microsoft SQL Server 2000

Rate Topic

Display Mode

Topic Options

Author

Message

huy1002

Posted Monday, July 18, 2011 3:33 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 11:39 AM
Points: 17, Visits: 46

Can anyone help me with this issue:

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

Here are some logs

2011-07-18 13:45:00 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID
2011-07-18 13:45:00 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID 152
2011-07-18 13:45:00 - ? [101] SQL Server ABCDE version 8.00.2039 (0 connection limit)
2011-07-18 13:45:00 - ? [102] SQL Server ODBC driver version 3.86.3959
2011-07-18 13:45:00 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is
2011-07-18 13:45:00 - ? [310] 2 processor(s) and 2048 MB RAM detected
2011-07-18 13:45:00 - ? [339] Local computer is ABCDE running Windows NT 5.2 (3790) Service Pack 2
2011-07-18 13:45:01 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2011-07-18 13:45:01 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2011-07-18 13:45:01 - + [260] Unable to start mail session (reason: No mail profile defined)
2011-07-18 13:45:01 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect

2011-07-15 16:33:09.67 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$EVENTMASTER_DB\LOG\ERRORLOG'.
2011-07-15 16:33:09.68 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2011-07-15 16:33:10.12 server SQL Server configured for thread mode processing.
2011-07-15 16:33:10.12 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
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.
2011-07-15 16:33:10.20 spid4 07/15/11 16:33:10 Stack Overflow Dump not possible - Exception c00000fd E at 0x004436DD
2011-07-15 16:33:10.20 spid4 Address=4436dd Exception Code = c00000fd
2011-07-15 16:33:10.20 spid4 eax=000f3350 ebx=00000000 ecx=19f42b40 edx=00000000
2011-07-15 16:33:10.20 spid4 esi=00000000 edi=00000001 eip=004436dd esp=02d72c20
2011-07-15 16:33:10.20 spid4 ebp=02d731bc efl=00010202
2011-07-15 16:33:10.20 spid4 cs=1b ss=23 ds=23 es=23 fs=3b gs=0
2011-07-15 16:33:10.20 spid4 1: Return Address 004436DD
2011-07-15 16:33:10.20 spid4 2: Return Address 0044358B
2011-07-15 16:33:10.20 spid4 3: Return Address 00443B16
2011-07-15 16:33:10.20 spid4 4: Return Address 00443A1C
2011-07-15 16:33:10.20 spid4 5: Return Address 0040509B
2011-07-15 16:33:10.20 spid4 6: Return Address 004F7216
2011-07-15 16:33:10.20 spid4 7: Return Address 004050F7
2011-07-15 16:33:10.20 spid4 8: Return Address 00409AA0
2011-07-15 16:33:10.20 spid4 9: Return Address 00409F95
2011-07-15 16:33:10.20 spid4 10: Return Address 00409C49
2011-07-15 16:33:10.20 spid4 11: Return Address 00483DB0
2011-07-15 16:33:10.20 spid4 12: Return Address 00829D14
2011-07-15 16:33:10.20 spid4 13: Return Address 00443B16
2011-07-15 16:33:10.20 spid4 14: Return Address 00443A1C
2011-07-15 16:33:10.20 spid4 15: Return Address 0040509B
2011-07-15 16:33:10.20 spid4 16: Return Address 004F7216
2011-07-15 16:33:10.20 spid4 17: Return Address 004050F7
2011-07-15 16:33:10.20 spid4 18: Return Address 00409AA0
2011-07-15 16:33:10.20 spid4 19: Return Address 00409F95
2011-07-15 16:33:10.20 spid4 20: Return Address 00409C49
2011-07-15 16:33:10.20 spid4
2011-07-15 16:33:10.20 spid4 TotalPhysicalMemory = 3958771712, AvailablePhysicalMemory = 3300696064
2011-07-15 16:33:10.20 spid4 AvailableVirtualMemory = 386457600, AvailablePagingFile = 7153762304

Post #1143769

Evil Kraig F

Posted Monday, July 18, 2011 3:42 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:09 PM
Points: 5,658, Visits: 6,100

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?

- Craig Farrell

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1143777

matthew.lowe 19651

Posted Tuesday, July 19, 2011 3:56 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, March 19, 2012 11:20 AM
Points: 264, Visits: 67

O dear

http://support.microsoft.com/kb/828339

Post #1143953

« Prev Topic | Next Topic »

Permissions