首页 > 代码库 > SQL Server错误收集#7
SQL Server错误收集#7
错误#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号早上重启的，刚好是重启后，数据库还没完全恢复时新的连接进来。正常重启一般按照，先禁用数据库端口->备份还原验证->停数据库服务->重启开端口。从信息看来，应该是没有禁用数据库端口，直接重启服务器了。
SQL Server错误收集#7
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。