SQL Server错误收集#7
浏览数：68 /
时间：2015年06月12日
错误#1 09:31 2015/1/26上班查看ERRORLOG发现下面错误信息
字面上理解是有内存压力，中午的时候ERRORLOG频繁报下面错误
问题核实，一台服务器上安装两个实例，其中一台设置了最大服务器内存，而另一台没有设置。重新分配最大内存，错误日志不再收到类似信息。
错误#2 09:31 2015/1/27上班查看ERRORLOG发现下面错误信息
2015-01-27 07:10:19.790 spid9s Recovery is complete. This is an informational message only. No user action is required. 2015-01-27 07:10:19.420 spid9s Recovery is writing a checkpoint in database ‘DBV2‘ (6). This is an informational message only. No user action is required. 2015-01-27 07:10:19.420 spid9s 0 transactions rolled back in database ‘DBV2‘ (6). This is an informational message only. No user action is required. 2015-01-27 07:10:19.310 spid29s 444 transactions rolled forward in database ‘DBV2‘ (6). This is an informational message only. No user action is required. 2015-01-27 07:10:18.890 spid9s Recovery completed for database DBV1(database ID 5) in 3 second(s) (analysis 452 ms, redo 2685 ms, undo 134 ms.) This is an informational message only. No user action is required. 2015-01-27 07:10:18.890 spid9s Recovery is writing a checkpoint in database ‘DBV1‘ (5). This is an informational message only. No user action is required. 2015-01-27 07:10:18.890 spid9s 0 transactions rolled back in database ‘DBV1‘ (5). This is an informational message only. No user action is required. 2015-01-27 07:10:18.410 spid28s 4255 transactions rolled forward in database ‘DBV1‘ (5). This is an informational message only. No user action is required. 2015-01-27 07:10:18.170 登录 Login failed for user ‘Login1‘. 原因: 无法打开明确指定的数据库。 [客户端: xxx.xxx.xxx.xxx] 2015-01-27 07:10:18.170 登录 错误: 18456，严重性: 14，状态: 38。 2015-01-27 07:10:15.260 spid9s Recovery is writing a checkpoint in database ‘msdb‘ (4). This is an informational message only. No user action is required. 2015-01-27 07:10:15.260 spid9s 0 transactions rolled back in database ‘msdb‘ (4). This is an informational message only. No user action is required. 2015-01-27 07:10:15.170 spid12s 114 transactions rolled forward in database ‘msdb‘ (4). This is an informational message only. No user action is required. 2015-01-27 07:10:14.560 spid29s Starting up database ‘DBV2‘. 2015-01-27 07:10:14.560 spid28s Starting up database ‘DBV1‘. 2015-01-27 07:10:14.560 spid12s Starting up database ‘msdb‘. 2015-01-27 07:10:14.460 spid12s A new instance of the full-text filter daemon host process has been successfully started. 2015-01-27 07:10:13.520 登录 Login failed for user ‘Login2‘. 原因: 无法打开明确指定的数据库。 [客户端: xxx.xxx.xxx.xxx] 2015-01-27 07:10:13.520 登录 错误: 18456，严重性: 14，状态: 38。 2015-01-27 07:10:13.110 登录 Login failed for user ‘Login1‘. 原因: 无法打开明确指定的数据库。 [客户端: xxx.xxx.xxx.xxx] 2015-01-27 07:10:13.110 登录 错误: 18456，严重性: 14，状态: 38。 2015-01-27 07:10:13.010 登录 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. [客户端: xxx.xxx.xxx.xxx] 2015-01-27 07:10:13.010 登录 错误: 17187，严重性: 16，状态: 1。 2015-01-27 07:10:12.910 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required. 2015-01-27 07:10:12.910 服务器 The SQL Server 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 informational message. Further action is only required if Kerberos authentication is required by authentication policies. 2015-01-27 07:10:12.900 服务器 Dedicated admin connection support was established for listening locally on port 12345. 2015-01-27 07:10:12.900 服务器 Server is listening on [ 127.0.0.1 <ipv4> 12345]. 2015-01-27 07:10:12.900 服务器 Server is listening on [ ::1 <ipv6> 12345]. 2015-01-27 07:10:12.900 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$INSTANCE\sql\query ]. 2015-01-27 07:10:12.900 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\INSTANCE ]. 2015-01-27 07:10:12.900 服务器 Server is listening on [ ‘any‘ <ipv4> 1234]. 2015-01-27 07:10:12.900 服务器 Server is listening on [ ‘any‘ <ipv6> 1234].
服务器是27号早上重启的，刚好是重启后，数据库还没完全恢复时新的连接进来。正常重启一般按照，先禁用数据库端口->备份还原验证->停数据库服务->重启开端口。从信息看来，应该是没有禁用数据库端口，直接重启服务器了。
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
