spid15s,未知,请哪位大师级帮忙解决一下,没办法了
数据库是2008、每天都会出现一次至两次这样的情况,客户端哪边是卡死状态,或者能动,点保存在卡死,已经5天了,想清高手请教,这是怎么回事,下面是我截的日志。然后重启服务器,就好用了,,,在线等大师指教!!!!日期,源,严重性,消息
06/14/2018 10:04:35,spid51,未知,Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
06/14/2018 10:04:35,spid51,未知,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
06/14/2018 10:04:35,spid51,未知,Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
06/14/2018 10:04:35,spid51,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
06/14/2018 10:04:35,spid51,未知,Using 'xpsqlbot.dll' version '2007.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
06/14/2018 10:04:35,spid51,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
06/14/2018 10:04:33,spid6s,未知,Recovery is complete. This is an informational message only. No user action is required.
06/14/2018 10:04:33,spid19s,未知,CHECKDB for database 'WoodDoor_server' finished without errors on 2014-08-29 21:12:28.217 (local time). This is an informational message only; no user action is required.
06/14/2018 10:04:33,spid19s,未知,Recovery completed for database WoodDoor_server (database ID 8) in 50 second(s) (analysis 3795 ms<c/> redo 2356 ms<c/> undo 17 ms.) This is an informational message only. No user action is required.
06/14/2018 10:03:50,spid19s,未知,Recovery is writing a checkpoint in database 'WoodDoor_server' (8). This is an informational message only. No user action is required.
06/14/2018 10:03:50,spid19s,未知,0 transactions rolled back in database 'WoodDoor_server' (8). This is an informational message only. No user action is required.
06/14/2018 10:03:49,spid19s,未知,3 transactions rolled forward in database 'WoodDoor_server' (8). This is an informational message only. No user action is required.
06/14/2018 10:03:47,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 54% complete (approximately 2 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/14/2018 10:03:47,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 15% complete (approximately 19 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/14/2018 10:03:47,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 3% complete (approximately 118 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/14/2018 10:03:47,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 3% complete (approximately 118 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
06/14/2018 10:03:47,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 2% complete (approximately 118 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
06/14/2018 10:03:46,spid16s,未知,CHECKDB for database 'jySQLdept' finished without errors on 2014-09-28 09:40:47.530 (local time). This is an informational message only; no user action is required.
06/14/2018 10:03:45,spid18s,未知,CHECKDB for database 'jySQLdept_wj' finished without errors on 2014-09-28 09:40:47.530 (local time). This is an informational message only; no user action is required.
06/14/2018 10:03:45,spid16s,未知,Recovery is writing a checkpoint in database 'jySQLdept' (5). This is an informational message only. No user action is required.
06/14/2018 10:03:45,spid18s,未知,Recovery is writing a checkpoint in database 'jySQLdept_wj' (7). This is an informational message only. No user action is required.
06/14/2018 10:03:45,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 1% complete (approximately 120 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
06/14/2018 10:03:44,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 0% complete (approximately 122 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
06/14/2018 10:03:43,spid17s,未知,CHECKDB for database 'jySQLdept_1' finished without errors on 2014-09-28 09:40:47.530 (local time). This is an informational message only; no user action is required.
06/14/2018 10:03:43,spid17s,未知,Recovery is writing a checkpoint in database 'jySQLdept_1' (6). This is an informational message only. No user action is required.
06/14/2018 10:03:42,spid15s,未知,Service Broker manager has started.
06/14/2018 10:03:41,spid15s,未知,The Database Mirroring protocol transport is disabled or not configured.
06/14/2018 10:03:41,spid15s,未知,The Service Broker protocol transport is disabled or not configured.
06/14/2018 10:03:41,spid13s,未知,Starting up database 'tempdb'.
06/14/2018 10:03:40,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
06/14/2018 10:03:40,服务器,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> 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.
06/14/2018 10:03:40,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
06/14/2018 10:03:40,服务器,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
06/14/2018 10:03:40,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
06/14/2018 10:03:40,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
06/14/2018 10:03:40,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
06/14/2018 10:03:40,spid15s,未知,Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
06/14/2018 10:03:40,服务器,未知,A self-generated certificate was successfully loaded for encryption.
06/14/2018 10:03:40,spid13s,未知,Clearing tempdb database.
06/14/2018 10:03:39,spid15s,未知,Starting up database 'msdb'.
06/14/2018 10:03:39,spid19s,未知,Starting up database 'WoodDoor_server'.
06/14/2018 10:03:39,spid18s,未知,Starting up database 'jySQLdept_wj'.
06/14/2018 10:03:39,spid17s,未知,Starting up database 'jySQLdept_1'.
06/14/2018 10:03:39,spid16s,未知,Starting up database 'jySQLdept'.
06/14/2018 10:03:39,spid15s,未知,SQL Server failed to communicate with filter daemon launch service (Windows error: 无法启动服务,原因可能是已被禁用或与其相关联的设备没有启动。<nl/>). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.
06/14/2018 10:03:39,spid15s,未知,错误: 9954,严重性: 16,状态: 1。
06/14/2018 10:03:39,spid6s,未知,Server name is 'LENOVO-Q6U8WO7S'. This is an informational message only. No user action is required.
06/14/2018 10:03:39,spid13s,未知,Starting up database 'model'.
06/14/2018 10:03:39,spid6s,未知,The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
06/14/2018 10:03:39,spid6s,未知,Starting up database 'mssqlsystemresource'.
06/14/2018 10:03:39,spid6s,未知,SQL Trace ID 1 was started by login "sa".
06/14/2018 10:03:39,spid6s,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/14/2018 10:03:39,spid6s,未知,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
06/14/2018 10:03:38,spid6s,未知,Starting up database 'master'.
06/14/2018 10:03:38,服务器,未知,Node configuration: node 1: CPU mask: 0x0000000f Active CPU mask: 0x0000000f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
06/14/2018 10:03:38,服务器,未知,Node configuration: node 0: CPU mask: 0x000000f0 Active CPU mask: 0x000000f0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
06/14/2018 10:03:38,服务器,未知,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.
06/14/2018 10:03:38,服务器,未知,SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory<c/> set the awe enabled option to 1 by using the sp_configure stored procedure.
06/14/2018 10:03:38,服务器,未知,Detected 8 CPUs. This is an informational message; no user action is required.
06/14/2018 10:03:38,服务器,未知,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
06/14/2018 10:03:38,Server,未知,Registry startup parameters: <nl/> -d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
06/14/2018 10:03:38,Server,未知,This instance of SQL Server last reported using a process ID of 1448 at 2018-6-14 10:01:29 (local) 2018-6-14 2:01:29 (UTC). This is an informational message only; no user action is required.
06/14/2018 10:03:38,Server,未知,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
06/14/2018 10:03:38,Server,未知,Authentication mode is MIXED.
06/14/2018 10:03:38,Server,未知,Server process ID is 1448.
06/14/2018 10:03:38,Server,未知,All rights reserved.
06/14/2018 10:03:38,Server,未知,(c) 2005 Microsoft Corporation.
06/14/2018 10:03:38,Server,未知,Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) <nl/> Jul 9 2008 14:43:34 <nl/> Copyright (c) 1988-2008 Microsoft Corporation<nl/> Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
06/14/2018 10:01:29,服务器,未知,SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
06/14/2018 10:00:33,spid56,未知,Autogrow of file 'dbsah_Log' in database 'WoodDoor_server' was cancelled by user or timed out after 6578 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
06/14/2018 09:59:59,spid56,未知,Autogrow of file 'dbsah_Log' in database 'WoodDoor_server' was cancelled by user or timed out after 7625 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
06/14/2018 09:52:52,spid56,未知,Autogrow of file 'dbsah_Log' in database 'WoodDoor_server' was cancelled by user or timed out after 30313 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
06/14/2018 09:52:13,spid55,未知,Autogrow of file 'dbsah_Log' in database 'WoodDoor_server' was cancelled by user or timed out after 25015 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
06/14/2018 09:49:24,spid55,未知,Autogrow of file 'dbsah_Log' in database 'WoodDoor_server' was cancelled by user or timed out after 29672 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
06/14/2018 09:45:18,spid55,未知,Autogrow of file 'dbsah_Log' in database 'WoodDoor_server' was cancelled by user or timed out after 29719 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
06/14/2018 00:36:17,spid25s,未知,Autogrow of file 'jySQLdeptLog' in database 'jySQLdept' took 112875 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
06/14/2018 00:00:39,spid19s,未知,This instance of SQL Server has been using a process ID of 1448 since 2018-6-13 15:56:09 (local) 2018-6-13 7:56:09 (UTC). This is an informational message only; no user action is required.
06/13/2018 15:56:10,spid51,未知,Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
06/13/2018 15:56:10,spid51,未知,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
06/13/2018 15:56:10,spid51,未知,Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
06/13/2018 15:56:10,spid51,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
06/13/2018 15:56:10,spid51,未知,Using 'xpsqlbot.dll' version '2007.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
06/13/2018 15:56:10,spid51,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
06/13/2018 15:56:09,spid8s,未知,Recovery is complete. This is an informational message only. No user action is required.
06/13/2018 15:56:09,spid19s,未知,CHECKDB for database 'WoodDoor_server' finished without errors on 2014-08-29 21:12:28.217 (local time). This is an informational message only; no user action is required.
06/13/2018 15:56:09,spid19s,未知,Recovery completed for database WoodDoor_server (database ID 8) in 42 second(s) (analysis 3559 ms<c/> redo 2181 ms<c/> undo 2 ms.) This is an informational message only. No user action is required.
06/13/2018 15:56:05,登录,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.149]
06/13/2018 15:56:05,登录,未知,错误: 18456,严重性: 14,状态: 38。
06/13/2018 15:55:52,登录,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.149]
06/13/2018 15:55:52,登录,未知,错误: 18456,严重性: 14,状态: 38。
06/13/2018 15:55:44,登录,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.149]
06/13/2018 15:55:44,登录,未知,错误: 18456,严重性: 14,状态: 38。
06/13/2018 15:55:32,spid19s,未知,Recovery is writing a checkpoint in database 'WoodDoor_server' (8). This is an informational message only. No user action is required.
06/13/2018 15:55:32,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 84% complete (approximately 1 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.
06/13/2018 15:55:32,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 84% complete (approximately 1 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/13/2018 15:55:32,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 76% complete (approximately 1 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/13/2018 15:55:30,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 49% complete (approximately 3 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/13/2018 15:55:30,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 11% complete (approximately 28 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/13/2018 15:55:30,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 3% complete (approximately 114 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/13/2018 15:55:30,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 3% complete (approximately 113 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
06/13/2018 15:55:28,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 1% complete (approximately 114 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
06/13/2018 15:55:28,spid16s,未知,CHECKDB for database 'jySQLdept' finished without errors on 2014-09-28 09:40:47.530 (local time). This is an informational message only; no user action is required.
06/13/2018 15:55:28,spid16s,未知,Recovery is writing a checkpoint in database 'jySQLdept' (5). This is an informational message only. No user action is required.
06/13/2018 15:55:28,spid18s,未知,CHECKDB for database 'jySQLdept_wj' finished without errors on 2014-09-28 09:40:47.530 (local time). This is an informational message only; no user action is required.
06/13/2018 15:55:27,spid18s,未知,Recovery is writing a checkpoint in database 'jySQLdept_wj' (7). This is an informational message only. No user action is required.
06/13/2018 15:55:27,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 0% complete (approximately 116 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
06/13/2018 15:55:26,spid17s,未知,CHECKDB for database 'jySQLdept_1' finished without errors on 2014-09-28 09:40:47.530 (local time). This is an informational message only; no user action is required.
06/13/2018 15:55:26,spid17s,未知,Recovery is writing a checkpoint in database 'jySQLdept_1' (6). This is an informational message only. No user action is required.
06/13/2018 15:55:25,spid15s,未知,Service Broker manager has started.
06/13/2018 15:55:25,spid15s,未知,The Database Mirroring protocol transport is disabled or not configured.
06/13/2018 15:55:25,spid15s,未知,The Service Broker protocol transport is disabled or not configured.
06/13/2018 15:55:24,spid13s,未知,Starting up database 'tempdb'.
06/13/2018 15:55:23,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
06/13/2018 15:55:23,服务器,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> 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.
06/13/2018 15:55:23,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
06/13/2018 15:55:23,服务器,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
06/13/2018 15:55:23,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
06/13/2018 15:55:23,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
06/13/2018 15:55:23,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
06/13/2018 15:55:23,服务器,未知,A self-generated certificate was successfully loaded for encryption.
06/13/2018 15:55:23,spid15s,未知,Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
06/13/2018 15:55:22,spid13s,未知,Clearing tempdb database.
06/13/2018 15:55:22,spid18s,未知,Starting up database 'jySQLdept_wj'.
06/13/2018 15:55:22,spid17s,未知,Starting up database 'jySQLdept_1'.
06/13/2018 15:55:22,spid19s,未知,Starting up database 'WoodDoor_server'.
06/13/2018 15:55:22,spid16s,未知,Starting up database 'jySQLdept'.
06/13/2018 15:55:22,spid15s,未知,Starting up database 'msdb'.
06/13/2018 15:55:22,spid15s,未知,SQL Server failed to communicate with filter daemon launch service (Windows error: 无法启动服务,原因可能是已被禁用或与其相关联的设备没有启动。<nl/>). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.
06/13/2018 15:55:22,spid15s,未知,错误: 9954,严重性: 16,状态: 1。
06/13/2018 15:55:22,spid8s,未知,Server name is 'LENOVO-Q6U8WO7S'. This is an informational message only. No user action is required.
06/13/2018 15:55:22,spid13s,未知,Starting up database 'model'.
06/13/2018 15:55:22,spid8s,未知,The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
06/13/2018 15:55:22,spid8s,未知,Starting up database 'mssqlsystemresource'.
06/13/2018 15:55:22,spid8s,未知,SQL Trace ID 1 was started by login "sa".
06/13/2018 15:55:22,spid8s,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
06/13/2018 15:55:22,spid8s,未知,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
06/13/2018 15:55:21,spid8s,未知,Starting up database 'master'.
06/13/2018 15:55:21,服务器,未知,Node configuration: node 1: CPU mask: 0x0000000f Active CPU mask: 0x0000000f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
06/13/2018 15:55:21,服务器,未知,Node configuration: node 0: CPU mask: 0x000000f0 Active CPU mask: 0x000000f0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
06/13/2018 15:55:21,服务器,未知,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.
06/13/2018 15:55:21,服务器,未知,SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory<c/> set the awe enabled option to 1 by using the sp_configure stored procedure.
06/13/2018 15:55:21,服务器,未知,Detected 8 CPUs. This is an informational message; no user action is required.
06/13/2018 15:55:21,服务器,未知,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
06/13/2018 15:55:21,Server,未知,Registry startup parameters: <nl/> -d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
06/13/2018 15:55:21,Server,未知,This instance of SQL Server last reported using a process ID of 1448 at 2018-6-13 15:53:12 (local) 2018-6-13 7:53:12 (UTC). This is an informational message only; no user action is required.
06/13/2018 15:55:21,Server,未知,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
06/13/2018 15:55:21,Server,未知,Authentication mode is MIXED.
06/13/2018 15:55:21,Server,未知,Server process ID is 1448.
06/13/2018 15:55:21,Server,未知,All rights reserved.
06/13/2018 15:55:21,Server,未知,(c) 2005 Microsoft Corporation.
06/13/2018 15:55:21,Server,未知,Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) <nl/> Jul 9 2008 14:43:34 <nl/> Copyright (c) 1988-2008 Microsoft Corporation<nl/> Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
06/13/2018 15:53:12,服务器,未知,SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
06/13/2018 15:50:44,spid54,未知,Autogrow of file 'dbsah_Log' in database 'WoodDoor_server' was cancelled by user or timed out after 22781 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
06/13/2018 15:50:21,spid54,未知,Autogrow of file 'dbsah_Log' in database 'WoodDoor_server' was cancelled by user or timed out after 30094 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
06/13/2018 15:49:51,spid54,未知,Autogrow of file 'dbsah_Log' in database 'WoodDoor_server' was cancelled by user or timed out after 30313 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
06/13/2018 12:03:12,备份,未知,Database backed up. Database: WoodDoor_server<c/> creation date(time): 2015/03/06(14:07:41)<c/> pages dumped: 493120<c/> first LSN: 76284:2665:154<c/> last LSN: 76284:2728:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'E:\backup\WoodDoor_server\WoodDoor_server_backup_2018_06_13_120005_7812500.bak'}). This is an informational message only. No user action is required.
06/13/2018 12:00:34,备份,未知,Database backed up. Database: jySQLdept_wj<c/> creation date(time): 2016/02/23(14:47:32)<c/> pages dumped: 29264<c/> first LSN: 1746937:295605:37<c/> last LSN: 1746937:295621:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'E:\backup\jySQLdept_wj\jySQLdept_wj_backup_2018_06_13_120005_7656250.bak'}). This is an informational message only. No user action is required.
06/13/2018 12:00:25,备份,未知,Database backed up. Database: jySQLdept_1<c/> creation date(time): 2015/03/06(14:07:16)<c/> pages dumped: 24498<c/> first LSN: 1747132:65816:37<c/> last LSN: 1747132:65832:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'E:\backup\jySQLdept_1\jySQLdept_1_backup_2018_06_13_120005_7656250.bak'}). This is an informational message only. No user action is required.
06/13/2018 12:00:15,备份,未知,Database backed up. Database: jySQLdept<c/> creation date(time): 2015/03/06(14:07:05)<c/> pages dumped: 26709<c/> first LSN: 1860410:387362:37<c/> last LSN: 1860410:387378:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'E:\backup\jySQLdept\jySQLdept_backup_2018_06_13_120005_7656250.bak'}). This is an informational message only. No user action is required.
06/13/2018 10:39:12,spid51,未知,Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
06/13/2018 10:39:12,spid51,未知,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
06/13/2018 10:39:12,spid51,未知,Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
06/13/2018 10:39:12,spid51,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
06/13/2018 10:39:11,spid51,未知,Using 'xpsqlbot.dll' version '2007.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
06/13/2018 10:39:11,spid51,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
06/13/2018 10:39:10,spid8s,未知,Recovery is complete. This is an informational message only. No user action is required.
06/13/2018 10:39:10,spid19s,未知,CHECKDB for database 'WoodDoor_server' finished without errors on 2014-08-29 21:12:28.217 (local time). This is an informational message only; no user action is required.
06/13/2018 10:39:10,spid19s,未知,Recovery completed for database WoodDoor_server (database ID 8) in 38 second(s) (analysis 3144 ms<c/> redo 2172 ms<c/> undo 2 ms.) This is an informational message only. No user action is required.
06/13/2018 10:38:43,登录,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.125]
06/13/2018 10:38:43,登录,未知,错误: 18456,严重性: 14,状态: 38。
06/13/2018 10:38:37,spid19s,未知,Recovery is writing a checkpoint in database 'WoodDoor_server' (8). This is an informational message only. No user action is required.
06/13/2018 10:38:36,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 75% complete (approximately 1 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/13/2018 10:38:35,登录,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.2.125]
06/13/2018 10:38:35,登录,未知,错误: 18456,严重性: 14,状态: 38。
06/13/2018 10:38:35,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 43% complete (approximately 3 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/13/2018 10:38:35,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 6% complete (approximately 46 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/13/2018 10:38:34,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 2% complete (approximately 114 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
06/13/2018 10:38:34,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 2% complete (approximately 114 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
06/13/2018 10:38:33,spid16s,未知,CHECKDB for database 'jySQLdept' finished without errors on 2014-09-28 09:40:47.530 (local time). This is an informational message only; no user action is required.
06/13/2018 10:38:33,spid16s,未知,Recovery is writing a checkpoint in database 'jySQLdept' (5). This is an informational message only. No user action is required.
06/13/2018 10:38:33,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 1% complete (approximately 115 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
06/13/2018 10:38:33,spid18s,未知,CHECKDB for database 'jySQLdept_wj' finished without errors on 2014-09-28 09:40:47.530 (local time). This is an informational message only; no user action is required.
06/13/2018 10:38:33,spid18s,未知,Recovery is writing a checkpoint in database 'jySQLdept_wj' (7). This is an informational message only. No user action is required.
06/13/2018 10:38:32,spid19s,未知,Recovery of database 'WoodDoor_server' (8) is 0% complete (approximately 118 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
[此贴子已经被作者于2018-6-14 11:49编辑过]