SQL Server-errorlog

Default path: xx:\program Files\Microsoft SQL Server\mssql.1\mssql\log\errorlog

Each time you restart the service update, the default is to save 6, of course, you can also use the command to refresh the error log (registry can also OH)

EXEC Sp_cycle_errorlog--Regenerate new log
DBCC errorlog

EXEC xp_instance_regwrite n ' HKEY_LOCAL_MACHINE ', n ' software/microsoft/mssqlserver/mssqlserver ', n ' NumErrorLogs ', REG_DWORD, 20

View the Log archive list

EXEC Xp_enumerrorlogs

View current log details directly through SSMs to add a parameter query:

EXEC Sp_readerrorlog

1. Archive Number (0~99)

2. Log type (1 is SQL Server log, 2 is SQL Server Agent log)

3. Query the included string

4. Query the included string

5. Logdate Start time

6. Logdate End Time

7. Sorting results, sorted by Logdate (Desc, ASC)

You can modify the startup parameter path: The restart takes effect.

Error log sometimes the database does not come up with a reason (you can navigate from the inside to the wrong key):

2016-05-15 09:44:32.06 Server Microsoft SQL server 2014-12.0.2269.0 (X64)--version
June 10 2015 03:35:45--Mirror creation time
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 10240:)--Business 64-bit

2016-05-15 09:44:32.06 Server UTC adjustment:8:00--East Eight (Beijing Hong Kong Time)
2016-05-15 09:44:32.06 Server (c) Microsoft corporation.--Microsoft
2016-05-15 09:44:32.06 Server All rights reserved.--Copyright
2016-05-15 09:44:32.06 Server processes ID is 12716.--server process ID number
2016-05-15 09:44:32.06 Server System manufacturer: ' LENOVO ', System Model: ' 3626fy4 '.--Server systems manufacturer (my notebook) and model
2016-05-15 09:44:32.06 Server Authentication mode is mixed.--database is a mixed mode login method
2016-05-15 09:44:32.06 Server Logging SQL Server messages in file ' D:\Program Files\Microsoft SQL Server\mssql12. Mssqlserver\mssql\log\errorlog '.---this is what we see. Startup log parameters that can be modified to other valid paths
2016-05-15 09:44:32.06 Server The service account is ' Ds_02\administrator '. This is an informational message; No user action is required. Service startup account in the instance properties can be seen in this account can also be modified OH
2016-05-15 09:44:32.06 Server Registry Startup parameters: Registry Startup parameters: instance and registry can be modified
-D D:\Program Files\Microsoft SQL Server\mssql12. Mssqlserver\mssql\data\master.mdf
-e D:\Program Files\Microsoft SQL Server\mssql12. Mssqlserver\mssql\log\errorlog
-L D:\Program Files\Microsoft SQL Server\mssql12. Mssqlserver\mssql\data\mastlog.ldf
2016-05-15 09:44:32.07 Server Command line startup Parameters: Instance started
-S "MSSQLSERVER"
2016-05-15 09:44:32.70 Server SQL Server detected 1 sockets with 2 cores per socket and 4 logical processors per sock ET, 4 total logical processors; Using 4 logical processors based on SQL Server licensing. This is an informational message; No user action is REQUIRED.-CPU 4 core
2016-05-15 09:44:32.70 Server SQL Server is starting at the normal priority base (=7). This is a informational message only. No user action is required.--priority
2016-05-15 09:44:32.70 Server detected 3891 MB of RAM. This is an informational message; No user action is required.--detecting memory
2016-05-15 09:44:32.70 Server using conventional memory in the memories manager.--
2016-05-15 09:44:32.71 Server Error: 8310, severity: 16, State: 1. --The property specified in the operation does not show up on the object
2016-05-15 09:44:32.71 Server Cannot create (or open) named file mapping object ' Global\sql_110_memobj_24_mssqlserver _0 '. SQL Server Performance Counters is disabled.--performance counters do not open properly
2016-05-15 09:44:32.71 Server Error: 3409, severity: 16, State: 1.
2016-05-15 09:44:32.71 Server Performance counter shared memory setup failed with error-1. Reinstall Sqlctr.ini for this instance, and ensure so the instance login account have correct registry permissions.--performance count Device failure requires reinstallation of SQLCTR
2016-05-15 09:44:32.72 Server Default collation:chinese_prc_ci_as (English 2052)--Case insensitive
2016-05-15 09:44:32.76 Server Perfmon counters for resource Governor pools and groups failed to initialize and is Di sabled.--Counter Error
2016-05-15 09:44:32.77 Server Query Store settings initialized with enabled = 1,
2016-05-15 09:44:32.78 Server The maximum number of dedicated administrator connections for this instance is ' 1 '
2016-05-15 09:44:32.78 Server This instance of SQL Server last reported using a process ID of 15236 at 2016/5/15 9:44 : (local) 2016/5/15 1:44:23 (UTC). This is a informational message only; No user action is required.
2016-05-15 09:44:32.78 Server Node configuration:node 0:cpu mask:0x000000000000000f:0 Active CPU mask:0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is a informational message only. No user action is required.
2016-05-15 09:44:32.79 Server Using dynamic Lock allocation.  Initial allocation of 2500 lock blocks and the lock Owner blocks per node.  This is a informational message only. No user action is required.
2016-05-15 09:44:32.81 spid8s starting up database ' master '. Start the system library---below
2016-05-15 09:44:32.95 Server CLR version v4.0.30319 loaded.
2016-05-15 09:44:33.02 spid8s Resource governor Reconfiguration succeeded.
2016-05-15 09:44:33.02 spid8s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2016-05-15 09:44:33.02 spid8s SQL Server Audit has started the audits. This is an informational message. No user action is required.
<{39b75a24-0837-4cec-afdf-b960027ae07e}>rsfxnso initialized. InstanceId = 00000003
<{50080099-5ec4-4eaf-a2a2-63c3da97f8eb}>fsagent is initialized
<{09c4480b-dba4-49b7-956f-68a8b8b2445d}>fsagent is up and running
2016-05-15 09:44:33.03 spid8s filestream:effective level = 2 (remote access enabled), CONFIGURED level = 2, file sys TEM Access Share name = ' MSSQLSERVER '.--Stream
2016-05-15 09:44:33.09 spid8s SQL Trace ID 1 is started by login "sa". ---via SA loginame
2016-05-15 09:44:33.12 spid8s Server name is ' ds_02 '. This is a informational message only. No user action is required.
2016-05-15 09:44:33.17 spid14s A self-generated certificate is successfully loaded for encryption.----Encryption certificate through
2016-05-15 09:44:33.17 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 fr Om C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.---netfranmework 4.0
2016-05-15 09:44:33.18 spid14s Server is listening on [' Any ' <ipv6> 1433].-port default number
2016-05-15 09:44:33.18 spid14s Server is listening on [' any ' <ipv4> 1433].
2016-05-15 09:44:33.18 spid14s Server Local connection provider is OK to accept connection on [\\.\pipe\sqllocal\m Ssqlserver].--named instance
2016-05-15 09:44:33.18 spid14s Server named pipe provider is the ready-to-accept connection on [\\.\pipe\sql\query].
2016-05-15 09:44:33.18 Server is listening on [:: 1 <ipv6> 1434].
2016-05-15 09:44:33.19 Server is listening on [127.0.0.1 <ipv4> 1434].
2016-05-15 09:44:33.19 Server Dedicated admin connection support is established for listening locally on port 1434.
2016-05-15 09:44:33.19 spid14s SQL Server is now a ready for client connections. This is an informational message; No user action is required.
2016-05-15 09:44:33.19 Server SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server Service. Kerberos authentication would not be possible until a SPN was registered for the SQL Server service. This is an informational message. No user action is required.
2016-05-15 09:44:33.20 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN)----domain-controlled [mssqlsvc/ds_02.vcredit.com] for the SQL Server service. Windows return CODE:0XFFFFFFFF, state:53. Failure to register a SPNs might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication are required by authentication policies and if the SPN have not B Een manually registered.
2016-05-15 09:44:33.20 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [mssqlsvc/ds_02.vcredit.com:1433] for the SQL Server service. Windows return CODE:0XFFFFFFFF, state:53. Failure to register a SPNs might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication are required by authentication policies and if the SPN have not B Een manually registered.
2016-05-15 09:44:33.54 Logon Error: 18456, severity: 14, State: 38. --I separated the report server, so I got an error.
2016-05-15 09:44:33.54 Logon Login failed for user ' NT service\reportserver '. Cause: The explicitly specified database "ReportServer" could not be opened. [Client: 2.0.1.2]
2016-05-15 09:44:34.56 spid15s A New instance of the Full-text filter Daemon Host process has been successfully starte D.
2016-05-15 09:44:34.66 spid17s starting up database ' msdb '.---------------start the system library and user library in parallel
2016-05-15 09:44:34.66 spid18s starting up database ' ReportServer '.
2016-05-15 09:44:34.66 spid20s starting up database ' reportservertempdb '.
2016-05-15 09:44:34.66 spid11s starting up database ' Mssqlsystemresource '.
2016-05-15 09:44:34.67 spid21s starting up database ' Sys '.
2016-05-15 09:44:34.67 spid22s starting up database ' TEST '.
2016-05-15 09:44:34.68 spid11s The resource database build version is 12.00.2000. This is a informational message only. No user action is required.
2016-05-15 09:44:34.73 spid11s starting up database ' model '.
2016-05-15 09:44:34.78 spid11s clearing tempdb database.--Temporary library clean up!
2016-05-15 09:44:34.90 spid11s starting up database ' tempdb '.
2016-05-15 09:44:34.92 Server software Usage Metrics is disabled.
2016-05-15 09:44:35.03 spid27s The Service Broker endpoint is in disabled or stopped state.
2016-05-15 09:44:35.03 spid27s The Database mirroring endpoint is in disabled or stopped state.
2016-05-15 09:44:35.05 spid27s Service Broker Manager has started.
2016-05-15 09:44:35.05 spid8s Recovery is complete. This is a informational message only. No user action is required.
2016-05-15 09:44:35.11 spid51 Configuration option ' Agent XPs ' changed from 0 to 1. Run the RECONFIGURE statement to install.--Agent
2016-05-15 09:44:35.25 spid51 Attempting to the load library ' Xpsqlbot.dll ' into memory. This is a informational message only. No user Action is required.--write in memory
2016-05-15 09:44:35.25 spid51 Using ' xpsqlbot.dll ' version ' 2014.120.2000 ' to execute extended stored procedure ' Xp_q V '. This is a informational message only; No user action is required.
2016-05-15 09:44:35.28 spid51 Attempting to the load library ' Xpstar.dll ' into memory. This is a informational message only. No user action is required.
2016-05-15 09:44:35.30 spid51 Using ' xpstar.dll ' version ' 2014.120.2000 ' to execute extended stored procedure ' Xp_sql Agent_notify '. This is a informational message only; No user action is required.

SQL Server-errorlog