SQL Server is shutting down

Question

Viewing post 31 (of 30 total)

You must be logged in to reply to this topic. Login to reply

Krasavita SSC-Insane Points: 23138 More actions · Answer 1

I don't see process id 2096 and is sql agent and sql server needs to be running under the same accounts?

Also, there is no opt file between 2/7 1300 and 2/8 956

This is what I have before 956 opt file:

2011-02-07 11:59:09 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID

2011-02-07 11:59:09 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID 3704

2011-02-07 11:59:09 - ? [101] SQL Server DB1 version 8.00.2055 (0 connection limit)

2011-02-07 11:59:09 - ? [102] SQL Server ODBC driver version 3.85.1128

2011-02-07 11:59:09 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is

2011-02-07 11:59:09 - ? [310] 4 processor(s) and 2048 MB RAM detected

2011-02-07 11:59:09 - ? [339] Local computer is DB1 running Windows NT 5.0 (2195) Service Pack 4

2011-02-07 11:59:09 - ? [129] SQLSERVERAGENT starting under Windows NT service control

2011-02-07 12:00:09 - ! [264] An attempt was made to send an email when no email session has been established

2011-02-07 12:20:04 - ! [264] An attempt was made to send an email when no email session has been established

2011-02-07 12:40:12 - ! [264] An attempt was made to send an email when no email session has been established

2011-02-07 13:00:08 - ! [264] An attempt was made to send an email when no email session has been established

2011-02-07 13:00:12 - ! [298] SQLServer Error: 11, General network error. Check your network documentation. [SQLSTATE 08S01]

2011-02-07 13:00:12 - ! [298] SQLServer Error: 10054, ConnectionRead (recv()). [SQLSTATE 01000]

2011-02-07 13:00:12 - ! [382] Logon to server 'DB1' failed (ConnAttemptCachableOp)

2011-02-07 13:00:12 - ! [359] The local host server is not running

2011-02-07 13:00:13 - ! [359] The local host server is not running

2011-02-07 13:00:15 - ! [359] The local host server is not running

2011-02-07 13:00:30 - ! [359] The local host server is not running