Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL SERVICE TERMINATED UNEXPECTEDLY

Author  Topic 

srivenbulusu
Starting Member

6 Posts

Posted - 2010-09-30 : 02:27:05
Hi,

All of a sudden sql service got terminated on one of the server. Following is the error.

We dont have any warning messages also before this.

Please suggest. server version is

Microsoft SQL Server 2005 - 9.00.4273.00 (Intel X86) Dec 3 2009 10:31:35 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Date: 9/29/2010
Source: MSSQLSERVER
Time: 5:42:12 PM
Category: [2]
Type: Error
Event Id: 19019
User: N/A
Computer: XXXX

The MSSQLSERVER service terminated unexpectedly.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Only at 5:23 the following error got occurred

Date: 9/29/2010
Source: HP Systems Insight Manager
Time: 5:23:09 PM
Category: None
Type: Error
Event Id: 3
User: N/A
Computer: XXXX

com.hp.mx.database.DbVerificationException: Error loading database verification handler 'com.hp.mx.database.MsSqlVerificationHandler'
com.hp.mx.database.DbVerificationException: Error accessing database


Regards,
Sri

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-09-30 : 03:22:56
Check the SQL error log. See if there are any odd entries at the end of the 1st archive log.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

srivenbulusu
Starting Member

6 Posts

Posted - 2010-09-30 : 03:40:00
Hi Gai Shaw,

Log is not available from 2010-09-29 17:28:06.81 to 2010-09-29 17:44:05.00

Please find the log here..

Log is not available from 2010-09-29 17:28:06.81 to 2010-09-29 17:44:05.00

Please find the log here..

ERROR LOG
------------------

2010-09-29 17:23:37.52 Server (c) 2005 Microsoft Corporation.
2010-09-29 17:23:37.52 Server All rights reserved.
2010-09-29 17:23:37.52 Server Server process ID is 10180.
2010-09-29 17:23:37.52 Server Authentication mode is MIXED.
2010-09-29 17:23:37.52 Server Logging SQL Server messages in file 'D:\Data\Data_Srv\Dbagroup\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-09-29 17:23:37.52 Server This instance of SQL Server last reported using a process ID of 2748 at 9/29/2010 5:18:24 PM (local) 9/29/2010 4:18:24 PM (UTC). This is an informational message only; no user action is required.
2010-09-29 17:23:37.52 Server Registry startup parameters:
2010-09-29 17:23:37.52 Server -d D:\Data\Data_Srv\Dbagroup\MSSQL.1\MSSQL\DATA\master.mdf
2010-09-29 17:23:37.52 Server -e D:\Data\Data_Srv\Dbagroup\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-09-29 17:23:37.52 Server -l D:\Data\Data_Srv\Dbagroup\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-09-29 17:23:37.54 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-09-29 17:23:37.54 Server Detected 2 CPUs. This is an informational message; no user action is required.
2010-09-29 17:23:37.79 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-09-29 17:23:37.91 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-09-29 17:23:40.01 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-09-29 17:23:40.03 Server Database mirroring has been enabled on this instance of SQL Server.
2010-09-29 17:23:40.04 spid5s Starting up database 'master'.
2010-09-29 17:23:40.12 spid5s 14 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2010-09-29 17:23:41.22 spid5s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2010-09-29 17:23:41.22 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-09-29 17:23:41.26 spid5s CHECKDB for database 'master' finished without errors on 2010-09-25 00:00:22.463 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:41.29 spid5s Starting up database 'mssqlsystemresource'.
2010-09-29 17:23:41.33 spid5s The resource database build version is 9.00.4273. This is an informational message only. No user action is required.
2010-09-29 17:23:41.49 spid8s Starting up database 'model'.
2010-09-29 17:23:41.49 spid5s Server name is 'XXXXX'. This is an informational message only. No user action is required.
2010-09-29 17:23:41.67 spid8s CHECKDB for database 'model' finished without errors on 2010-09-25 00:00:31.717 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:41.67 spid8s Clearing tempdb database.
2010-09-29 17:23:42.02 spid8s Starting up database 'tempdb'.
2010-09-29 17:23:42.06 spid8s CHECKDB for database 'tempdb' finished without errors on 2010-09-25 00:00:31.717 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:42.06 spid11s The Service Broker protocol transport is disabled or not configured.
2010-09-29 17:23:42.06 spid11s The Database Mirroring protocol transport is disabled or not configured.
2010-09-29 17:23:42.07 spid11s Service Broker manager has started.
2010-09-29 17:23:42.60 Server A self-generated certificate was successfully loaded for encryption.
2010-09-29 17:23:42.64 Server Server is listening on [ 'any' <ipv4> 2431].
2010-09-29 17:23:42.64 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2010-09-29 17:23:42.64 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2010-09-29 17:23:42.65 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2010-09-29 17:23:42.65 Server Dedicated admin connection support was established for listening locally on port 1434.
2010-09-29 17:23:45.76 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2010-09-29 17:23:45.77 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-09-29 17:23:45.94 spid16s Starting up database 'Bills'.
2010-09-29 17:23:45.95 spid17s Starting up database 'Checks'.
2010-09-29 17:23:45.95 spid15s Starting up database 'msdb'.
2010-09-29 17:23:45.95 spid18s Starting up database 'Faxserver'.
2010-09-29 17:23:45.96 spid19s Starting up database 'Format31'.
2010-09-29 17:23:45.96 spid20s Starting up database 'gdmgaudit'.
2010-09-29 17:23:45.97 spid21s Starting up database 'ISA'.
2010-09-29 17:23:45.98 spid22s Starting up database 'SED_ON'.
2010-09-29 17:23:46.32 spid15s 48 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2010-09-29 17:23:47.56 spid20s CHECKDB for database 'gdmgaudit' finished without errors on 2010-09-25 00:01:35.843 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:47.56 spid15s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2010-09-29 17:23:47.56 spid15s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2010-09-29 17:23:47.57 spid20s Starting up database 'SED_OFF'.
2010-09-29 17:23:48.00 spid15s CHECKDB for database 'msdb' finished without errors on 2010-09-25 00:00:34.203 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:48.01 spid15s Starting up database 'CDWINNT'.
2010-09-29 17:23:48.59 spid19s 1 transactions rolled forward in database 'Format31' (8). This is an informational message only. No user action is required.
2010-09-29 17:23:48.88 spid19s 0 transactions rolled back in database 'Format31' (8). This is an informational message only. No user action is required.
2010-09-29 17:23:48.88 spid19s Recovery is writing a checkpoint in database 'Format31' (8). This is an informational message only. No user action is required.
2010-09-29 17:23:49.11 spid19s CHECKDB for database 'Format31' finished without errors on 2010-09-25 00:01:33.333 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:49.15 spid21s 56 transactions rolled forward in database 'ISA' (10). This is an informational message only. No user action is required.
2010-09-29 17:23:49.15 spid19s Starting up database 'Insight_v50_0_74228516'.
2010-09-29 17:23:49.59 spid21s 0 transactions rolled back in database 'ISA' (10). This is an informational message only. No user action is required.
2010-09-29 17:23:49.59 spid21s Recovery is writing a checkpoint in database 'ISA' (10). This is an informational message only. No user action is required.
2010-09-29 17:23:49.78 spid21s CHECKDB for database 'ISA' finished without errors on 2010-09-25 00:01:37.747 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:50.19 spid18s 6 transactions rolled forward in database 'Faxserver' (7). This is an informational message only. No user action is required.
2010-09-29 17:23:50.36 spid18s 0 transactions rolled back in database 'Faxserver' (7). This is an informational message only. No user action is required.
2010-09-29 17:23:50.36 spid18s Recovery is writing a checkpoint in database 'Faxserver' (7). This is an informational message only. No user action is required.
2010-09-29 17:23:50.50 spid22s Analysis of database 'SED_ON' (11) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-09-29 17:23:50.62 spid18s CHECKDB for database 'Faxserver' finished without errors on 2010-09-25 00:01:30.333 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:50.81 spid20s Analysis of database 'SED_OFF' (12) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-09-29 17:23:50.99 spid17s Analysis of database 'Checks' (6) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-09-29 17:23:50.99 spid22s 17117 transactions rolled forward in database 'SED_ON' (11). This is an informational message only. No user action is required.
2010-09-29 17:23:52.18 spid22s 0 transactions rolled back in database 'SED_ON' (11). This is an informational message only. No user action is required.
2010-09-29 17:23:52.18 spid22s Recovery is writing a checkpoint in database 'SED_ON' (11). This is an informational message only. No user action is required.
2010-09-29 17:23:52.24 spid20s CHECKDB for database 'SED_OFF' finished without errors on 2010-09-25 00:01:59.630 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:52.26 spid17s 213 transactions rolled forward in database 'Checks' (6). This is an informational message only. No user action is required.
2010-09-29 17:23:52.50 spid22s CHECKDB for database 'SED_ON' finished without errors on 2010-09-25 00:01:40.200 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:52.91 spid17s 0 transactions rolled back in database 'Checks' (6). This is an informational message only. No user action is required.
2010-09-29 17:23:53.31 spid17s Recovery is writing a checkpoint in database 'Checks' (6). This is an informational message only. No user action is required.
2010-09-29 17:23:53.94 spid17s CHECKDB for database 'Checks' finished without errors on 2010-09-25 00:01:17.070 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:54.17 spid16s Analysis of database 'Bills' (5) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-09-29 17:23:54.19 spid16s 9 transactions rolled forward in database 'Bills' (5). This is an informational message only. No user action is required.
2010-09-29 17:23:54.30 spid19s 440 transactions rolled forward in database 'Insight_v50_0_74228516' (14). This is an informational message only. No user action is required.
2010-09-29 17:23:54.45 spid16s 0 transactions rolled back in database 'Bills' (5). This is an informational message only. No user action is required.
2010-09-29 17:23:54.45 spid16s Recovery is writing a checkpoint in database 'Bills' (5). This is an informational message only. No user action is required.
2010-09-29 17:23:54.51 spid19s 0 transactions rolled back in database 'Insight_v50_0_74228516' (14). This is an informational message only. No user action is required.
2010-09-29 17:23:54.51 spid19s Recovery is writing a checkpoint in database 'Insight_v50_0_74228516' (14). This is an informational message only. No user action is required.
2010-09-29 17:23:54.61 spid19s CHECKDB for database 'Insight_v50_0_74228516' finished without errors on 2010-09-25 00:02:15.497 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:54.72 spid16s CHECKDB for database 'Bills' finished without errors on 2010-09-25 00:00:37.553 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:54.84 spid15s 672 transactions rolled forward in database 'CDWINNT' (13). This is an informational message only. No user action is required.
2010-09-29 17:23:55.01 spid15s 0 transactions rolled back in database 'CDWINNT' (13). This is an informational message only. No user action is required.
2010-09-29 17:23:55.01 spid15s Recovery is writing a checkpoint in database 'CDWINNT' (13). This is an informational message only. No user action is required.
2010-09-29 17:23:55.05 spid15s CHECKDB for database 'CDWINNT' finished without errors on 2010-09-25 00:02:10.950 (local time). This is an informational message only; no user action is required.
2010-09-29 17:23:55.06 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2010-09-29 17:23:55.06 spid5s Recovery is complete. This is an informational message only. No user action is required.
2010-09-29 17:23:55.08 spid5s Launched startup procedure 'TISS_SP_Audit_Start'.
2010-09-29 17:23:55.65 spid51s SQL Trace ID 1 was started by login "sa".
2010-09-29 17:23:55.69 spid51s SQL Trace ID 2 was started by login "sa".
2010-09-29 17:23:55.72 spid51s SQL Trace ID 3 was started by login "sa".
2010-09-29 17:23:56.16 spid52 Using 'xpsqlbot.dll' version '2005.90.4035' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2010-09-29 17:23:56.35 spid51 Using 'xpstar90.dll' version '2005.90.4273' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-09-29 17:23:56.71 spid51 Using 'xplog70.dll' version '2005.90.4035' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2010-09-29 17:26:11.78 Logon Error: 18456, Severity: 14, State: 11.
2010-09-29 17:26:11.78 Logon Login failed for user 'EUR\ab46609'. [CLIENT: 169.162.60.252]
2010-09-29 17:28:06.81 spid69 Using 'ExdevCitiFileUtilsDLL.dll' version 'UNKNOWN' to execute extended stored procedure 'xp_ExdevCitiWriteDepCHQ31'. This is an informational message only; no user action is required.



2010-09-29 17:44:05.05 Server (c) 2005 Microsoft Corporation.
2010-09-29 17:44:05.05 Server All rights reserved.
2010-09-29 17:44:05.05 Server Server process ID is 10528.
2010-09-29 17:44:05.05 Server Authentication mode is MIXED.
2010-09-29 17:44:05.05 Server Logging SQL Server messages in file 'D:\Data\Data_Srv\Dbagroup\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-09-29 17:44:05.05 Server This instance of SQL Server last reported using a process ID of 10180 at 9/29/2010 5:42:00 PM (local) 9/29/2010 4:42:00 PM (UTC). This is an informational message only; no user action is required.
2010-09-29 17:44:05.05 Server Registry startup parameters:
2010-09-29 17:44:05.05 Server -d D:\Data\Data_Srv\Dbagroup\MSSQL.1\MSSQL\DATA\master.mdf
2010-09-29 17:44:05.05 Server -e D:\Data\Data_Srv\Dbagroup\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-09-29 17:44:05.05 Server -l D:\Data\Data_Srv\Dbagroup\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-09-29 17:44:05.06 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-09-29 17:44:05.06 Server Detected 2 CPUs. This is an informational message; no user action is required.
2010-09-29 17:44:05.30 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-09-29 17:44:05.36 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-09-29 17:44:07.41 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-09-29 17:44:07.41 Server Database mirroring has been enabled on this instance of SQL Server.
2010-09-29 17:44:07.42 spid4s Starting up database 'master'.
2010-09-29 17:44:07.49 spid4s 14 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2010-09-29 17:44:07.52 spid4s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2010-09-29 17:44:07.52 spid4s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-09-29 17:44:07.56 spid4s CHECKDB for database 'master' finished without errors on 2010-09-25 00:00:22.463 (local time). This is an informational message only; no user action is required.
2010-09-29 17:44:07.58 spid4s Starting up database 'mssqlsystemresource'.
2010-09-29 17:44:07.61 spid4s The resource database build version is 9.00.4273. This is an informational message only. No user action is required.
2010-09-29 17:44:07.74 spid8s Starting up database 'model'.
2010-09-29 17:44:07.74 spid4s Server name is 'XXXX'. This is an informational message only. No user action is required.
2010-09-29 17:44:07.92 spid8s CHECKDB for database 'model' finished without errors on 2010-09-25 00:00:31.717 (local time). This is an informational message only; no user action is required.
2010-09-29 17:44:07.92 spid8s Clearing tempdb database.
2010-09-29 17:44:08.26 Server A self-generated certificate was successfully loaded for encryption.
2010-09-29 17:44:08.27 Server Server is listening on [ 'any' <ipv4> 2431].
2010-09-29 17:44:08.28 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2010-09-29 17:44:08.28 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2010-09-29 17:44:08.29 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2010-09-29 17:44:08.29 Server Dedicated admin connection support was established for listening locally on port 1434.
2010-09-29 17:44:08.29 spid8s Starting up database 'tempdb'.
2010-09-29 17:44:08.33 spid8s CHECKDB for database 'tempdb' finished without errors on 2010-09-25 00:00:31.717 (local time). This is an informational message only; no user action is required.
2010-09-29 17:44:08.33 spid11s The Service Broker protocol transport is disabled or not configured.
2010-09-29 17:44:08.33 spid11s The Database Mirroring protocol transport is disabled or not configured.
2010-09-29 17:44:08.34 spid11s Service Broker manager has started.
2010-09-29 17:44:08.38 Logon Error: 17187, Severity: 16, State: 1.
2010-09-29 17:44:08.38 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 169.162.60.25]
2010-09-29 17:44:08.38 Logon Error: 17187, Severity: 16, State: 1.
2010-09-29 17:44:08.38 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 169.162.60.25]
2010-09-29 17:44:08.41 Logon Error: 17187, Severity: 16, State: 1.
2010-09-29 17:44:08.41 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: <local machine>]
2010-09-29 17:44:09.26 Logon Error: 17187, Severity: 16, State: 1.
2010-09-29 17:44:09.26 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 169.162.60.114]
2010-09-29 17:44:09.26 Logon Error: 17187, Severity: 16, State: 1.
2010-09-29 17:44:09.26 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 169.162.60.114]
2010-09-29 17:44:09.45 Logon Error: 17187, Severity: 16, State: 1.
2010-09-29 17:44:09.45 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 169.162.60.25]
2010-09-29 17:44:09.86 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2010-09-29 17:44:09.86 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.

AGENT LOG
------------------

2010-09-29 17:23:47 - ? [393] Waiting for SQL Server to recover databases...
2010-09-29 17:23:56 - ? [100] Microsoft SQLServerAgent version 9.00.4273.00 (x86 unicode retail build) : Process ID 9720
2010-09-29 17:23:56 - ? [101] SQL Server XXXX version 9.00.4273 (0 connection limit)
2010-09-29 17:23:56 - ? [102] SQL Server ODBC driver version 9.00.4035
2010-09-29 17:23:56 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
2010-09-29 17:23:56 - ? [310] 2 processor(s) and 3584 MB RAM detected
2010-09-29 17:23:56 - ? [339] Local computer is XXX running Windows NT 5.2 (3790) Service Pack 2
2010-09-29 17:23:56 - ? [432] There are 11 subsystems in the subsystems cache
2010-09-29 17:23:57 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2010-09-29 17:23:57 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2010-09-29 17:23:58 - + [260] Unable to start mail session (reason: No mail profile defined)
2010-09-29 17:23:58 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2010-09-29 17:42:12 - ! [012] The MSSQLSERVER service terminated unexpectedly
2010-09-29 17:42:12 - + [139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #1)...
2010-09-29 17:42:17 - ! [368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)
2010-09-29 17:42:22 - + [139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #2)...
2010-09-29 17:42:22 - ! [368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)
2010-09-29 17:42:27 - + [139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #3)...
2010-09-29 17:42:27 - ! [368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)
2010-09-29 17:42:27 - ! [140] AutoRestart: The MSSQLSERVER service could not be restarted after 3 attempts
2010-09-29 17:42:27 - + [360] SQLServerAgent initiating shutdown following MSSQLSERVER shutdown
2010-09-29 17:42:28 - ! [359] The local host server is not running
2010-09-29 17:42:28 - ! [359] The local host server is not running
2010-09-29 17:42:29 - ? [098] SQLServerAgent terminated (normally)


Regards,
Sri
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-09-30 : 04:21:58
Nothing in either of those (it's the error log, not agent log that's of interest). Got an earlier one? (just interested in the last few entries before the unexpected shutdown)

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Sri Pavani
Starting Member

3 Posts

Posted - 2010-10-29 : 13:53:00
Hi Sriven and everybody,

I m facing the same problem of Unexpected termination of SQL Server and need an urgent help.Can you please let me know how to solve this problem

Below is the error log
2010-10-28 11:36:58.44 Server Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

2010-10-28 11:36:58.44 Server (c) 2005 Microsoft Corporation.
2010-10-28 11:36:58.44 Server All rights reserved.
2010-10-28 11:36:58.44 Server Server process ID is 5504.
2010-10-28 11:36:58.44 Server Authentication mode is MIXED.
2010-10-28 11:36:58.44 Server Logging SQL Server messages in file 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-10-28 11:36:58.44 Server This instance of SQL Server last reported using a process ID of 2192 at 10/28/2010 11:36:22 AM (local) 10/28/2010 6:36:22 PM (UTC). This is an informational message only; no user action is required.
2010-10-28 11:36:58.44 Server Registry startup parameters:
2010-10-28 11:36:58.44 Server -d D:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-10-28 11:36:58.44 Server -e D:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-10-28 11:36:58.44 Server -l D:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-10-28 11:36:58.44 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-10-28 11:36:58.44 Server Detected 16 CPUs. This is an informational message; no user action is required.
2010-10-28 11:36:58.59 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-10-28 11:36:58.59 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2010-10-28 11:36:58.62 Server Multinode configuration: node 0: CPU mask: 0x00000000000000f0 Active CPU mask: 0x00000000000000f0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2010-10-28 11:36:58.62 Server Multinode configuration: node 1: CPU mask: 0x000000000000000f Active CPU mask: 0x000000000000000f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2010-10-28 11:36:58.62 Server Multinode configuration: node 2: CPU mask: 0x0000000000000f00 Active CPU mask: 0x0000000000000f00. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2010-10-28 11:36:58.62 Server Multinode configuration: node 3: CPU mask: 0x000000000000f000 Active CPU mask: 0x000000000000f000. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2010-10-28 11:36:58.62 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-10-28 11:36:58.70 spid2s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 58228, committed (KB): 238180, memory utilization: 24%.
2010-10-28 11:36:58.86 Server The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2010-10-28 11:36:58.86 Server Database mirroring has been enabled on this instance of SQL Server.
2010-10-28 11:36:58.88 spid11s Starting up database 'master'.
2010-10-28 11:36:59.48 spid11s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-10-28 11:36:59.54 spid11s SQL Trace ID 1 was started by login "sa".
2010-10-28 11:36:59.57 spid11s Starting up database 'mssqlsystemresource'.
2010-10-28 11:36:59.60 spid11s The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
2010-10-28 11:36:59.78 spid15s Starting up database 'model'.
2010-10-28 11:36:59.78 spid11s Server name is 'SQLPROD01'. This is an informational message only. No user action is required.
2010-10-28 11:36:59.78 spid11s The NETBIOS name of the local node that is running the server is 'SCTDB02'. This is an informational message only. No user action is required.
2010-10-28 11:37:00.00 spid15s Clearing tempdb database.
2010-10-28 11:37:00.04 Server A self-generated certificate was successfully loaded for encryption.
2010-10-28 11:37:00.05 Server Server is listening on [ 192.168.20.110 <ipv4> 1433].
2010-10-28 11:37:00.05 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2010-10-28 11:37:00.05 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\$$\SQLPROD01\sql\query ].
2010-10-28 11:37:00.06 Server Server is listening on [ 192.168.20.110 <ipv4> 1434].
2010-10-28 11:37:00.06 Server Dedicated admin connection support was established for listening remotely on port 1434.
2010-10-28 11:37:00.10 Logon Error: 17187, Severity: 16, State: 1.
2010-10-28 11:37:00.10 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 192.168.20.75]
2010-10-28 11:37:00.10 Logon Error: 17187, Severity: 16, State: 1.
2010-10-28 11:37:00.10 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 192.168.20.75]
2010-10-28 11:37:00.11 Logon Error: 17187, Severity: 16, State: 1.
2010-10-28 11:37:00.11 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 192.168.20.75]
2010-10-28 11:37:00.11 Logon Error: 17187, Severity: 16, State: 1.
2010-10-28 11:37:00.11 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 192.168.20.75]
2010-10-28 11:37:00.11 Logon Error: 17187, Severity: 16, State: 1.
2010-10-28 11:37:00.11 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 192.168.20.55]
2010-10-28 11:37:00.11 Logon Error: 17187, Severity: 16, State: 1.
2010-10-28 11:37:00.11 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 192.168.20.55]
2010-10-28 11:37:00.12 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-10-28 11:37:00.16 spid21s Starting up database 'Report_Stage'.
2010-10-28 11:37:00.16 spid19s Starting up database 'Report'.
2010-10-28 11:37:00.16 spid22s Starting up database 'sqltrace'.
2010-10-28 11:37:00.16 spid18s Starting up database 'msdb'.
2010-10-28 11:37:00.16 spid23s Starting up database 'Archive'.
2010-10-28 11:37:00.16 spid25s Starting up database 'Weblog_Archive'.
2010-10-28 11:37:00.16 spid26s Starting up database 'CPMS'.
2010-10-28 11:37:00.16 spid27s Starting up database 'distribution'.
2010-10-28 11:37:00.16 spid24s Starting up database 'Weblog'.
2010-10-28 11:37:00.16 spid20s Starting up database 'Dashboard'.
2010-10-28 11:37:00.18 Logon Error: 18456, Severity: 14, State: 16.
2010-10-28 11:37:00.18 Logon Login failed for user 'CPMS_public'. [CLIENT: 192.168.20.93]
2010-10-28 11:37:00.18 Logon Error: 18456, Severity: 14, State: 16.
2010-10-28 11:37:00.18 Logon Login failed for user 'CPMS_public'. [CLIENT: 192.168.20.207]
2010-10-28 11:37:00.26 spid15s Starting up database 'tempdb'.
2010-10-28 11:37:00.29 spid15s Analysis of database 'tempdb' (2) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-10-28 11:37:00.32 spid28s The Service Broker protocol transport is disabled or not configured.
2010-10-28 11:37:00.33 spid28s The Database Mirroring protocol transport is disabled or not configured.
2010-10-28 11:37:00.34 spid28s Service Broker manager has started.
2010-10-28 11:37:00.49 spid24s Analysis of database 'Weblog' (10) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-10-28 11:37:00.73 spid24s Recovery is writing a checkpoint in database 'Weblog' (10). This is an informational message only. No user action is required.
2010-10-28 11:37:00.74 spid25s CHECKDB for database 'Weblog_Archive' finished without errors on 2009-01-27 21:50:16.100 (local time). This is an informational message only; no user action is required.
2010-10-28 11:37:00.79 spid24s CHECKDB for database 'Weblog' finished without errors on 2009-01-27 21:50:16.100 (local time). This is an informational message only; no user action is required.
2010-10-28 11:37:00.79 spid23s CHECKDB for database 'Archive' finished without errors on 2009-01-27 19:51:44.347 (local time). This is an informational message only; no user action is required.
2010-10-28 11:37:00.94 spid20s CHECKDB for database 'Dashboard' finished without errors on 2009-01-22 21:17:22.673 (local time). This is an informational message only; no user action is required.
2010-10-28 11:37:01.38 spid22s CHECKDB for database 'sqltrace' finished without errors on 2009-01-27 19:47:00.963 (local time). This is an informational message only; no user action is required.
2010-10-28 11:37:01.96 spid19s Recovery is writing a checkpoint in database 'Report' (6). This is an informational message only. No user action is required.
2010-10-28 11:37:02.08 spid19s CHECKDB for database 'Report' finished without errors on 2009-01-22 21:18:23.807 (local time). This is an informational message only; no user action is required.
2010-10-28 11:37:02.11 spid26s Analysis of database 'CPMS' (12) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-10-28 11:37:02.19 spid26s Recovery is writing a checkpoint in database 'CPMS' (12). This is an informational message only. No user action is required.
2010-10-28 11:37:02.20 spid21s Analysis of database 'Report_Stage' (7) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-10-28 11:37:02.21 Logon Error: 18456, Severity: 14, State: 16.
2010-10-28 11:37:02.21 Logon Login failed for user 'CPMS_public'. [CLIENT: 192.168.20.93]
2010-10-28 11:37:02.22 Logon Error: 18456, Severity: 14, State: 16.
2010-10-28 11:37:02.22 Logon Login failed for user 'CPMS_public'. [CLIENT: 192.168.20.89]
2010-10-28 11:37:02.26 Logon Error: 18456, Severity: 14, State: 16.
2010-10-28 11:37:02.26 Logon Login failed for user 'CPMS_public'. [CLIENT: 192.168.20.85]
2010-10-28 11:37:02.26 Logon Error: 18456, Severity: 14, State: 16.
2010-10-28 11:37:02.26 Logon Login failed for user 'CPMS_public'. [CLIENT: 192.168.20.74]
2010-10-28 11:37:02.28 spid26s CHECKDB for database 'CPMS' finished without errors on 2009-01-27 23:48:40.400 (local time). This is an informational message only; no user action is required.
2010-10-28 11:37:02.36 spid21s CHECKDB for database 'Report_Stage' finished without errors on 2009-01-27 23:48:40.400 (local time). This is an informational message only; no user action is required.
2010-10-28 11:37:02.40 Logon Error: 18456, Severity: 14, State: 16.
2010-10-28 11:37:02.40 Logon Login failed for user 'CPMS_public'. [CLIENT: 192.168.20.98]
2010-10-28 11:37:02.45 Logon Error: 18456, Severity: 14, State: 16.
2010-10-28 11:37:02.45 Logon Login failed for user 'CPMS_public'. [CLIENT: 192.168.20.93]
2010-10-28 11:37:02.46 Logon Error: 18456, Severity: 14, State: 16.
2010-10-28 11:37:02.46 Logon Login failed for user 'CPMS_public'. [CLIENT: 192.168.20.64]
2010-10-28 11:37:02.63 spid11s Recovery is complete. This is an informational message only. No user action is required.
2010-10-28 11:37:02.68 spid11s Launched startup procedure 'sp_MSrepl_startup'.
2010-10-28 11:37:03.04 spid78 Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-10-28 11:37:03.36 spid78 Using 'xpsqlbot.dll' version '2005.90.4035' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2010-10-28 11:37:03.54 spid78 Using 'xpstar90.dll' version '2005.90.4035' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-10-28 11:37:03.57 spid78 Using 'xplog70.dll' version '2005.90.4035' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2010-10-28 11:37:14.70 spid209 Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from c:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\.
2010-10-28 11:37:15.85 spid209 AppDomain 2 (master.dbo[runtime].1) created.
2010-10-28 11:37:15.87 spid209 Unsafe assembly 'scout.notificationssqlserverclr, version=1.0.3524.27362, culture=neutral, publickeytoken=f65af4cc077b89ea, processorarchitecture=msil' loaded into appdomain 2 (master.dbo[runtime].1).
2010-10-28 11:37:15.88 spid221 Unsafe assembly 'scout.sqldatachangenotifierclr, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 2 (master.dbo[runtime].1).
2010-10-28 11:37:16.13 spid221 Unsafe assembly 'system.servicemodel, version=3.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089, processorarchitecture=msil' loaded into appdomain 2 (master.dbo[runtime].1).
2010-10-28 11:37:16.58 spid221 Unsafe assembly 'smdiagnostics, version=3.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089, processorarchitecture=msil' loaded into appdomain 2 (master.dbo[runtime].1).
2010-10-28 11:37:16.81 spid221 Unsafe assembly 'system.runtime.serialization, version=3.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089, processorarchitecture=msil' loaded into appdomain 2 (master.dbo[runtime].1).
2010-10-28 11:49:20.06 spid51 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-10-28 11:49:21.58 spid28s Service Broker manager has shut down.
2010-10-28 11:49:21.58 spid11s .NET Framework runtime has been stopped.
2010-10-28 11:49:21.80 spid11s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2010-10-28 11:49:21.80 spid11s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-10-29 : 16:12:18
Please don't post in multiple places. Posted and answered: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=152317

--
Gail Shaw
SQL Server MVP
Go to Top of Page

sree.dba
Starting Member

2 Posts

Posted - 2014-06-17 : 02:05:53
Hi All iam also facing this problem. Can anyone help to resolve this issue.
The MSSQLSERVER Services terminated unexpectedly. it has done 3 time(s).

Sqlserver 2008R2 RTM 10.50.1617.0 (X64)

Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor)
System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.

Description:
Event Logs : System
Event Type : Error
Event Id : 7034
Time:24/05/2014 9:25:27PM and 12/06/2014 10:01:12AM
Event Message : The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 3 time(s).



Any help would be greatly appreciated since it is a production server. if u want any extra informaion i will provide .



ErrorLog:

2014-05-24 21:25:32.61 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)
Apr 22 2011 19:23:43
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

2014-05-24 21:25:32.61 Server (c) Microsoft Corporation.
2014-05-24 21:25:32.61 Server All rights reserved.
2014-05-24 21:25:32.61 Server Server process ID is 19696.
2014-05-24 21:25:32.61 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.
2014-05-24 21:25:32.61 Server Authentication mode is MIXED.
2014-05-24 21:25:32.61 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2014-05-24 21:25:32.61 Server This instance of SQL Server last reported using a process ID of 7388 at 24/05/2014 9:24:40 PM (local) 24/05/2014 11:24:40 AM (UTC). This is an informational message only; no user action is required.
2014-05-24 21:25:32.63 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2014-05-24 21:25:32.63 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2014-05-24 21:25:32.63 Server Detected 2 CPUs. This is an informational message; no user action is required.
2014-05-24 21:25:32.73 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2014-05-24 21:25:32.78 Server Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2014-05-24 21:25:32.81 spid5s Starting up database 'master'.
2014-05-24 21:25:32.95 spid5s 97 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2014-05-24 21:25:32.97 spid5s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2014-05-24 21:25:32.97 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2014-05-24 21:25:33.10 spid5s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2014-05-24 21:25:33.12 spid5s SQL Trace ID 1 was started by login "sa".
2014-05-24 21:25:33.13 spid5s Starting up database 'mssqlsystemresource'.
2014-05-24 21:25:33.14 spid5s The resource database build version is 10.50.1617. This is an informational message only. No user action is required.
2014-05-24 21:25:33.69 spid10s Starting up database 'model'.
2014-05-24 21:25:33.70 spid5s Server name is 'AUPROC01'. This is an informational message only. No user action is required.
2014-05-24 21:25:34.03 Server A self-generated certificate was successfully loaded for encryption.
2014-05-24 21:25:34.04 Server Server is listening on [ 'any' <ipv6> 1433].
2014-05-24 21:25:34.04 Server Server is listening on [ 'any' <ipv4> 1433].
2014-05-24 21:25:34.05 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2014-05-24 21:25:34.05 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2014-05-24 21:25:34.05 Server Server is listening on [ ::1 <ipv6> 1434].
2014-05-24 21:25:34.05 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2014-05-24 21:25:34.05 Server Dedicated admin connection support was established for listening locally on port 1434.
2014-05-24 21:25:34.20 spid13s A new instance of the full-text filter daemon host process has been successfully started.
2014-05-24 21:25:34.22 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2014-05-24 21:25:34.22 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2014-05-24 21:25:34.27 spid14s Starting up database 'ReportServer'.
2014-05-24 21:25:34.27 spid15s Starting up database 'ReportServerTempDB'.
2014-05-24 21:25:34.28 spid13s Starting up database 'msdb'.
2014-05-24 21:25:34.28 spid16s Starting up database 'FileProcess'.
2014-05-24 21:25:34.28 spid17s Starting up database 'SSIS_TASK'.
2014-05-24 21:25:34.29 spid18s Starting up database 'DDS_MSG'.
2014-05-24 21:25:34.69 spid13s 670 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2014-05-24 21:25:34.71 spid10s Clearing tempdb database.
2014-05-24 21:25:34.71 spid13s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2014-05-24 21:25:34.71 spid13s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2014-05-24 21:25:35.00 spid51 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2014-05-24 21:25:35.05 spid10s Starting up database 'tempdb'.
2014-05-24 21:25:35.06 spid51 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_sqlagent_monitor'. This is an informational message only; no user action is required.
2014-05-24 21:25:35.06 spid16s 104 transactions rolled forward in database 'FileProcess' (7). This is an informational message only. No user action is required.
2014-05-24 21:25:35.09 spid16s 0 transactions rolled back in database 'FileProcess' (7). This is an informational message only. No user action is required.
2014-05-24 21:25:35.09 spid16s Recovery is writing a checkpoint in database 'FileProcess' (7). This is an informational message only. No user action is required.
2014-05-24 21:25:35.18 spid13s The Service Broker protocol transport is disabled or not configured.
2014-05-24 21:25:35.18 spid13s The Database Mirroring protocol transport is disabled or not configured.
2014-05-24 21:25:35.21 spid13s Service Broker manager has started.
2014-05-24 21:25:37.59 spid17s Recovery of database 'SSIS_TASK' (8) is 2% complete (approximately 8 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-05-24 21:25:37.72 spid17s Recovery of database 'SSIS_TASK' (8) is 4% complete (approximately 8 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2014-05-24 21:25:38.58 spid17s 561 transactions rolled forward in database 'SSIS_TASK' (8). This is an informational message only. No user action is required.
2014-05-24 21:25:38.59 spid17s 0 transactions rolled back in database 'SSIS_TASK' (8). This is an informational message only. No user action is required.
2014-05-24 21:25:38.59 spid17s Recovery is writing a checkpoint in database 'SSIS_TASK' (8). This is an informational message only. No user action is required.
2014-05-24 21:25:38.63 spid17s Recovery completed for database SSIS_TASK (database ID 8) in 1 second(s) (analysis 404 ms, redo 858 ms, undo 7 ms.) This is an informational message only. No user action is required.
2014-05-24 21:25:38.67 spid5s Recovery is complete. This is an informational message only. No user action is required.
2014-05-25 00:00:53.82 spid20s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-05-25 05:00:26.60 spid58 Error: 7393, Severity: 16, State: 1.
2014-05-25 05:00:26.60 spid58 The OLE DB provider "SQLNCLI10" for linked server "AUEXEHP" reported an error 0x8000FFFF aborting the current transaction.
2014-05-26 00:00:20.18 spid18s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-05-26 10:12:24.39 Logon Error: 18456, Severity: 14, State: 5.
2014-05-26 10:12:24.39 Logon Login failed for user 'vamsida'. Reason: Could not find a login matching the name provided. [CLIENT: 10.215.18.1]
2014-05-26 10:12:39.87 Logon Error: 18456, Severity: 14, State: 5.
2014-05-26 10:12:39.87 Logon Login failed for user 'sqladmin'. Reason: Could not find a login matching the name provided. [CLIENT: 10.215.18.1]
2014-05-27 00:00:40.88 spid18s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-05-28 00:00:39.59 spid21s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-05-28 15:55:12.67 spid55 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2014-05-28 15:55:12.71 spid55 Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2014-05-29 00:00:34.93 spid20s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-05-29 15:57:08.71 spid60 Error: 18054, Severity: 16, State: 1.
2014-05-29 15:57:08.71 spid60 Error 50010, severity 10, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
2014-05-30 00:00:15.82 spid16s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-05-30 10:41:47.09 Logon Error: 18456, Severity: 14, State: 5.
2014-05-30 10:41:47.09 Logon Login failed for user 'visuser1'. Reason: Could not find a login matching the name provided. [CLIENT: 10.213.172.121]
2014-05-31 00:00:36.46 spid18s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-05-31 17:06:07.86 Logon Error: 18456, Severity: 14, State: 8.
2014-05-31 17:06:07.86 Logon Login failed for user 'linkedsrvradmin'. Reason: Password did not match that for the login provided. [CLIENT: 10.215.222.121]
2014-06-01 00:00:49.59 spid20s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-02 00:00:19.86 spid21s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-02 12:37:44.64 Logon Error: 18456, Severity: 14, State: 8.
2014-06-02 12:37:44.64 Logon Login failed for user 'linkedsrvradmin'. Reason: Password did not match that for the login provided. [CLIENT: 10.215.222.121]
2014-06-02 12:37:48.09 Logon Error: 18456, Severity: 14, State: 8.
2014-06-02 12:37:48.09 Logon Login failed for user 'linkedsrvradmin'. Reason: Password did not match that for the login provided. [CLIENT: 10.215.222.121]
2014-06-02 12:38:15.96 Logon Error: 18456, Severity: 14, State: 8.
2014-06-02 12:38:15.96 Logon Login failed for user 'linkedsrvradmin'. Reason: Password did not match that for the login provided. [CLIENT: 10.215.222.121]
2014-06-02 12:39:36.73 Logon Error: 18456, Severity: 14, State: 8.
2014-06-02 12:39:36.73 Logon Login failed for user 'linkedsrvradmin'. Reason: Password did not match that for the login provided. [CLIENT: 10.215.222.121]
2014-06-03 00:01:00.98 spid18s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-04 00:00:30.66 spid16s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-05 00:00:57.90 spid19s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-06 00:00:25.99 spid20s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-07 00:00:59.51 spid22s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-08 00:00:53.11 spid24s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-09 00:00:08.88 spid18s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-10 00:00:30.30 spid22s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-11 00:00:57.04 spid19s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.
2014-06-12 00:00:14.17 spid18s This instance of SQL Server has been using a process ID of 19696 since 24/05/2014 9:25:38 PM (local) 24/05/2014 11:25:38 AM (UTC). This is an informational message only; no user action is required.





2014-06-12 10:01:16.35 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)
Apr 22 2011 19:23:43
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

2014-06-12 10:01:16.36 Server (c) Microsoft Corporation.
2014-06-12 10:01:16.36 Server All rights reserved.
2014-06-12 10:01:16.36 Server Server process ID is 14668.
2014-06-12 10:01:16.36 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.
2014-06-12 10:01:16.36 Server Authentication mode is MIXED.
2014-06-12 10:01:16.36 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2014-06-12 10:01:16.36 Server This instance of SQL Server last reported using a process ID of 19696 at 12/06/2014 10:00:35 AM (local) 12/06/2014 12:00:35 AM (UTC). This is an informational message only; no user action is required.
2014-06-12 10:01:16.36 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2014-06-12 10:01:16.41 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2014-06-12 10:01:16.41 Server Detected 2 CPUs. This is an informational message; no user action is required.
2014-06-12 10:01:16.56 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2014-06-12 10:01:16.62 Server Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2014-06-12 10:01:16.64 spid5s Starting up database 'master'.
2014-06-12 10:01:16.82 spid5s 62 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2014-06-12 10:01:16.91 spid5s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2014-06-12 10:01:16.91 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2014-06-12 10:01:17.07 spid5s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2014-06-12 10:01:17.09 spid5s SQL Trace ID 1 was started by login "sa".
2014-06-12 10:01:17.09 spid5s Starting up database 'mssqlsystemresource'.
2014-06-12 10:01:17.11 spid5s The resource database build version is 10.50.1617. This is an informational message only. No user action is required.
2014-06-12 10:01:17.52 spid10s Starting up database 'model'.
2014-06-12 10:01:17.52 spid5s Server name is 'AUPROC01'. This is an informational message only. No user action is required.
2014-06-12 10:01:17.80 Server A self-generated certificate was successfully loaded for encryption.
2014-06-12 10:01:17.93 Server Server is listening on [ 'any' <ipv6> 1433].
2014-06-12 10:01:17.93 Server Server is listening on [ 'any' <ipv4> 1433].
2014-06-12 10:01:17.94 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2014-06-12 10:01:17.94 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2014-06-12 10:01:17.94 Server Server is listening on [ ::1 <ipv6> 1434].
2014-06-12 10:01:17.95 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2014-06-12 10:01:17.95 Server Dedicated admin connection support was established for listening locally on port 1434.
2014-06-12 10:01:17.98 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2014-06-12 10:01:17.98 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2014-06-12 10:01:18.31 spid13s A new instance of the full-text filter daemon host process has been successfully started.
2014-06-12 10:01:18.40 Logon Error: 18456, Severity: 14, State: 38.
2014-06-12 10:01:18.40 Logon Login failed for user 'SCHLOGAU\sqladmin'. Reason: Failed to open the explicitly specified database. [CLIENT: fe80::47f:a6c0:1e92:9a2%18]
2014-06-12 10:01:18.42 spid13s Starting up database 'msdb'.
2014-06-12 10:01:18.42 spid14s Starting up database 'ReportServer'.
2014-06-12 10:01:18.42 spid15s Starting up database 'ReportServerTempDB'.
2014-06-12 10:01:18.43 spid16s Starting up database 'FileProcess'.
2014-06-12 10:01:18.45 spid17s Starting up database 'SSIS_TASK'.
2014-06-12 10:01:18.45 spid18s Starting up database 'DDS_MSG'.
2014-06-12 10:01:19.06 spid10s Clearing tempdb database.
2014-06-12 10:01:19.08 spid13s 391 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2014-06-12 10:01:19.28 spid13s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2014-06-12 10:01:19.28 spid13s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2014-06-12 10:01:19.58 spid10s Starting up database 'tempdb'.
2014-06-12 10:01:19.69 spid51 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2014-06-12 10:01:19.71 spid16s 749 transactions rolled forward in database 'FileProcess' (7). This is an informational message only. No user action is required.
2014-06-12 10:01:19.84 spid51 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_sqlagent_monitor'. This is an informational message only; no user action is required.
2014-06-12 10:01:19.84 spid16s 0 transactions rolled back in database 'FileProcess' (7). This is an informational message only. No user action is required.
2014-06-12 10:01:19.85 spid16s Recovery is writing a checkpoint in database 'FileProcess' (7). This is an informational message only. No user action is required.
2014-06-12 10:01:20.00 spid13s The Service Broker protocol transport is disabled or not configured.
2014-06-12 10:01:20.00 spid13s The Database Mirroring protocol transport is disabled or not configured.
2014-06-12 10:01:20.03 spid13s Service Broker manager has started.
2014-06-12 10:01:22.03 Logon Error: 18456, Severity: 14, State: 38.
2014-06-12 10:01:22.03 Logon Login failed for user 'SCHLOGAU\sqladmin'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
2014-06-12 10:01:23.17 spid17s 173 transactions rolled forward in database 'SSIS_TASK' (8). This is an informational message only. No user action is required.
2014-06-12 10:01:23.18 spid17s 0 transactions rolled back in database 'SSIS_TASK' (8). This is an informational message only. No user action is required.
2014-06-12 10:01:23.19 spid17s Recovery is writing a checkpoint in database 'SSIS_TASK' (8). This is an informational message only. No user action is required.
2014-06-12 10:01:23.25 spid5s Recovery is complete. This is an informational message only. No user action is required.
2014-06-12 17:26:04.04 Logon Error: 18456, Severity: 14, State: 5.
2014-06-12 17:26:04.04 Logon Login failed for user 'sqladmin'. Reason: Could not find a login matching the name provided. [CLIENT: 10.213.172.205]
2014-06-12 17:26:32.57 Logon Error: 18456, Severity: 14, State: 5.
2014-06-12 17:26:32.57 Logon Login failed for user 'sqladmin'. Reason: Could not find a login matching the name provided. [CLIENT: 10.213.172.205]
2014-06-12 17:27:21.93 Logon Error: 18456, Severity: 14, State: 5.
2014-06-12 17:27:21.93 Logon Login failed for user 'vamsida'. Reason: Could not find a login matching the name provided. [CLIENT: 10.213.172.205]
2014-06-12 17:28:37.94 Logon Error: 18456, Severity: 14, State: 5.
2014-06-12 17:28:37.94 Logon Login failed for user 'vamsida'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]
2014-06-13 00:00:44.25 spid21s This instance of SQL Server has been using a process ID of 14668 since 12/06/2014 10:01:23 AM (local) 12/06/2014 12:01:23 AM (UTC). This is an informational message only; no user action is required.
2014-06-13 13:46:36.58 Logon Error: 17806, Severity: 20, State: 14.
2014-06-13 13:46:36.58 Logon SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: 10.215.192.149].
2014-06-13 13:46:36.58 Logon Error: 18452, Severity: 14, State: 1.
2014-06-13 13:46:36.58 Logon Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.215.192.149]
2014-06-13 15:49:56.75 Logon Error: 17806, Severity: 20, State: 14.
2014-06-13 15:49:56.75 Logon SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: 10.215.192.149].
2014-06-13 15:49:56.75 Logon Error: 18452, Severity: 14, State: 1.
2014-06-13 15:49:56.75 Logon Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.215.192.149]
2014-06-14 00:00:26.55 spid18s This instance of SQL Server has been using a process ID of 14668 since 12/06/2014 10:01:23 AM (local) 12/06/2014 12:01:23 AM (UTC). This is an informational message only; no user action is required.
2014-06-15 00:00:24.34 spid22s This instance of SQL Server has been using a process ID of 14668 since 12/06/2014 10:01:23 AM (local) 12/06/2014 12:01:23 AM (UTC). This is an informational message only; no user action is required.
2014-06-15 05:00:17.17 spid60 Error: 7393, Severity: 16, State: 1.
2014-06-15 05:00:17.17 spid60 The OLE DB provider "SQLNCLI10" for linked server "AUEXEHP" reported an error 0x8000FFFF aborting the current transaction.
2014-06-16 00:00:40.26 spid24s This instance of SQL Server has been using a process ID of 14668 since 12/06/2014 10:01:23 AM (local) 12/06/2014 12:01:23 AM (UTC). This is an informational message only; no user action is required.


sreenivas
Go to Top of Page

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-07-17 : 06:28:55
Hi All the databses I see are either RTM or not patched to latest Service packs so please patch it to latest SP and revert if issue still pops up


Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
   

- Advertisement -