Summary:
2024-01-28 01:35:31.76 Server Microsoft SQL Server 2019 (RTM-CU24) (KB5031908) - 15.0.4345.5 (X64) Dec 4 2023 14:44:16 Copyright (C) 2019 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
2024-01-28 01:35:31.77 Server Authentication mode is MIXED.
2024-01-28 01:35:31.77 Server Logging SQL Server messages in file 'D:\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2024-01-28 01:35:31.77 Server The service account is 'service-account'.
2024-01-28 01:35:31.77 Server Registry startup parameters:
2024-01-28 01:35:32.03 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2024-01-28 01:35:32.75 Server The maximum number of dedicated administrator connections for this instance is '1'
2024-01-28 01:35:33.05 spid11s Starting up database 'master'.
2024-01-28 01:35:33.47 spid11s CHECKDB for database 'master' finished without errors on 2023-12-31 22:00:02.127 (local time).
2024-01-28 01:35:33.49 spid11s Resource governor reconfiguration succeeded.
2024-01-28 01:35:33.50 spid11s SQL Server Audit has started the audits.
2024-01-28 01:35:33.86 Server Dedicated admin connection support was established for listening remotely on port 1434.
2024-01-28 01:35:33.86 spid25s SQL Server is now ready for client connections.
2024-01-28 01:35:34.05 spid13s Starting up database 'mssqlsystemresource'.
2024-01-28 01:35:34.05 spid26s Starting up database 'msdb'.
2024-01-28 01:35:34.05 spid33s Starting up database 'sqldbahub'.
2024-01-28 01:35:34.06 spid13s The resource database build version is 15.00.4345.
2024-01-28 01:35:34.11 spid13s Starting up database 'model'.
2024-01-28 01:35:34.15 spid13s CHECKDB for database 'model' finished without errors on 2023-12-31 22:00:04.637 (local time).
2024-01-28 01:35:34.16 spid13s Clearing tempdb database.
2024-01-28 01:35:34.20 spid26s CHECKDB for database 'msdb' finished without errors on 2023-12-31 22:00:06.540 (local time).
2024-01-28 01:35:34.69 spid13s Starting up database 'tempdb'.
2024-01-28 01:35:36.01 spid13s The tempdb database has 4 data file(s).
2024-01-28 01:35:36.02 spid11s Recovery is complete. This is an informational message only. No user action is required.
Detailed steps as below:
2024-01-28 01:35:31.76 Server Microsoft SQL Server 2019 (RTM-CU24) (KB5031908) - 15.0.4345.5 (X64) Dec 4 2023 14:44:16
Copyright (C) 2019 Microsoft Corporation
Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
2024-01-28 01:35:31.76 Server UTC adjustment: -5:00
2024-01-28 01:35:31.76 Server (c) Microsoft Corporation.
2024-01-28 01:35:31.76 Server All rights reserved.
2024-01-28 01:35:31.76 Server Server process ID is 5244.
2024-01-28 01:35:31.76 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.
2024-01-28 01:35:31.77 Server Authentication mode is MIXED.
2024-01-28 01:35:31.77 Server Logging SQL Server messages in file 'D:\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2024-01-28 01:35:31.77 Server The service account is 'service-account'.
2024-01-28 01:35:31.77 Server Registry startup parameters:
-d D:\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf
-e D:\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l D:\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2024-01-28 01:35:31.77 Server Command Line Startup Parameters: -s "MSSQLSERVER"
2024-01-28 01:35:31.79 Server SQL Server detected 12 sockets with 1 cores per socket and 1 logical processors per socket,
12 total logical processors; using 12 logical processors based on SQL Server licensing.
2024-01-28 01:35:31.79 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2024-01-28 01:35:31.79 Server Detected 131071 MB of RAM. This is an informational message; no user action is required.
2024-01-28 01:35:32.03 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
2024-01-28 01:35:32.75 Server The maximum number of dedicated administrator connections for this instance is '1'
2024-01-28 01:35:32.76 Server This instance of SQL Server last reported using a process ID of 1108 at 1/28/2024 1:34:57 AM (local) 1/28/2024 6:34:57 AM (UTC).
2024-01-28 01:35:32.78 Server Node configuration: node 0: CPU mask: 0x000000000000003f:0 Active CPU mask: 0x000000000000003f:0.
2024-01-28 01:35:32.91 Server In-Memory OLTP initialized on standard machine.
2024-01-28 01:35:33.05 spid11s Starting up database 'master'.
2024-01-28 01:35:33.13 Server CLR version v4.0.30319 loaded.
2024-01-28 01:35:33.37 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2024-01-28 01:35:33.47 spid11s CHECKDB for database 'master' finished without errors on 2023-12-31 22:00:02.127 (local time).
2024-01-28 01:35:33.49 spid11s Resource governor reconfiguration succeeded.
2024-01-28 01:35:33.49 spid11s SQL Server Audit is starting the audits.
2024-01-28 01:35:33.50 spid11s SQL Server Audit has started the audits.
2024-01-28 01:35:33.61 spid11s SQL Trace ID 1 was started by login "sa".
2024-01-28 01:35:33.85 spid25s A self-generated certificate was successfully loaded for encryption.
2024-01-28 01:35:33.85 spid25s Server is listening on [ 'any' <ipv4> 15018].
2024-01-28 01:35:33.85 spid25s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2024-01-28 01:35:33.85 spid25s Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2024-01-28 01:35:33.86 Server Server is listening on [ 'any' <ipv4> 1434].
2024-01-28 01:35:33.86 Server Dedicated admin connection support was established for listening remotely on port 1434.
2024-01-28 01:35:33.86 spid25s SQL Server is now ready for client connections. This is an informational message; no user action is required.
2024-01-28 01:35:33.86 Server SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service.
2024-01-28 01:35:33.98 spid26s A new instance of the full-text filter daemon host process has been successfully started.
2024-01-28 01:35:34.05 spid26s Always On: The availability replica manager is starting. This is an informational message only. No user action is required.
2024-01-28 01:35:34.05 spid13s Starting up database 'mssqlsystemresource'.
2024-01-28 01:35:34.05 spid26s Starting up database 'msdb'.
2024-01-28 01:35:34.05 spid33s Starting up database 'sqldbahub'.
2024-01-28 01:35:34.06 spid13s The resource database build version is 15.00.4345. This is an informational message only. No user action is required.
2024-01-28 01:35:34.11 spid13s Starting up database 'model'.
2024-01-28 01:35:34.15 spid13s CHECKDB for database 'model' finished without errors on 2023-12-31 22:00:04.637 (local time).
2024-01-28 01:35:34.16 spid13s Clearing tempdb database.
2024-01-28 01:35:34.20 spid26s CHECKDB for database 'msdb' finished without errors on 2023-12-31 22:00:06.540 (local time).
2024-01-28 01:35:34.69 spid13s Starting up database 'tempdb'.
2024-01-28 01:35:36.01 spid13s The tempdb database has 4 data file(s).
2024-01-28 01:35:36.01 spid26s The Service Broker endpoint is in disabled or stopped state.
2024-01-28 01:35:36.01 spid26s The Database Mirroring endpoint is in disabled or stopped state.
2024-01-28 01:35:36.02 spid26s Service Broker manager has started.
2024-01-28 01:35:36.02 spid11s Recovery is complete. This is an informational message only. No user action is required.
2024-01-28 01:41:36.87 spid59 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2024-01-28 01:41:36.89 spid59 Using 'xplog70.dll' version '2019.150.4345' to execute extended stored procedure 'xp_msver'.
2024-01-28 08:55:34.73 spid61 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2024-01-28 08:55:34.78 spid61 Using 'xpstar.dll' version '2019.150.4345' to execute extended stored procedure 'xp_instance_regread'.
No comments:
Post a Comment