标题:SQL某段时间不存数据
取消只看楼主
lingdu007
Rank: 1
等 级:新手上路
帖 子:1
专家分:0
注 册:2022-1-18
 问题点数:0 回复次数:0 
SQL某段时间不存数据
日期,源,严重性,消息
01/01/2022 00:00:09,spid45s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/31/2021 00:00:32,spid34s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/30/2021 12:10:22,spid55,未知,Setting database option ENABLE_BROKER to ON for database 'KJ76'.
12/30/2021 12:10:21,spid55,未知,Setting database option NEW_BROKER to ON for database 'KJ76'.
12/30/2021 12:10:20,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“KJ76”。 [客户端: 172.24.32.53]
12/30/2021 12:10:20,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/30/2021 12:10:19,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/30/2021 12:10:19,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/30/2021 12:10:19,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/30/2021 12:10:19,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/30/2021 12:10:19,Logon,未知,Login failed for user 'kj76n'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.53]
12/30/2021 12:10:19,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/30/2021 12:10:19,Logon,未知,Login failed for user 'kj76n'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/30/2021 12:10:19,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/30/2021 05:36:05,spid79,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/30/2021 05:36:05,spid79,未知,错误: 28054,严重性: 11,状态: 1。
12/30/2021 00:00:54,spid43s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/29/2021 20:47:36,spid79,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/29/2021 20:47:36,spid79,未知,错误: 28054,严重性: 11,状态: 1。
12/29/2021 17:50:36,spid83,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/29/2021 17:50:36,spid83,未知,错误: 28054,严重性: 11,状态: 1。
12/29/2021 14:33:18,spid32s,未知,The query notification dialog on conversation handle '{FB33E630-7168-EC11-8AC0-6CB3111CE5D4}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas. find the remote service &apos;SqlQueryNotificationService-9dc9a47b-d157-4b5c-816c-7bcfe33c0d66&apos; because it does not exist.</Description></Error>'.
12/29/2021 03:11:44,spid84,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/29/2021 03:11:44,spid84,未知,错误: 28054,严重性: 11,状态: 1。
12/29/2021 00:00:22,spid21s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/28/2021 21:19:07,spid80,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/28/2021 21:19:07,spid80,未知,错误: 28054,严重性: 11,状态: 1。
12/28/2021 07:16:24,spid80,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/28/2021 07:16:24,spid80,未知,错误: 28054,严重性: 11,状态: 1。
12/28/2021 04:33:54,spid81,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/28/2021 04:33:54,spid81,未知,错误: 28054,严重性: 11,状态: 1。
12/28/2021 00:00:46,spid37s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/27/2021 11:51:21,spid78,未知,Using 'xplog70.dll' version '2015.130.1601' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
12/27/2021 11:51:21,spid78,未知,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
12/27/2021 00:00:11,spid37s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/26/2021 16:00:19,spid83,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/26/2021 16:00:19,spid83,未知,错误: 28054,严重性: 11,状态: 1。
12/26/2021 15:59:55,spid63,未知,Setting database option NEW_BROKER to ON for database 'KJ76'.
12/26/2021 15:59:54,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“KJ76”。 [客户端: 172.24.32.53]
12/26/2021 15:59:54,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 15:59:53,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“KJ76”。 [客户端: 172.24.32.53]
12/26/2021 15:59:53,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 15:59:53,Logon,未知,Login failed for user 'kj76n'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/26/2021 15:59:53,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 15:59:52,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/26/2021 15:59:52,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 15:59:52,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/26/2021 15:59:52,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 15:59:52,Logon,未知,Login failed for user 'kj76n'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.53]
12/26/2021 15:59:52,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 08:28:16,spid43s,未知,The query notification dialog on conversation handle '{C605C400-DC65-EC11-8AC0-6CB3111CE5D4}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas. find the remote service &apos;SqlQueryNotificationService-d1f5310d-7691-45d5-be42-578b63d1dfda&apos; because it does not exist.</Description></Error>'.
12/26/2021 07:40:13,spid53,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/26/2021 07:40:13,spid53,未知,错误: 28054,严重性: 11,状态: 1。
12/26/2021 07:39:42,spid63,未知,Setting database option NEW_BROKER to ON for database 'KJ76'.
12/26/2021 07:39:41,Logon,未知,Login failed for user 'kj76n'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.53]
12/26/2021 07:39:41,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 07:39:40,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“KJ76”。 [客户端: 172.24.32.53]
12/26/2021 07:39:40,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 07:39:39,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“KJ76”。 [客户端: 172.24.32.53]
12/26/2021 07:39:39,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 07:39:39,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/26/2021 07:39:39,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 07:39:39,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/26/2021 07:39:39,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 07:39:39,Logon,未知,Login failed for user 'kj76n'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/26/2021 07:39:39,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/26/2021 00:00:33,spid44s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/25/2021 00:00:52,spid39s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/24/2021 00:00:15,spid43s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/23/2021 00:00:40,spid36s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/22/2021 10:12:26,spid58,未知,Setting database option ENABLE_BROKER to ON for database 'KJ76'.
12/22/2021 10:12:26,spid58,未知,Setting database option NEW_BROKER to ON for database 'KJ76'.
12/22/2021 10:12:24,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/22/2021 10:12:24,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/22/2021 10:12:24,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/22/2021 10:12:24,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/22/2021 10:12:24,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“KJ76”。 [客户端: 172.24.32.53]
12/22/2021 10:12:24,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/22/2021 10:11:25,spid58,未知,Setting database option ENABLE_BROKER to ON for database 'KJ76'.
12/22/2021 10:11:25,spid58,未知,Setting database option NEW_BROKER to ON for database 'KJ76'.
12/22/2021 10:11:24,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“KJ76”。 [客户端: 172.24.32.53]
12/22/2021 10:11:24,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/22/2021 10:11:22,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/22/2021 10:11:22,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/22/2021 10:11:22,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“KJ76”。 [客户端: 172.24.32.52]
12/22/2021 10:11:22,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/22/2021 10:11:22,Logon,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/22/2021 10:11:22,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/22/2021 10:11:22,Logon,未知,Login failed for user 'kj76n'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.52]
12/22/2021 10:11:22,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/22/2021 10:11:22,Logon,未知,Login failed for user 'kj76n'. 原因: 无法打开明确指定的数据库“kj76”。 [客户端: 172.24.32.53]
12/22/2021 10:11:22,Logon,未知,错误: 18456,严重性: 14,状态: 38。
12/22/2021 00:00:04,spid20s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/21/2021 00:00:27,spid41s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/20/2021 06:09:34,spid71,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/20/2021 06:09:34,spid71,未知,错误: 28054,严重性: 11,状态: 1。
12/20/2021 00:00:52,spid19s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/19/2021 00:00:12,spid37s,未知,This instance of SQL Server has been using a process ID of 8588 since 2021/12/18 16:43:42 (local) 2021/12/18 8:43:42 (UTC). This is an informational message only; no user action is required.
12/18/2021 18:51:08,spid69,未知,Service Broker needs to access the master key in the database 'kj76'. Error code:32. The master key has to exist and the service master key encryption is required.
12/18/2021 18:51:08,spid69,未知,错误: 28054,严重性: 11,状态: 1。
12/18/2021 16:43:45,spid62,未知,Using 'dbghelp.dll' version '4.0.5'
12/18/2021 16:43:44,spid51,未知,Using 'xpstar.dll' version '2015.130.1601' to execute extended stored procedure 'xp_sqlagent_notify'. This is an informational message only; no user action is required.
12/18/2021 16:43:44,spid51,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
12/18/2021 16:43:44,spid51,未知,Using 'xpsqlbot.dll' version '2015.130.1601' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
12/18/2021 16:43:44,spid51,未知,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
12/18/2021 16:43:44,spid51,未知,Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
12/18/2021 16:43:44,spid51,未知,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
12/18/2021 16:43:44,spid51,未知,Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
12/18/2021 16:43:43,spid9s,未知,Recovery is complete. This is an informational message only. No user action is required.
12/18/2021 16:43:43,spid9s,未知,Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb<c/> or msdb failed to start. Event notifications in other databases could be affected as well. Bring msdb online<c/> or enable Service Broker.
12/18/2021 16:43:43,spid9s,未知,Error: 8355<c/> Severity: 16<c/> State: 1.
12/18/2021 16:43:43,spid21s,未知,CHECKDB for database 'kj76' finished without errors on 2021-11-28 17:55:51.797 (local time). This is an informational message only; no user action is required.
12/18/2021 16:43:43,spid22s,未知,CHECKDB for database 'KJ76XRsa' finished without errors on 2021-11-28 18:19:28.333 (local time). This is an informational message only; no user action is required.
12/18/2021 16:43:43,spid33s,未知,Service Broker manager has started.
12/18/2021 16:43:43,spid19s,未知,CHECKDB for database 'msdb' finished without errors on 2021-12-03 16:14:58.703 (local time). This is an informational message only; no user action is required.
12/18/2021 16:43:43,spid33s,未知,The Database Mirroring endpoint is in disabled or stopped state.
12/18/2021 16:43:43,spid33s,未知,The Service Broker endpoint is in disabled or stopped state.
12/18/2021 16:43:43,spid23s,未知,CHECKDB for database 'kj289' finished without errors on 2021-11-28 17:55:38.350 (local time). This is an informational message only; no user action is required.
12/18/2021 16:43:43,spid24s,未知,CHECKDB for database 'RantGB' finished without errors on 2021-11-28 18:21:49.450 (local time). This is an informational message only; no user action is required.
12/18/2021 16:43:43,spid18s,未知,CHECKDB for database 'KJ76Gis' finished without errors on 2021-11-28 18:18:56.180 (local time). This is an informational message only; no user action is required.
12/18/2021 16:43:43,spid25s,未知,CHECKDB for database 'KT578' finished without errors on 2021-11-28 18:21:28.897 (local time). This is an informational message only; no user action is required.
12/18/2021 16:43:43,spid10s,未知,The tempdb database has 8 data file(s).
12/18/2021 16:43:43,spid21s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [5] 'kj76'. XTP Engine version is 0.0.
12/18/2021 16:43:43,spid10s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [2] 'tempdb'. XTP Engine version is 0.0.
12/18/2021 16:43:43,spid10s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [2] 'tempdb'. XTP Engine version is 0.0.
12/18/2021 16:43:43,spid10s,未知,Starting up database 'tempdb'.
12/18/2021 16:43:43,spid10s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [2] 'tempdb'. XTP Engine version is 0.0.
12/18/2021 16:43:43,spid22s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'KJ76XRsa'. XTP Engine version is 0.0.
12/18/2021 16:43:43,Server,未知,Software Usage Metrics is enabled.
12/18/2021 16:43:43,spid10s,未知,Clearing tempdb database.
12/18/2021 16:43:43,spid10s,未知,Polybase feature disabled.
12/18/2021 16:43:43,spid10s,未知,CHECKDB for database 'model' finished without errors on 2021-11-28 17:55:03.480 (local time). This is an informational message only; no user action is required.
12/18/2021 16:43:43,spid18s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [10] 'KJ76Gis'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid10s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [3] 'model'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid10s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [3] 'model'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid10s,未知,Starting up database 'model'.
12/18/2021 16:43:42,spid10s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [3] 'model'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid19s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [4] 'msdb'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid20s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [6] 'TKDWRH'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid10s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [32767] 'mssqlsystemresource'. XTP Engine version is 0.0.
12/18/2021 16:43:42,Server,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/service-A:1433 ] for the SQL Server service. Windows return code: 0xffffffff<c/> state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
12/18/2021 16:43:42,Server,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/service-A ] for the SQL Server service. Windows return code: 0xffffffff<c/> state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
12/18/2021 16:43:42,Server,未知,SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.
12/18/2021 16:43:42,spid15s,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
12/18/2021 16:43:42,Server,未知,Dedicated admin connection support was established for listening locally on port 1434.
12/18/2021 16:43:42,Server,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
12/18/2021 16:43:42,Server,未知,Server is listening on [ ::1 <ipv6> 1434].
12/18/2021 16:43:42,spid15s,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
12/18/2021 16:43:42,spid15s,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
12/18/2021 16:43:42,spid15s,未知,Server is listening on [ 'any' <ipv4> 1433].
12/18/2021 16:43:42,spid15s,未知,Server is listening on [ 'any' <ipv6> 1433].
12/18/2021 16:43:42,spid15s,未知,A self-generated certificate was successfully loaded for encryption.
12/18/2021 16:43:42,spid10s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [32767] 'mssqlsystemresource'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid10s,未知,The resource database build version is 13.00.1601. This is an informational message only. No user action is required.
12/18/2021 16:43:42,spid24s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [12] 'RantGB'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid23s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [8] 'kj289'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid25s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [11] 'KT578'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid21s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [5] 'kj76'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid19s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [4] 'msdb'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid24s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [12] 'RantGB'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid22s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'KJ76XRsa'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid23s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [8] 'kj289'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid20s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [6] 'TKDWRH'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid18s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [10] 'KJ76Gis'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid25s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [11] 'KT578'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid23s,未知,Starting up database 'kj289'.
12/18/2021 16:43:42,spid18s,未知,Starting up database 'KJ76Gis'.
12/18/2021 16:43:42,spid10s,未知,Starting up database 'mssqlsystemresource'.
12/18/2021 16:43:42,spid20s,未知,Starting up database 'TKDWRH'.
12/18/2021 16:43:42,spid19s,未知,Starting up database 'msdb'.
12/18/2021 16:43:42,spid24s,未知,Starting up database 'RantGB'.
12/18/2021 16:43:42,spid22s,未知,Starting up database 'KJ76XRsa'.
12/18/2021 16:43:42,spid21s,未知,Starting up database 'kj76'.
12/18/2021 16:43:42,spid25s,未知,Starting up database 'KT578'.
12/18/2021 16:43:42,spid18s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [10] 'KJ76Gis'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid10s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [32767] 'mssqlsystemresource'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid24s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [12] 'RantGB'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid19s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [4] 'msdb'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid22s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [7] 'KJ76XRsa'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid23s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [8] 'kj289'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid20s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [6] 'TKDWRH'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid21s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [5] 'kj76'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid25s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [11] 'KT578'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid9s,未知,Server name is 'SERVICE-A'. This is an informational message only. No user action is required.
12/18/2021 16:43:42,spid9s,未知,SQL Trace ID 1 was started by login "sa".
12/18/2021 16:43:42,spid9s,未知,SQL Server Audit has started the audits. This is an informational message. No user action is required.
12/18/2021 16:43:42,spid9s,未知,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
12/18/2021 16:43:42,spid9s,未知,Resource governor reconfiguration succeeded.
12/18/2021 16:43:42,spid9s,未知,CHECKDB for database 'master' finished without errors on 2021-12-02 19:24:27.853 (local time). This is an informational message only; no user action is required.
12/18/2021 16:43:42,spid9s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [1] 'master'. XTP Engine version is 0.0.
12/18/2021 16:43:42,Server,未知,Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\\Framework64\v4.0.30319\.
12/18/2021 16:43:42,spid9s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [1] 'master'. XTP Engine version is 0.0.
12/18/2021 16:43:42,spid9s,未知,Starting up database 'master'.
12/18/2021 16:43:42,spid9s,未知,[INFO] HkHostDbCtxt::Initialize(): Database ID: [1] 'master'. XTP Engine version is 0.0.
12/18/2021 16:43:42,Server,未知,CLR version v4.0.30319 loaded.
12/18/2021 16:43:42,Server,未知,Query Store settings initialized with enabled = 1<c/>
12/18/2021 16:43:42,Server,未知,Database Instant File Initialization: 已启用. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
12/18/2021 16:43:42,Server,未知,Lock partitioning is enabled.  This is an informational message only. No user action is required.
12/18/2021 16:43:42,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.
12/18/2021 16:43:42,Server,未知,Node configuration: node 3: CPU mask: 0x0000aaaaaa000000:0 Active CPU mask: 0x000000aaaa000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
12/18/2021 16:43:42,Server,未知,Node configuration: node 2: CPU mask: 0x0000555555000000:0 Active CPU mask: 0x0000005555000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
12/18/2021 16:43:42,Server,未知,Node configuration: node 1: CPU mask: 0x0000000000aaaaaa:0 Active CPU mask: 0x0000000000aaaaaa:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
12/18/2021 16:43:42,Server,未知,Node configuration: node 0: CPU mask: 0x0000000000555555:0 Active CPU mask: 0x0000000000555555:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
12/18/2021 16:43:42,Server,未知,This instance of SQL Server last reported using a process ID of 10148 at 2021/12/18 16:39:48 (local) 2021/12/18 8:39:48 (UTC). This is an informational message only; no user action is required.
12/18/2021 16:43:42,Server,未知,The maximum number of dedicated administrator connections for this instance is '1'
12/18/2021 16:43:42,Server,未知,Implied authentication manager initialization failed. Implied authentication will be disabled.
12/18/2021 16:43:42,Server,未知,InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
12/18/2021 16:43:42,Server,未知,Buffer pool extension is already disabled. No action is necessary.
12/18/2021 16:43:41,Server,未知,Automatic soft-NUMA was enabled because SQL Server has detected hardware NUMA nodes with greater than 8 logical processors.
12/18/2021 16:43:41,Server,未知,Default collation: Chinese_PRC_CI_AS (简体中文 2052)
12/18/2021 16:43:41,Server,未知,Machine supports memory error recovery. SQL memory protection is enabled to recover from memory corruption.
12/18/2021 16:43:41,Server,未知,Large Page Allocated: 32MB
12/18/2021 16:43:41,Server,未知,Large Page Allocated: 32MB
12/18/2021 16:43:41,Server,未知,Using locked pages in the memory manager.
12/18/2021 16:43:41,Server,未知,Detected 65017 MB of RAM. This is an informational message; no user action is required.
12/18/2021 16:43:41,Server,未知,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
12/18/2021 16:43:41,Server,未知,SQL Server detected 2 sockets with 12 cores per socket and 24 logical processors per socket<c/> 48 total logical processors; using 40 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
12/18/2021 16:43:41,Server,未知,Command Line Startup Parameters:<nl/>     -s "MSSQLSERVER"
12/18/2021 16:43:41,Server,未知,Registry startup parameters: <nl/>     -d D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/>     -e D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/>     -l D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
12/18/2021 16:43:41,Server,未知,The service account is 'WORKGROUP\SERVICE-A$'. This is an informational message; no user action is required.
12/18/2021 16:43:41,Server,未知,Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
12/18/2021 16:43:41,Server,未知,Authentication mode is MIXED.
12/18/2021 16:43:41,Server,未知,System Manufacturer: 'Inspur'<c/> System Model: 'NF5270M5'.
12/18/2021 16:43:41,Server,未知,Server process ID is 8588.
12/18/2021 16:43:41,Server,未知,All rights reserved.
12/18/2021 16:43:41,Server,未知,(c) Microsoft Corporation.
12/18/2021 16:43:41,Server,未知,UTC adjustment: 8:00
12/18/2021 16:43:41,Server,未知,Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) <nl/>    Apr 29 2016 23:23:58 <nl/>    Copyright (c) Microsoft Corporation<nl/>    Enterprise Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: )
搜索更多相关主题的帖子: Server This database user the 
2022-01-18 15:07



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-508179-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.064049 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved