MSSQL error logs
- Good database administration includes regular checking of the logs.
- Microsoft provides an undocumented procedure for checking the MSSQL logs: sp_readerrorlog
- sp_readerrorlog reads the complete logs, not just errors, it includes the information messages, warnings and finally the errors.
Applies to:
- Microsoft SQL Server 2000
- Microsoft SQL Server 2005
Data used
LogDate ProcessInfo Text
----------------------- ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2007-11-18 16:41:27.930 Server Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86)
Mar 2 2007 20:01:28
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2007-11-18 16:41:27.930 Server (c) 2005 Microsoft Corporation.
2007-11-18 16:41:27.930 Server All rights reserved.
2007-11-18 16:41:27.930 Server Server process ID is 1556.
2007-11-18 16:41:27.930 Server Authentication mode is WINDOWS-ONLY.
2007-11-18 16:41:27.930 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-11-18 16:41:27.930 Server This instance of SQL Server last reported using a process ID of 1536 at 11/16/2007 1:54:19 PM (local) 11/16/2007 9:54:19 PM (UTC). This is an informational message only; no user action is required.
2007-11-18 16:41:27.930 Server Registry startup parameters:
2007-11-18 16:41:27.930 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-11-18 16:41:27.930 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-11-18 16:41:27.930 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-11-18 16:41:27.960 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-11-18 16:41:27.980 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-11-18 16:41:28.210 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.
2007-11-18 16:41:28.530 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-11-18 16:41:31.040 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.
2007-11-18 16:41:31.040 Server Database mirroring has been enabled on this instance of SQL Server.
2007-11-18 16:41:31.060 spid5s Starting up database 'master'.
2007-11-18 16:41:31.170 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-11-18 16:41:31.230 spid5s SQL Trace ID 1 was started by login "sa".
2007-11-18 16:41:31.230 spid5s Starting up database 'mssqlsystemresource'.
2007-11-18 16:41:31.260 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-11-18 16:41:31.480 spid5s Server name is 'SQLSERVER'. This is an informational message only. No user action is required.
2007-11-18 16:41:31.480 spid9s Starting up database 'model'.
2007-11-18 16:41:31.840 Server A self-generated certificate was successfully loaded for encryption.
2007-11-18 16:41:31.840 Server Server is listening on [ 'any' <ipv4> 1433].
2007-11-18 16:41:31.840 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2007-11-18 16:41:31.840 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2007-11-18 16:41:31.840 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2007-11-18 16:41:31.840 Server Dedicated admin connection support was established for listening locally on port 1434.
2007-11-18 16:41:31.850 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an in
2007-11-18 16:41:31.850 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-11-18 16:41:32.120 spid12s Starting up database 'msdb'.
2007-11-18 16:41:32.120 spid13s Starting up database 'ReportServer'.
2007-11-18 16:41:32.120 spid14s Starting up database 'ReportServerTempDB'.
2007-11-18 16:41:32.140 spid15s Starting up database 'AdventureWorksDW'.
2007-11-18 16:41:32.590 spid9s Clearing tempdb database.
2007-11-18 16:41:32.870 spid14s Starting up database 'AdventureWorks'.
2007-11-18 16:41:32.900 spid12s Starting up database 'AdventureWorksLT'.
2007-11-18 16:41:32.920 spid13s Starting up database 'sql911'.
2007-11-18 16:41:34.450 spid13s CHECKDB for database 'sql911' finished without errors on 2007-10-23 08:04:47.770 (local time). This is an informational message only; no user action is required.
2007-11-18 16:41:34.760 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.
2007-11-18 16:41:35.390 spid9s Starting up database 'tempdb'.
2007-11-18 16:41:35.600 spid5s Recovery is complete. This is an informational message only. No user action is required.
2007-11-18 16:41:35.600 spid12s The Service Broker protocol transport is disabled or not configured.
2007-11-18 16:41:35.600 spid12s The Database Mirroring protocol transport is disabled or not configured.
2007-11-18 16:41:35.620 spid12s Service Broker manager has started.
2007-11-19 00:00:10.640 spid14s This instance of SQL Server has been using a process ID of 1556 since 11/18/2007 4:41:35 PM (local) 11/19/2007 12:41:35 AM (UTC). This is an informational message only; no user action is required.
2007-11-19 07:46:02.170 spid51 Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2007-11-20 00:00:55.650 spid14s This instance of SQL Server has been using a process ID of 1556 since 11/18/2007 4:41:35 PM (local) 11/19/2007 12:41:35 AM (UTC). This is an informational message only; no user action is required.
- From this listing, you can see that the SQL Server was started at 2007-11-18 16:41.
- sp_readerrorlog is NOT documented in the books-on-line, therefore it's not supported by Microsoft.
- The maximum length of the message is 255 chars wide, anything wider will be truncated.
- You can use sp_readerrorlog to look at the previous logs, not just the current one, by adding a number 1 or 2 or 3...
- sp_readerrorlog 1 is the previous error log.
- sp_readerrorlog 2 is the second previous error log, and so on...
PRINT 'Previous errorlog';
PRINT '*****************';
EXEC sp_readerrorlog 1;
go
PRINT ' '
PRINT 'Previous errorlog -2';
PRINT '********************';
EXEC sp_readerrorlog 2;
go
PRINT ' '
PRINT 'Previous errorlog -3';
PRINT '********************';
EXEC sp_readerrorlog 3;
go
PRINT ' '
PRINT 'Previous errorlog -4';
PRINT '********************';
EXEC sp_readerrorlog 4;
go
PRINT ' '
PRINT 'Previous errorlog -5';
PRINT '********************';
EXEC sp_readerrorlog 5;
go
PRINT ' '
PRINT 'Previous errorlog -6';
PRINT '********************';
EXEC sp_readerrorlog 6;
go
Previous errorlog
*****************
LogDate ProcessInfo Text
----------------------- ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2007-11-15 18:46:20.780 Server Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86)
Mar 2 2007 20:01:28
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2007-11-15 18:46:20.780 Server (c) 2005 Microsoft Corporation.
2007-11-15 18:46:20.780 Server All rights reserved.
2007-11-15 18:46:20.780 Server Server process ID is 1536.
2007-11-15 18:46:20.780 Server Authentication mode is WINDOWS-ONLY.
2007-11-15 18:46:20.780 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-11-15 18:46:20.780 Server This instance of SQL Server last reported using a process ID of 1560 at 11/15/2007 5:53:04 PM (local) 11/16/2007 1:53:04 AM (UTC). This is an informational message only; no user action is required.
2007-11-15 18:46:20.780 Server Registry startup parameters:
2007-11-15 18:46:20.780 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-11-15 18:46:20.780 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-11-15 18:46:20.780 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-11-15 18:46:20.820 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-11-15 18:46:20.820 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-11-15 18:46:21.030 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.
2007-11-15 18:46:21.350 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-11-15 18:46:23.840 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.
2007-11-15 18:46:23.840 Server Database mirroring has been enabled on this instance of SQL Server.
2007-11-15 18:46:23.950 spid5s Starting up database 'master'.
2007-11-15 18:46:24.290 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-11-15 18:46:24.390 spid5s SQL Trace ID 1 was started by login "sa".
2007-11-15 18:46:24.400 spid5s Starting up database 'mssqlsystemresource'.
2007-11-15 18:46:24.430 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-11-15 18:46:24.650 spid5s Server name is 'SQLSERVER'. This is an informational message only. No user action is required.
2007-11-15 18:46:24.650 spid9s Starting up database 'model'.
2007-11-15 18:46:24.890 Server A self-generated certificate was successfully loaded for encryption.
2007-11-15 18:46:24.890 Server Server is listening on [ 'any' <ipv4> 1433].
2007-11-15 18:46:24.890 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2007-11-15 18:46:24.890 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2007-11-15 18:46:24.890 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2007-11-15 18:46:24.890 Server Dedicated admin connection support was established for listening locally on port 1434.
2007-11-15 18:46:24.900 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an in
2007-11-15 18:46:24.900 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-11-15 18:46:25.120 spid9s Clearing tempdb database.
2007-11-15 18:46:25.430 spid9s Starting up database 'tempdb'.
2007-11-15 18:46:25.500 spid12s The Service Broker protocol transport is disabled or not configured.
2007-11-15 18:46:25.500 spid12s The Database Mirroring protocol transport is disabled or not configured.
2007-11-15 18:46:25.500 spid12s Service Broker manager has started.
2007-11-15 18:46:25.620 spid15s Starting up database 'msdb'.
2007-11-15 18:46:25.640 spid16s Starting up database 'ReportServer'.
2007-11-15 18:46:25.850 spid17s Starting up database 'ReportServerTempDB'.
2007-11-15 18:46:25.870 spid18s Starting up database 'AdventureWorksDW'.
2007-11-15 18:46:26.310 spid15s Starting up database 'AdventureWorks'.
2007-11-15 18:46:26.390 spid16s Starting up database 'AdventureWorksLT'.
2007-11-15 18:46:26.420 spid17s Starting up database 'sql911'.
2007-11-15 18:46:27.100 spid17s CHECKDB for database 'sql911' finished without errors on 2007-10-23 08:04:47.770 (local time). This is an informational message only; no user action is required.
2007-11-15 18:46:27.260 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.
2007-11-15 18:46:27.260 spid5s Recovery is complete. This is an informational message only. No user action is required.
2007-11-15 18:52:47.900 spid51 Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2007-11-16 00:00:27.260 spid21s This instance of SQL Server has been using a process ID of 1536 since 11/15/2007 6:46:27 PM (local) 11/16/2007 2:46:27 AM (UTC). This is an informational message only; no user action is required.
2007-11-16 13:54:19.700 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2007-11-16 13:54:21.140 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. T
2007-11-16 13:54:21.230 Server Error: 17054, Severity: 16, State: 1.
2007-11-16 13:54:21.230 Server The current event was not reported to the Windows Events log. Operating system error = 1717(The interface is unknown.). You may need to clear the Windows Events log if it is full.
2007-11-16 13:54:21.710 spid12s Service Broker manager has shut down.
2007-11-16 13:54:21.920 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Previous errorlog -2
********************
LogDate ProcessInfo Text
----------------------- ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2007-11-15 16:44:06.040 Server Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86)
Mar 2 2007 20:01:28
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2007-11-15 16:44:06.040 Server (c) 2005 Microsoft Corporation.
2007-11-15 16:44:06.040 Server All rights reserved.
2007-11-15 16:44:06.040 Server Server process ID is 1560.
2007-11-15 16:44:06.040 Server Authentication mode is WINDOWS-ONLY.
2007-11-15 16:44:06.040 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-11-15 16:44:06.040 Server This instance of SQL Server last reported using a process ID of 1564 at 11/15/2007 2:36:12 PM (local) 11/15/2007 10:36:12 PM (UTC). This is an informational message only; no user action is required.
2007-11-15 16:44:06.060 Server Registry startup parameters:
2007-11-15 16:44:06.090 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-11-15 16:44:06.090 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-11-15 16:44:06.090 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-11-15 16:44:06.120 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-11-15 16:44:06.120 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-11-15 16:44:06.340 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.
2007-11-15 16:44:06.530 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-11-15 16:44:08.650 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.
2007-11-15 16:44:08.650 Server Database mirroring has been enabled on this instance of SQL Server.
2007-11-15 16:44:09.100 spid5s Starting up database 'master'.
2007-11-15 16:44:09.510 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-11-15 16:44:09.600 spid5s SQL Trace ID 1 was started by login "sa".
2007-11-15 16:44:09.640 spid5s Starting up database 'mssqlsystemresource'.
2007-11-15 16:44:09.670 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-11-15 16:44:10.000 spid5s Server name is 'SQLSERVER'. This is an informational message only. No user action is required.
2007-11-15 16:44:10.000 spid9s Starting up database 'model'.
2007-11-15 16:44:10.230 Server A self-generated certificate was successfully loaded for encryption.
2007-11-15 16:44:10.250 Server Server is listening on [ 'any' <ipv4> 1433].
2007-11-15 16:44:10.250 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2007-11-15 16:44:10.250 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2007-11-15 16:44:10.250 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2007-11-15 16:44:10.250 Server Dedicated admin connection support was established for listening locally on port 1434.
2007-11-15 16:44:10.250 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an in
2007-11-15 16:44:10.250 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-11-15 16:44:10.540 spid12s Starting up database 'msdb'.
2007-11-15 16:44:10.540 spid13s Starting up database 'ReportServer'.
2007-11-15 16:44:10.540 spid14s Starting up database 'ReportServerTempDB'.
2007-11-15 16:44:10.560 spid15s Starting up database 'AdventureWorksDW'.
2007-11-15 16:44:10.620 spid9s Clearing tempdb database.
2007-11-15 16:44:11.230 spid12s Starting up database 'AdventureWorks'.
2007-11-15 16:44:11.510 spid14s Starting up database 'AdventureWorksLT'.
2007-11-15 16:44:11.560 spid15s Starting up database 'sql911'.
2007-11-15 16:44:12.100 spid15s CHECKDB for database 'sql911' finished without errors on 2007-10-23 08:04:47.770 (local time). This is an informational message only; no user action is required.
2007-11-15 16:44:12.170 spid9s Starting up database 'tempdb'.
2007-11-15 16:44:12.320 spid5s Recovery is complete. This is an informational message only. No user action is required.
2007-11-15 16:44:12.320 spid12s The Service Broker protocol transport is disabled or not configured.
2007-11-15 16:44:12.320 spid12s The Database Mirroring protocol transport is disabled or not configured.
2007-11-15 16:44:12.320 spid12s Service Broker manager has started.
2007-11-15 16:49:07.320 spid18s 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.
2007-11-15 17:53:04.090 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2007-11-15 17:53:04.200 spid12s Service Broker manager has shut down.
2007-11-15 17:53:04.200 spid12s Error: 17054, Severity: 16, State: 1.
2007-11-15 17:53:04.200 spid12s The current event was not reported to the Windows Events log. Operating system error = 1717(The interface is unknown.). You may need to clear the Windows Events log if it is full.
2007-11-15 17:53:04.310 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Previous errorlog -3
********************
LogDate ProcessInfo Text
----------------------- ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2007-11-12 15:49:53.850 Server Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86)
Mar 2 2007 20:01:28
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2007-11-12 15:49:53.850 Server (c) 2005 Microsoft Corporation.
2007-11-12 15:49:53.850 Server All rights reserved.
2007-11-12 15:49:53.850 Server Server process ID is 1564.
2007-11-12 15:49:53.850 Server Authentication mode is WINDOWS-ONLY.
2007-11-12 15:49:53.850 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-11-12 15:49:53.850 Server This instance of SQL Server last reported using a process ID of 1560 at 11/12/2007 3:47:08 PM (local) 11/12/2007 11:47:08 PM (UTC). This is an informational message only; no user action is required.
2007-11-12 15:49:53.850 Server Registry startup parameters:
2007-11-12 15:49:53.850 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-11-12 15:49:53.850 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-11-12 15:49:53.850 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-11-12 15:49:53.870 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-11-12 15:49:53.890 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-11-12 15:49:54.100 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.
2007-11-12 15:49:54.260 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-11-12 15:49:56.430 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.
2007-11-12 15:49:56.430 Server Database mirroring has been enabled on this instance of SQL Server.
2007-11-12 15:49:56.460 spid5s Starting up database 'master'.
2007-11-12 15:49:57.640 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-11-12 15:49:57.980 spid5s SQL Trace ID 1 was started by login "sa".
2007-11-12 15:49:58.230 spid5s Starting up database 'mssqlsystemresource'.
2007-11-12 15:49:58.280 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-11-12 15:49:59.170 spid9s Starting up database 'model'.
2007-11-12 15:49:59.510 spid5s Server name is 'SQLSERVER'. This is an informational message only. No user action is required.
2007-11-12 15:49:59.570 Server A self-generated certificate was successfully loaded for encryption.
2007-11-12 15:49:59.620 Server Server is listening on [ 'any' <ipv4> 1433].
2007-11-12 15:49:59.620 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2007-11-12 15:49:59.620 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2007-11-12 15:49:59.620 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2007-11-12 15:49:59.620 Server Dedicated admin connection support was established for listening locally on port 1434.
2007-11-12 15:49:59.640 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an in
2007-11-12 15:49:59.640 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-11-12 15:49:59.680 spid12s Starting up database 'msdb'.
2007-11-12 15:49:59.790 spid13s Starting up database 'ReportServer'.
2007-11-12 15:49:59.790 spid14s Starting up database 'ReportServerTempDB'.
2007-11-12 15:49:59.810 spid15s Starting up database 'AdventureWorksDW'.
2007-11-12 15:50:01.170 spid9s Clearing tempdb database.
2007-11-12 15:50:01.600 spid14s Starting up database 'AdventureWorks'.
2007-11-12 15:50:01.700 spid13s Starting up database 'AdventureWorksLT'.
2007-11-12 15:50:01.890 spid12s Starting up database 'sql911'.
2007-11-12 15:50:02.900 spid12s CHECKDB for database 'sql911' finished without errors on 2007-10-23 08:04:47.770 (local time). This is an informational message only; no user action is required.
2007-11-12 15:50:03.060 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.
2007-11-12 15:50:03.430 spid9s Starting up database 'tempdb'.
2007-11-12 15:50:03.530 spid5s Recovery is complete. This is an informational message only. No user action is required.
2007-11-12 15:50:03.530 spid12s The Service Broker protocol transport is disabled or not configured.
2007-11-12 15:50:03.530 spid12s The Database Mirroring protocol transport is disabled or not configured.
2007-11-12 15:50:03.540 spid12s Service Broker manager has started.
2007-11-13 00:00:38.530 spid21s This instance of SQL Server has been using a process ID of 1564 since 11/12/2007 3:50:03 PM (local) 11/12/2007 11:50:03 PM (UTC). This is an informational message only; no user action is required.
2007-11-13 13:17:13.670 spid51 Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2007-11-14 00:00:13.570 spid18s This instance of SQL Server has been using a process ID of 1564 since 11/12/2007 3:50:03 PM (local) 11/12/2007 11:50:03 PM (UTC). This is an informational message only; no user action is required.
2007-11-15 00:00:48.600 spid20s This instance of SQL Server has been using a process ID of 1564 since 11/12/2007 3:50:03 PM (local) 11/12/2007 11:50:03 PM (UTC). This is an informational message only; no user action is required.
2007-11-15 13:43:28.960 spid1s 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): 10352, committed (KB): 22540, memory utilization: 45%.
2007-11-15 13:49:07.300 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 339 seconds. Working set (KB): 4664, committed (KB): 22540, memory utilization: 20%.
2007-11-15 13:53:34.460 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 606 seconds. Working set (KB): 5012, committed (KB): 22540, memory utilization: 22%.
2007-11-15 13:59:17.260 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 949 seconds. Working set (KB): 5168, committed (KB): 22540, memory utilization: 22%.
2007-11-15 14:03:44.520 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1214 seconds. Working set (KB): 4328, committed (KB): 22540, memory utilization: 19%.
2007-11-15 14:09:17.080 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1548 seconds. Working set (KB): 4860, committed (KB): 22540, memory utilization: 21%.
2007-11-15 14:13:45.520 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1817 seconds. Working set (KB): 5420, committed (KB): 22540, memory utilization: 24%.
2007-11-15 14:36:12.330 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2007-11-15 14:36:27.460 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. T
2007-11-15 14:36:27.740 Server Error: 17054, Severity: 16, State: 1.
2007-11-15 14:36:27.740 Server The current event was not reported to the Windows Events log. Operating system error = 1717(The interface is unknown.). You may need to clear the Windows Events log if it is full.
2007-11-15 14:36:32.080 spid12s Service Broker manager has shut down.
Previous errorlog -4
********************
LogDate ProcessInfo Text
----------------------- ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2007-11-10 13:56:38.390 Server Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86)
Mar 2 2007 20:01:28
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2007-11-10 13:56:38.390 Server (c) 2005 Microsoft Corporation.
2007-11-10 13:56:38.390 Server All rights reserved.
2007-11-10 13:56:38.390 Server Server process ID is 1560.
2007-11-10 13:56:38.390 Server Authentication mode is WINDOWS-ONLY.
2007-11-10 13:56:38.390 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-11-10 13:56:38.390 Server This instance of SQL Server last reported using a process ID of 1540 at 11/9/2007 5:50:22 PM (local) 11/10/2007 1:50:22 AM (UTC). This is an informational message only; no user action is required.
2007-11-10 13:56:38.390 Server Registry startup parameters:
2007-11-10 13:56:38.390 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-11-10 13:56:38.390 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-11-10 13:56:38.390 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-11-10 13:56:38.400 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-11-10 13:56:38.420 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-11-10 13:56:38.570 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.
2007-11-10 13:56:38.820 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-11-10 13:56:41.200 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.
2007-11-10 13:56:41.200 Server Database mirroring has been enabled on this instance of SQL Server.
2007-11-10 13:56:41.310 spid5s Starting up database 'master'.
2007-11-10 13:56:41.820 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-11-10 13:56:42.040 spid5s SQL Trace ID 1 was started by login "sa".
2007-11-10 13:56:42.090 spid5s Starting up database 'mssqlsystemresource'.
2007-11-10 13:56:42.110 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-11-10 13:56:42.460 spid9s Starting up database 'model'.
2007-11-10 13:56:42.730 spid5s Server name is 'SQLSERVER'. This is an informational message only. No user action is required.
2007-11-10 13:56:42.820 Server A self-generated certificate was successfully loaded for encryption.
2007-11-10 13:56:42.820 Server Server is listening on [ 'any' <ipv4> 1433].
2007-11-10 13:56:42.820 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2007-11-10 13:56:42.820 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2007-11-10 13:56:42.820 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2007-11-10 13:56:42.820 Server Dedicated admin connection support was established for listening locally on port 1434.
2007-11-10 13:56:42.840 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an in
2007-11-10 13:56:42.840 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-11-10 13:56:43.100 spid9s Clearing tempdb database.
2007-11-10 13:56:43.150 spid12s Starting up database 'msdb'.
2007-11-10 13:56:43.180 spid13s Starting up database 'ReportServer'.
2007-11-10 13:56:43.180 spid14s Starting up database 'ReportServerTempDB'.
2007-11-10 13:56:43.180 spid15s Starting up database 'AdventureWorksDW'.
2007-11-10 13:56:45.200 spid14s Starting up database 'AdventureWorks'.
2007-11-10 13:56:45.360 spid13s Starting up database 'AdventureWorksLT'.
2007-11-10 13:56:45.450 spid12s Starting up database 'sql911'.
2007-11-10 13:56:46.540 spid12s CHECKDB for database 'sql911' finished without errors on 2007-10-23 08:04:47.770 (local time). This is an informational message only; no user action is required.
2007-11-10 13:56:46.900 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.
2007-11-10 13:56:47.090 spid9s Starting up database 'tempdb'.
2007-11-10 13:56:47.210 spid5s Recovery is complete. This is an informational message only. No user action is required.
2007-11-10 13:56:47.210 spid12s The Service Broker protocol transport is disabled or not configured.
2007-11-10 13:56:47.210 spid12s The Database Mirroring protocol transport is disabled or not configured.
2007-11-10 13:56:47.230 spid12s Service Broker manager has started.
2007-11-11 00:01:02.290 spid23s This instance of SQL Server has been using a process ID of 1560 since 11/10/2007 1:56:47 PM (local) 11/10/2007 9:56:47 PM (UTC). This is an informational message only; no user action is required.
2007-11-12 00:00:47.290 spid20s This instance of SQL Server has been using a process ID of 1560 since 11/10/2007 1:56:47 PM (local) 11/10/2007 9:56:47 PM (UTC). This is an informational message only; no user action is required.
2007-11-12 09:35:04.450 spid51 Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2007-11-12 15:47:08.700 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2007-11-12 15:47:11.370 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. T
2007-11-12 15:47:11.420 Server Error: 17054, Severity: 16, State: 1.
2007-11-12 15:47:11.420 Server The current event was not reported to the Windows Events log. Operating system error = 1717(The interface is unknown.). You may need to clear the Windows Events log if it is full.
2007-11-12 15:47:11.840 spid12s Service Broker manager has shut down.
2007-11-12 15:47:12.320 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Previous errorlog -5
********************
LogDate ProcessInfo Text
----------------------- ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2007-11-05 13:06:25.090 Server Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86)
Mar 2 2007 20:01:28
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2007-11-05 13:06:25.090 Server (c) 2005 Microsoft Corporation.
2007-11-05 13:06:25.090 Server All rights reserved.
2007-11-05 13:06:25.090 Server Server process ID is 1540.
2007-11-05 13:06:25.100 Server Authentication mode is WINDOWS-ONLY.
2007-11-05 13:06:25.100 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-11-05 13:06:25.100 Server This instance of SQL Server last reported using a process ID of 1560 at 11/5/2007 1:05:26 PM (local) 11/5/2007 9:05:26 PM (UTC). This is an informational message only; no user action is required.
2007-11-05 13:06:25.100 Server Registry startup parameters:
2007-11-05 13:06:25.100 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-11-05 13:06:25.100 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-11-05 13:06:25.100 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-11-05 13:06:25.100 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-11-05 13:06:25.250 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-11-05 13:06:25.510 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.
2007-11-05 13:06:25.710 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-11-05 13:06:28.090 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.
2007-11-05 13:06:28.090 Server Database mirroring has been enabled on this instance of SQL Server.
2007-11-05 13:06:28.420 spid5s Starting up database 'master'.
2007-11-05 13:06:28.670 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-11-05 13:06:28.700 spid5s SQL Trace ID 1 was started by login "sa".
2007-11-05 13:06:28.710 spid5s Starting up database 'mssqlsystemresource'.
2007-11-05 13:06:28.730 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-11-05 13:06:28.780 spid5s Server name is 'SQLSERVER'. This is an informational message only. No user action is required.
2007-11-05 13:06:28.790 spid9s Starting up database 'model'.
2007-11-05 13:06:29.070 Server A self-generated certificate was successfully loaded for encryption.
2007-11-05 13:06:29.070 Server Server is listening on [ 'any' <ipv4> 1433].
2007-11-05 13:06:29.090 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2007-11-05 13:06:29.090 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2007-11-05 13:06:29.150 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2007-11-05 13:06:29.150 Server Dedicated admin connection support was established for listening locally on port 1434.
2007-11-05 13:06:29.150 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an in
2007-11-05 13:06:29.150 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-11-05 13:06:29.480 spid9s Clearing tempdb database.
2007-11-05 13:06:29.760 spid9s Starting up database 'tempdb'.
2007-11-05 13:06:29.840 spid12s The Service Broker protocol transport is disabled or not configured.
2007-11-05 13:06:29.840 spid12s The Database Mirroring protocol transport is disabled or not configured.
2007-11-05 13:06:29.840 spid12s Service Broker manager has started.
2007-11-05 13:06:30.290 spid15s Starting up database 'msdb'.
2007-11-05 13:06:30.290 spid16s Starting up database 'ReportServer'.
2007-11-05 13:06:30.320 spid15s Starting up database 'ReportServerTempDB'.
2007-11-05 13:06:30.680 spid17s Starting up database 'AdventureWorksDW'.
2007-11-05 13:06:30.730 spid16s Starting up database 'AdventureWorks'.
2007-11-05 13:06:30.760 spid18s Starting up database 'AdventureWorksLT'.
2007-11-05 13:06:30.790 spid15s Starting up database 'sql911'.
2007-11-05 13:06:30.930 spid15s CHECKDB for database 'sql911' finished without errors on 2007-10-23 08:04:47.770 (local time). This is an informational message only; no user action is required.
2007-11-05 13:06:30.960 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.
2007-11-05 13:06:30.960 spid5s Recovery is complete. This is an informational message only. No user action is required.
2007-11-06 00:00:40.960 spid17s This instance of SQL Server has been using a process ID of 1540 since 11/5/2007 1:06:30 PM (local) 11/5/2007 9:06:30 PM (UTC). This is an informational message only; no user action is required.
2007-11-06 07:43:58.350 spid51 Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2007-11-07 00:00:16.070 spid19s This instance of SQL Server has been using a process ID of 1540 since 11/5/2007 1:06:30 PM (local) 11/5/2007 9:06:30 PM (UTC). This is an informational message only; no user action is required.
2007-11-08 00:00:55.620 spid16s This instance of SQL Server has been using a process ID of 1540 since 11/5/2007 1:06:30 PM (local) 11/5/2007 9:06:30 PM (UTC). This is an informational message only; no user action is required.
2007-11-09 00:00:21.790 spid16s This instance of SQL Server has been using a process ID of 1540 since 11/5/2007 1:06:30 PM (local) 11/5/2007 9:06:30 PM (UTC). This is an informational message only; no user action is required.
2007-11-09 17:50:22.300 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2007-11-09 17:50:29.690 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. T
2007-11-09 17:50:29.800 Server Error: 17054, Severity: 16, State: 1.
2007-11-09 17:50:29.800 Server The current event was not reported to the Windows Events log. Operating system error = 1717(The interface is unknown.). You may need to clear the Windows Events log if it is full.
2007-11-09 17:50:32.460 spid12s Service Broker manager has shut down.
2007-11-09 17:50:33.520 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Previous errorlog -6
********************
LogDate ProcessInfo Text
----------------------- ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2007-11-05 13:02:02.890 Server Microsoft SQL Server 2005 - 9.00.3050.00 (Intel X86)
Mar 2 2007 20:01:28
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2007-11-05 13:02:02.890 Server (c) 2005 Microsoft Corporation.
2007-11-05 13:02:02.890 Server All rights reserved.
2007-11-05 13:02:02.890 Server Server process ID is 1560.
2007-11-05 13:02:02.890 Server Authentication mode is WINDOWS-ONLY.
2007-11-05 13:02:02.890 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-11-05 13:02:02.890 Server This instance of SQL Server last reported using a process ID of 1540 at 11/3/2007 8:10:12 AM (local) 11/3/2007 4:10:12 PM (UTC). This is an informational message only; no user action is required.
2007-11-05 13:02:02.890 Server Registry startup parameters:
2007-11-05 13:02:02.890 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-11-05 13:02:02.890 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-11-05 13:02:02.890 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-11-05 13:02:02.890 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-11-05 13:02:02.920 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-11-05 13:02:03.140 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.
2007-11-05 13:02:03.310 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-11-05 13:02:05.540 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.
2007-11-05 13:02:05.560 Server Database mirroring has been enabled on this instance of SQL Server.
2007-11-05 13:02:06.370 spid5s Starting up database 'master'.
2007-11-05 13:02:06.930 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-11-05 13:02:07.260 spid5s SQL Trace ID 1 was started by login "sa".
2007-11-05 13:02:07.350 spid5s Starting up database 'mssqlsystemresource'.
2007-11-05 13:02:07.460 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-11-05 13:02:07.960 spid5s Server name is 'SQLSERVER'. This is an informational message only. No user action is required.
2007-11-05 13:02:07.960 spid9s Starting up database 'model'.
2007-11-05 13:02:08.680 Server A self-generated certificate was successfully loaded for encryption.
2007-11-05 13:02:08.700 Server Server is listening on [ 'any' <ipv4> 1433].
2007-11-05 13:02:08.700 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2007-11-05 13:02:08.700 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2007-11-05 13:02:08.700 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2007-11-05 13:02:08.700 Server Dedicated admin connection support was established for listening locally on port 1434.
2007-11-05 13:02:08.700 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an in
2007-11-05 13:02:08.700 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2007-11-05 13:02:09.180 spid12s Starting up database 'msdb'.
2007-11-05 13:02:09.180 spid13s Starting up database 'ReportServer'.
2007-11-05 13:02:09.180 spid14s Starting up database 'ReportServerTempDB'.
2007-11-05 13:02:09.200 spid15s Starting up database 'AdventureWorksDW'.
2007-11-05 13:02:10.600 spid9s Clearing tempdb database.
2007-11-05 13:02:10.840 spid14s Starting up database 'AdventureWorks'.
2007-11-05 13:02:10.890 spid12s Starting up database 'AdventureWorksLT'.
2007-11-05 13:02:10.920 spid13s Starting up database 'sql911'.
2007-11-05 13:02:11.960 spid13s CHECKDB for database 'sql911' finished without errors on 2007-10-23 08:04:47.770 (local time). This is an informational message only; no user action is required.
2007-11-05 13:02:12.370 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.
2007-11-05 13:02:12.740 spid9s Starting up database 'tempdb'.
2007-11-05 13:02:12.820 spid5s Recovery is complete. This is an informational message only. No user action is required.
2007-11-05 13:02:12.820 spid12s The Service Broker protocol transport is disabled or not configured.
2007-11-05 13:02:12.820 spid12s The Database Mirroring protocol transport is disabled or not configured.
2007-11-05 13:02:12.840 spid12s Service Broker manager has started.
2007-11-05 13:05:26.790 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2007-11-05 13:05:27.400 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. T
2007-11-05 13:05:27.400 Server Error: 17054, Severity: 16, State: 1.
2007-11-05 13:05:27.400 Server The current event was not reported to the Windows Events log. Operating system error = 1717(The interface is unknown.). You may need to clear the Windows Events log if it is full.
2007-11-05 13:05:27.570 spid12s Service Broker manager has shut down.
2007-11-05 13:05:27.710 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
