Forum Discussion
SQL Server 2019 CU22 (KB5027702) does not install correctly - crashes the server
- Aug 23, 2023Seems to come from here
Error: 2714, Severity: 16, State: 6.
2023-08-16 18:08:08.62 spid9s There is already an object named 'TargetServersRole' in the database.
Please follow below link. it is mentioning another object related to Database Mail but it should apply for your case too
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-2714
Tried the same action as VK-DBA: reinstalled the patch, no result, server still in crash mode.
The only solution was to completely uninstall it from Windows Update history.
I can look through the logs of course, but it never happened before, all past SQL Server 2019 patches installed correctly. There was no relevant message about the error as well, just "SQL Server Agent cannot be started"
- M_RusuAug 23, 2023Copper Contributor
Found it, I can see this relevant message:
Error: 2714, Severity: 16, State: 6.
2023-08-16 18:08:08.62 spid9s There is already an object named 'TargetServersRole' in the database.
Full log
----------------------------------------------------------------------------------------------------
2023-08-16 18:07:43.66 Server Microsoft SQL Server 2019 (RTM-CU22) (KB5027702) - 15.0.4322.2 (X64)
Jul 27 2023 18:11:00
Copyright (C) 2019 Microsoft Corporation
Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
2023-08-16 18:07:43.67 Server UTC adjustment: -4:00
2023-08-16 18:07:43.67 Server (c) Microsoft Corporation.
2023-08-16 18:07:43.67 Server All rights reserved.
2023-08-16 18:07:43.67 Server Server process ID is 4512.
2023-08-16 18:07:43.67 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.
2023-08-16 18:07:43.67 Server Authentication mode is MIXED.
2023-08-16 18:07:43.67 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2023-08-16 18:07:43.67 Server The service account is 'xxxxxxxxxxxx'. This is an informational message; no user action is required.
2023-08-16 18:07:43.67 Server Registry startup parameters:
-d E:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf
-e E:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l E:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2023-08-16 18:07:43.68 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2023-08-16 18:07:45.19 Server SQL Server detected 6 sockets with 1 cores per socket and 1 logical processors per socket, 6 total logical processors; using 6 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2023-08-16 18:07:45.19 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2023-08-16 18:07:45.19 Server Detected 65535 MB of RAM. This is an informational message; no user action is required.
2023-08-16 18:07:45.20 Server Using conventional memory in the memory manager.
2023-08-16 18:07:45.28 Server Page exclusion bitmap is enabled.
2023-08-16 18:07:45.62 Server Buffer Pool: Allocating 16777216 bytes for 9656320 hashPages.
2023-08-16 18:07:46.61 Server Default collation: Latin1_General_CI_AS (us_english 1033)
2023-08-16 18:07:47.23 Server Buffer pool extension is already disabled. No action is necessary.
2023-08-16 18:07:48.16 Server Query Store settings initialized with enabled = 1,
2023-08-16 18:07:48.18 Server The maximum number of dedicated administrator connections for this instance is '1'
2023-08-16 18:07:48.19 Server This instance of SQL Server last reported using a process ID of 3332 at 2023-08-16 6:05:30 PM (local) 2023-08-16 10:05:30 PM (UTC). This is an informational message only; no user action is required.
2023-08-16 18:07:48.20 Server Node configuration: node 0: CPU mask: 0x000000000000003f:0 Active CPU mask: 0x000000000000003f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2023-08-16 18:07:48.26 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.
2023-08-16 18:07:48.32 Server In-Memory OLTP initialized on standard machine.
2023-08-16 18:07:48.41 Server [INFO] Created Extended Events session 'hkenginexesession'
2023-08-16 18:07:48.41 Server Database Instant File Initialization: enabled. 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.
2023-08-16 18:07:48.43 Server Total Log Writer threads: 2. This is an informational message; no user action is required.
2023-08-16 18:07:48.46 Server clflush is selected for pmem flush operation.
2023-08-16 18:07:48.53 spid9s Starting up database 'master'.
2023-08-16 18:07:48.53 Server CLR version v4.0.30319 loaded.
2023-08-16 18:07:48.68 Server Software Usage Metrics is enabled.
2023-08-16 18:07:48.68 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2023-08-16 18:07:48.71 spid9s 9 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2023-08-16 18:07:48.77 spid9s 0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2023-08-16 18:07:48.77 spid9s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2023-08-16 18:07:49.23 spid9s CHECKDB for database 'master' finished without errors on 2023-08-16 00:00:05.813 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:49.40 spid9s Resource governor reconfiguration succeeded.
2023-08-16 18:07:49.41 spid9s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2023-08-16 18:07:49.47 spid9s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2023-08-16 18:07:49.68 spid9s SQL Trace ID 1 was started by login "sa".
2023-08-16 18:07:49.71 spid9s Server name is 'xxxxxxxxxxxx'. This is an informational message only. No user action is required.
2023-08-16 18:07:49.78 spid34s Always On: The availability replica manager is starting. This is an informational message only. No user action is required.
2023-08-16 18:07:49.78 spid34s Always On: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required.
2023-08-16 18:07:49.78 spid33s Starting up database 'msdb'.
2023-08-16 18:07:49.78 spid35s Starting up database 'xxxxxxxxxxxx'.
2023-08-16 18:07:49.78 spid38s Starting up database 'xxxxxxxxxxxx'.
2023-08-16 18:07:49.78 spid36s Starting up database 'xxxxxxxxxxxx'.
2023-08-16 18:07:49.80 spid11s Starting up database 'mssqlsystemresource'.
2023-08-16 18:07:49.82 spid42s Starting up database 'ReportServer'.
2023-08-16 18:07:49.85 spid41s Starting up database 'xxxxxxxxxxxx'..
2023-08-16 18:07:49.97 spid11s The resource database build version is 15.00.4322. This is an informational message only. No user action is required.
2023-08-16 18:07:50.04 spid32s A self-generated certificate was successfully loaded for encryption.
2023-08-16 18:07:50.04 spid32s Server is listening on [ 'any' <ipv6> 1433].
2023-08-16 18:07:50.04 spid32s Server is listening on [ 'any' <ipv4> 1433].
2023-08-16 18:07:50.04 spid32s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2023-08-16 18:07:50.04 spid32s Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2023-08-16 18:07:50.08 Server Server is listening on [ ::1 <ipv6> 1434].
2023-08-16 18:07:50.11 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2023-08-16 18:07:50.11 Server Dedicated admin connection support was established for listening locally on port 1434.
2023-08-16 18:07:50.12 spid11s Starting up database 'model'.
2023-08-16 18:07:50.15 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.
2023-08-16 18:07:50.30 Logon Error: 18401, Severity: 14, State: 1.
2023-08-16 18:07:50.30 Logon Login failed for user 'xxxxxxxxxxxx'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 10.94.153.130]
2023-08-16 18:07:50.54 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/xxxxxxxxxxxx.CMTR.BR.CORP1.xxxxxxxxxxxx ] for the SQL Server service. Windows return code: 0x2098, state: 15. 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.
2023-08-16 18:07:50.54 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/xxxxxxxxxxxx.resource.ca.corp.xxxxxxxxxxxx:1433 ] for the SQL Server service. Windows return code: 0x2098, state: 15. 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.
2023-08-16 18:07:50.66 Logon Error: 18401, Severity: 14, State: 1.
2023-08-16 18:07:50.66 Logon Login failed for user 'xxxxxxxxxxxx'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 10.94.153.130]
2023-08-16 18:07:51.23 spid11s CHECKDB for database 'model' finished without errors on 2023-08-16 00:00:10.447 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:51.23 spid11s Clearing tempdb database.
2023-08-16 18:07:51.23 spid33s 24 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.25 spid40s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.25 spid39s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.26 spid40s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (9:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.26 spid39s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (8:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.27 spid53s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.28 spid43s Parallel redo is started for database 'ReportServerTempDB' with worker pool size [3].
2023-08-16 18:07:51.28 spid44s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.33 spid9s 0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.34 spid53s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (20:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.35 spid9s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2023-08-16 18:07:51.36 spid36s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.37 spid41s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.42 spid43s 6 transactions rolled forward in database 'ReportServerTempDB' (12:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.44 spid54s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.45 spid46s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.48 spid44s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (13:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.50 spid55s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.51 spid47s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.54 spid38s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.55 spid36s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (6:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.55 spid48s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.55 spid38s 7 transactions rolled forward in database 'xxxxxxxxxxxx' (7:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.56 spid33s CHECKDB for database 'msdb' finished without errors on 2023-08-16 00:00:12.817 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:51.58 spid41s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (10:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.59 spid33s 0 transactions rolled back in database 'xxxxxxxxxxxx' (8:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.59 spid9s 0 transactions rolled back in database 'xxxxxxxxxxxx' (9:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.60 spid54s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (21:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.60 spid33s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.61 spid9s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.62 spid40s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:00:11.167 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:51.65 spid39s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:11:07.147 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:51.65 spid40s 0 transactions rolled back in database 'xxxxxxxxxxxx' (6:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.65 spid39s 0 transactions rolled back in database 'xxxxxxxxxxxx' (7:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.66 spid40s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.67 spid39s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.67 spid40s 0 transactions rolled back in database 'xxxxxxxxxxxx' (10:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.69 spid40s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.72 spid50s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.76 spid50s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (18:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.77 spid55s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (22:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.77 spid48s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (16:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.78 spid47s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (15:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.81 spid51s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.81 spid46s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (14:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.83 spid9s 0 transactions rolled back in database 'xxxxxxxxxxxx' (20:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.85 spid9s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.85 spid51s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (19:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.94 spid49s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:51.95 spid9s 0 transactions rolled back in database 'xxxxxxxxxxxx' (18:0). This is an informational message only. No user action is required.
2023-08-16 18:07:51.99 spid9s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.03 spid11s Starting up database 'tempdb'.
2023-08-16 18:07:52.05 spid41s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:11:08.267 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.05 spid36s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:10:10.423 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.06 spid38s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:10:11.700 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.06 spid36s 0 transactions rolled back in database 'ReportServerTempDB' (12:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.06 spid41s 0 transactions rolled back in database 'xxxxxxxxxxxx' (13:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.07 spid38s 0 transactions rolled back in database 'xxxxxxxxxxxx' (21:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.08 spid36s Parallel redo is shutdown for database 'ReportServerTempDB' with worker pool size [3].
2023-08-16 18:07:52.09 spid41s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.09 spid36s 0 transactions rolled back in database 'xxxxxxxxxxxx' (19:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.10 spid38s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.11 spid38s 0 transactions rolled back in database 'xxxxxxxxxxxx' (22:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.13 spid36s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.14 spid36s 0 transactions rolled back in database 'xxxxxxxxxxxx' (16:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.14 spid51s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:09:46.113 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.14 spid49s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (17:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.15 spid38s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.15 spid36s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.15 spid50s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:08:33.833 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.17 spid35s Parallel redo is started for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.20 spid35s 6 transactions rolled forward in database 'xxxxxxxxxxxx' (5:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.24 spid9s 0 transactions rolled back in database 'xxxxxxxxxxxx' (15:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.25 spid9s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.32 spid35s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:00:15.970 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.32 spid35s 0 transactions rolled back in database 'xxxxxxxxxxxx' (14:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.35 spid35s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.35 spid9s 0 transactions rolled back in database 'xxxxxxxxxxxx' (5:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.35 spid43s CHECKDB for database 'ReportServerTempDB' finished without errors on 2023-08-16 00:11:04.923 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.35 spid54s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:11:06.030 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.36 spid9s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.37 spid53s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:10:38.790 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.39 spid53s 0 transactions rolled back in database 'xxxxxxxxxxxx' (17:0). This is an informational message only. No user action is required.
2023-08-16 18:07:52.40 spid44s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:00:05.130 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.40 spid48s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:10:40.053 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.40 spid55s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:00:08.137 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.40 spid47s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:10:08.470 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.43 spid53s Parallel redo is shutdown for database 'xxxxxxxxxxxx' with worker pool size [3].
2023-08-16 18:07:52.53 spid49s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:10:37.290 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:52.56 spid46s CHECKDB for database 'xxxxxxxxxxxx' finished without errors on 2023-08-16 00:09:52.030 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:53.03 spid11s The tempdb database has 6 data file(s).
2023-08-16 18:07:53.03 spid33s The Service Broker endpoint is in disabled or stopped state.
2023-08-16 18:07:53.03 spid33s The Database Mirroring endpoint is in disabled or stopped state.
2023-08-16 18:07:53.06 spid33s Service Broker manager has started.
2023-08-16 18:07:54.77 spid42s Parallel redo is started for database 'ReportServer' with worker pool size [3].
2023-08-16 18:07:54.79 spid42s 6 transactions rolled forward in database 'ReportServer' (11:0). This is an informational message only. No user action is required.
2023-08-16 18:07:54.93 spid9s 0 transactions rolled back in database 'ReportServer' (11:0). This is an informational message only. No user action is required.
2023-08-16 18:07:54.94 spid9s Parallel redo is shutdown for database 'ReportServer' with worker pool size [3].
2023-08-16 18:07:54.94 spid42s CHECKDB for database 'ReportServer' finished without errors on 2023-08-16 00:10:41.537 (local time). This is an informational message only; no user action is required.
2023-08-16 18:07:55.88 spid9s Database 'master' is upgrading script 'msdb110_upgrade.sql' from level 251662552 to level 251662562.
2023-08-16 18:07:55.88 spid9s ----------------------------------
2023-08-16 18:07:55.88 spid9s Starting execution of PRE_MSDB.SQL
2023-08-16 18:07:55.88 spid9s ----------------------------------
2023-08-16 18:07:55.90 Logon Error: 18401, Severity: 14, State: 1.
2023-08-16 18:07:55.90 Logon Login failed for user 'xxxxxxxxxxxx'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 10.94.153.130]
2023-08-16 18:07:56.02 Logon Error: 18401, Severity: 14, State: 1.
2023-08-16 18:07:56.02 Logon Login failed for user 'xxxxxxxxxxxx'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 10.94.153.130]
2023-08-16 18:07:56.09 spid9s Setting database option COMPATIBILITY_LEVEL to 100 for database 'msdb'.
2023-08-16 18:07:56.15 spid9s -----------------------------------------
2023-08-16 18:07:56.15 spid9s Starting execution of PRE_SQLAGENT100.SQL
2023-08-16 18:07:56.15 spid9s -----------------------------------------
2023-08-16 18:07:56.16 spid9s Setting database option COMPATIBILITY_LEVEL to 150 for database 'msdb'.
2023-08-16 18:08:00.97 Logon Error: 18401, Severity: 14, State: 1.
2023-08-16 18:08:00.97 Logon Login failed for user 'xxxxxxxxxxxx'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 10.94.153.130]
2023-08-16 18:08:01.25 spid9s Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2023-08-16 18:08:01.44 spid9s Using 'xpstar.dll' version '2019.150.4322' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2023-08-16 18:08:01.49 spid9s DBCC TRACEOFF 1717, server process ID (SPID) 9. This is an informational message only; no user action is required.
2023-08-16 18:08:01.49 spid9s DBCC execution completed. If DBCC printed error messages, contact your system administrator.
2023-08-16 18:08:01.50 spid9s
2023-08-16 18:08:01.50 spid9s Creating table temp_sysjobschedules
2023-08-16 18:08:01.65 spid9s
2023-08-16 18:08:01.65 spid9s Alter table sysdownloadlist...
2023-08-16 18:08:01.66 spid9s
2023-08-16 18:08:01.66 spid9s Alter table sysjobhistory...
2023-08-16 18:08:02.13 spid9s
2023-08-16 18:08:02.13 spid9s Alter table systargetservers...
2023-08-16 18:08:02.22 spid9s
2023-08-16 18:08:02.22 spid9s Alter table sysjobsteps...
2023-08-16 18:08:03.19 spid9s
2023-08-16 18:08:03.19 spid9s -----------------------------------------
2023-08-16 18:08:03.19 spid9s Execution of PRE_SQLAGENT100.SQL complete
2023-08-16 18:08:03.19 spid9s -----------------------------------------
2023-08-16 18:08:03.20 spid9s DMF pre-upgrade steps...
2023-08-16 18:08:04.11 spid9s DC pre-upgrade steps...
2023-08-16 18:08:04.11 spid9s Check if Data collector config table exists...
2023-08-16 18:08:04.11 spid9s Data Collector state before upgrade: 0
2023-08-16 18:08:04.11 spid9s pre_dc100::Check if syscollector_collection_sets_internal table exists...
2023-08-16 18:08:04.11 spid9s pre_dc100::Capturing Collection set status in temp table...
2023-08-16 18:08:04.78 spid9s Deleting cached auto-generated T-SQL Data Collection packages from msdb...
2023-08-16 18:08:04.78 spid9s End of DC pre-upgrade steps.
2023-08-16 18:08:04.78 spid9s DAC pre-upgrade steps...
2023-08-16 18:08:04.79 spid9s Starting DAC pre-upgrade steps ...
2023-08-16 18:08:04.79 spid9s End of DAC pre-upgrade steps.
2023-08-16 18:08:04.79 spid9s ----------------------------------
2023-08-16 18:08:04.79 spid9s Starting execution of MSDB.SQL
2023-08-16 18:08:04.79 spid9s ----------------------------------
2023-08-16 18:08:05.13 spid9s Checking the size of MSDB...
2023-08-16 18:08:05.60 spid9s
2023-08-16 18:08:05.60 spid9s Setting database option TRUSTWORTHY to ON for database 'msdb'.
2023-08-16 18:08:05.83 spid9s Setting database option RECOVERY to SIMPLE for database 'msdb'.
2023-08-16 18:08:05.96 spid9s ----------------------------------
2023-08-16 18:08:05.96 spid9s Finished execution of MSDB.SQL
2023-08-16 18:08:05.96 spid9s ----------------------------------
2023-08-16 18:08:05.96 spid9s -----------------------------------------
2023-08-16 18:08:05.96 spid9s Starting execution of MSDB_VERSIONING.SQL
2023-08-16 18:08:05.96 spid9s -----------------------------------------
2023-08-16 18:08:06.04 spid9s -----------------------------------------
2023-08-16 18:08:06.04 spid9s Finished execution of MSDB_VERSIONING.SQL
2023-08-16 18:08:06.04 spid9s -----------------------------------------
2023-08-16 18:08:06.21 spid9s
2023-08-16 18:08:06.21 spid9s Creating procedure sp_agent_add_job...
2023-08-16 18:08:06.28 spid9s
2023-08-16 18:08:06.28 spid9s Creating procedure sp_agent_delete_job...
2023-08-16 18:08:06.30 spid9s
2023-08-16 18:08:06.30 spid9s Creating procedure sp_agent_add_jobstep...
2023-08-16 18:08:06.31 spid9s
2023-08-16 18:08:06.31 spid9s Creating procedure sp_agent_start_job...
2023-08-16 18:08:06.32 spid9s
2023-08-16 18:08:06.32 spid9s Creating procedure sp_agent_get_jobstep...
2023-08-16 18:08:06.35 spid9s
2023-08-16 18:08:06.35 spid9s Creating procedure sp_agent_log_job_history...
2023-08-16 18:08:06.38 spid9s
2023-08-16 18:08:06.38 spid9s Creating procedure sp_agent_write_sysjobstep_log...
2023-08-16 18:08:06.39 spid9s
2023-08-16 18:08:06.39 spid9s Creating table syssubsystems...
2023-08-16 18:08:06.41 spid9s
2023-08-16 18:08:06.41 spid9s Creating view sysproxyloginsubsystem_view...
2023-08-16 18:08:06.45 spid9s
2023-08-16 18:08:06.45 spid9s Creating trigger trig_sysoriginatingservers_delete...
2023-08-16 18:08:06.46 spid9s
2023-08-16 18:08:06.46 spid9s Creating view sysoriginatingservers_view...
2023-08-16 18:08:06.49 spid9s
2023-08-16 18:08:06.49 spid9s Creating trigger trig_sysjobs_insert_update...
2023-08-16 18:08:06.50 spid9s
2023-08-16 18:08:06.50 spid9s Creating view sysjobs_view...
2023-08-16 18:08:06.57 spid9s
2023-08-16 18:08:06.57 spid9s Creating trigger trig_sysschedules_insert_update...
2023-08-16 18:08:06.58 spid9s
2023-08-16 18:08:06.58 spid9s Creating view sysschedules_localserver_view...
2023-08-16 18:08:06.72 spid9s
2023-08-16 18:08:06.72 spid9s Creating view systargetservers_view...
2023-08-16 18:08:06.74 spid9s
2023-08-16 18:08:06.74 spid9s Creating view sysalerts_performance_counters_view...
2023-08-16 18:08:06.77 spid9s
2023-08-16 18:08:06.77 spid9s Creating function SQLAGENT_SUSER_SNAME ...
2023-08-16 18:08:06.77 spid9s
2023-08-16 18:08:06.77 spid9s Creating function SQLAGENT_SUSER_SID ...
2023-08-16 18:08:06.80 spid9s
2023-08-16 18:08:06.80 spid9s Creating procedure SP_SQLAGENT_IS_SRVROLEMEMBER...
2023-08-16 18:08:06.80 spid9s
2023-08-16 18:08:06.80 spid9s Creating procedure sp_get_traceflag_status_internal...
2023-08-16 18:08:06.82 spid9s
2023-08-16 18:08:06.82 spid9s Creating procedure sp_verify_category_identifiers...
2023-08-16 18:08:06.83 spid9s
2023-08-16 18:08:06.83 spid9s Creating function agent_datetime...
2023-08-16 18:08:06.83 spid9s
2023-08-16 18:08:06.83 spid9s Creating procedure sp_verify_proxy_identifiers...
2023-08-16 18:08:06.84 spid9s
2023-08-16 18:08:06.84 spid9s Creating procedure sp_verify_credential_identifiers...
2023-08-16 18:08:06.85 spid9s
2023-08-16 18:08:06.85 spid9s Creating procedure sp_verify_subsystems...
2023-08-16 18:08:06.92 spid9s
2023-08-16 18:08:06.92 spid9s Creating procedure sp_verify_subsystem_identifiers...
2023-08-16 18:08:06.93 spid9s
2023-08-16 18:08:06.93 spid9s Creating procedure sp_verify_login_identifiers...
2023-08-16 18:08:06.94 spid9s
2023-08-16 18:08:06.94 spid9s Creating procedure sp_verify_proxy...
2023-08-16 18:08:06.95 spid9s
2023-08-16 18:08:06.95 spid9s Creating procedure sp_add_proxy...
2023-08-16 18:08:06.97 spid9s
2023-08-16 18:08:06.97 spid9s Creating procedure sp_delete_proxy...
2023-08-16 18:08:06.98 spid9s
2023-08-16 18:08:06.98 spid9s Creating procedure sp_update_proxy...
2023-08-16 18:08:07.02 spid9s
2023-08-16 18:08:07.02 spid9s Creating procedure sp_sqlagent_is_member...
2023-08-16 18:08:07.02 spid9s
2023-08-16 18:08:07.02 spid9s Creating procedure sp_verify_proxy_permissions...
2023-08-16 18:08:07.03 spid9s
2023-08-16 18:08:07.03 spid9s Creating procedure sp_help_proxy...
2023-08-16 18:08:07.04 spid9s
2023-08-16 18:08:07.04 spid9s Creating procedure sp_get_proxy_properties...
2023-08-16 18:08:07.07 spid9s
2023-08-16 18:08:07.07 spid9s Creating procedure sp_grant_proxy_to_subsystem...
2023-08-16 18:08:07.07 spid9s
2023-08-16 18:08:07.07 spid9s Creating procedure sp_grant_login_to_proxy...
2023-08-16 18:08:07.08 spid9s
2023-08-16 18:08:07.08 spid9s Creating procedure sp_revoke_login_from_proxy...
2023-08-16 18:08:07.09 spid9s
2023-08-16 18:08:07.09 spid9s Creating procedure sp_revoke_proxy_from_subsystem...
2023-08-16 18:08:07.09 spid9s
2023-08-16 18:08:07.09 spid9s Creating procedure sp_enum_proxy_for_subsystem...
2023-08-16 18:08:07.10 spid9s
2023-08-16 18:08:07.10 spid9s Creating procedure sp_enum_login_for_proxy...
2023-08-16 18:08:07.10 spid9s
2023-08-16 18:08:07.10 spid9s Creating procedure sp_reassign_proxy...
2023-08-16 18:08:07.11 spid9s
2023-08-16 18:08:07.11 spid9s Creating procedure sp_sqlagent_get_startup_info...
2023-08-16 18:08:07.12 spid9s
2023-08-16 18:08:07.12 spid9s Creating procedure sp_sqlagent_update_agent_xps...
2023-08-16 18:08:07.13 spid9s
2023-08-16 18:08:07.13 spid9s Creating procedure sp_sqlagent_has_server_access...
2023-08-16 18:08:07.19 spid9s
2023-08-16 18:08:07.19 spid9s Creating procedure sp_sqlagent_get_perf_counters...
2023-08-16 18:08:07.21 spid9s
2023-08-16 18:08:07.21 spid9s Creating procedure sp_sqlagent_notify...
2023-08-16 18:08:07.23 spid9s
2023-08-16 18:08:07.23 spid9s Creating procedure sp_is_sqlagent_starting...
2023-08-16 18:08:07.24 spid9s
2023-08-16 18:08:07.24 spid9s Creating procedure sp_verify_job_identifiers...
2023-08-16 18:08:07.24 spid9s
2023-08-16 18:08:07.24 spid9s Creating procedure sp_verify_schedule_identifiers...
2023-08-16 18:08:07.26 spid9s
2023-08-16 18:08:07.26 spid9s Creating procedure sp_verify_jobproc_caller...
2023-08-16 18:08:07.26 spid9s
2023-08-16 18:08:07.26 spid9s Creating procedure sp_downloaded_row_limiter...
2023-08-16 18:08:07.28 spid9s
2023-08-16 18:08:07.28 spid9s Creating procedure sp_post_msx_operation...
2023-08-16 18:08:07.30 spid9s
2023-08-16 18:08:07.30 spid9s Creating procedure sp_verify_performance_condition...
2023-08-16 18:08:07.31 spid9s
2023-08-16 18:08:07.31 spid9s Creating procedure sp_verify_job_date...
2023-08-16 18:08:07.32 spid9s
2023-08-16 18:08:07.32 spid9s Creating procedure sp_verify_job_time...
2023-08-16 18:08:07.34 spid9s
2023-08-16 18:08:07.34 spid9s Creating procedure sp_verify_alert...
2023-08-16 18:08:07.35 spid9s
2023-08-16 18:08:07.35 spid9s Creating procedure sp_update_alert...
2023-08-16 18:08:07.37 spid9s
2023-08-16 18:08:07.37 spid9s Creating procedure sp_delete_job_references...
2023-08-16 18:08:07.38 spid9s
2023-08-16 18:08:07.38 spid9s Creating procedure sp_delete_all_msx_jobs...
2023-08-16 18:08:07.39 spid9s
2023-08-16 18:08:07.39 spid9s Creating procedure sp_generate_target_server_job_assignment_sql...
2023-08-16 18:08:07.40 spid9s
2023-08-16 18:08:07.40 spid9s Creating procedure sp_generate_server_description...
2023-08-16 18:08:07.41 spid9s
2023-08-16 18:08:07.41 spid9s Creating procedure sp_msx_set_account...
2023-08-16 18:08:07.41 spid9s
2023-08-16 18:08:07.41 spid9s Creating procedure sp_msx_get_account...
2023-08-16 18:08:07.41 spid9s
2023-08-16 18:08:07.41 spid9s Creating procedure sp_delete_operator...
2023-08-16 18:08:07.42 spid9s
2023-08-16 18:08:07.42 spid9s Creating procedure sp_msx_defect...
2023-08-16 18:08:07.43 spid9s
2023-08-16 18:08:07.43 spid9s Creating procedure sp_msx_enlist...
2023-08-16 18:08:07.43 spid9s
2023-08-16 18:08:07.43 spid9s Creating procedure sp_delete_targetserver...
2023-08-16 18:08:07.44 spid9s
2023-08-16 18:08:07.44 spid9s Creating procedure sp_enlist_tsx
2023-08-16 18:08:07.45 spid9s
2023-08-16 18:08:07.45 spid9s Creating procedure sp_get_sqlagent_properties...
2023-08-16 18:08:07.47 spid9s
2023-08-16 18:08:07.47 spid9s Create procedure sp_set_sqlagent_properties...
2023-08-16 18:08:07.48 spid9s
2023-08-16 18:08:07.48 spid9s Creating procedure sp_add_targetservergroup...
2023-08-16 18:08:07.50 spid9s
2023-08-16 18:08:07.50 spid9s Creating procedure sp_update_targetservergroup...
2023-08-16 18:08:07.51 spid9s
2023-08-16 18:08:07.51 spid9s Creating procedure sp_delete_targetservergroup...
2023-08-16 18:08:07.51 spid9s
2023-08-16 18:08:07.51 spid9s Creating procedure sp_help_targetservergroup...
2023-08-16 18:08:07.53 spid9s
2023-08-16 18:08:07.53 spid9s Creating procedure sp_add_targetsvgrp_member...
2023-08-16 18:08:07.54 spid9s
2023-08-16 18:08:07.54 spid9s Creating procedure sp_delete_targetsvrgrp_member...
2023-08-16 18:08:07.54 spid9s
2023-08-16 18:08:07.54 spid9s Creating procedure sp_verify_category...
2023-08-16 18:08:07.55 spid9s
2023-08-16 18:08:07.55 spid9s Creating procedure sp_add_category...
2023-08-16 18:08:07.56 spid9s
2023-08-16 18:08:07.56 spid9s Creating procedure sp_update_category...
2023-08-16 18:08:07.57 spid9s
2023-08-16 18:08:07.57 spid9s Creating procedure sp_delete_category...
2023-08-16 18:08:07.57 spid9s
2023-08-16 18:08:07.57 spid9s Creating procedure sp_help_category...
2023-08-16 18:08:07.58 spid9s
2023-08-16 18:08:07.58 spid9s Creating procedure sp_help_targetserver...
2023-08-16 18:08:07.59 spid9s
2023-08-16 18:08:07.59 spid9s Creating procedure sp_resync_targetserver...
2023-08-16 18:08:07.63 spid9s
2023-08-16 18:08:07.63 spid9s Creating procedure sp_purge_jobhistory...
2023-08-16 18:08:07.65 spid9s
2023-08-16 18:08:07.65 spid9s Creating procedure sp_help_jobhistory...
2023-08-16 18:08:07.66 spid9s
2023-08-16 18:08:07.66 spid9s Creating procedure sp_add_jobserver...
2023-08-16 18:08:07.67 spid9s
2023-08-16 18:08:07.67 spid9s Creating procedure sp_delete_jobserver...
2023-08-16 18:08:07.67 spid9s
2023-08-16 18:08:07.67 spid9s Creating procedure sp_help_jobserver...
2023-08-16 18:08:07.68 spid9s
2023-08-16 18:08:07.68 spid9s Creating procedure sp_help_downloadlist...
2023-08-16 18:08:07.69 spid9s
2023-08-16 18:08:07.69 spid9s Creating procedure sp_enum_sqlagent_subsystems_internal...
2023-08-16 18:08:07.69 spid9s
2023-08-16 18:08:07.69 spid9s Creating procedure sp_enum_sqlagent_subsystems...
2023-08-16 18:08:07.70 spid9s
2023-08-16 18:08:07.70 spid9s Creating procedure sp_verify_subsystem...
2023-08-16 18:08:07.70 spid9s
2023-08-16 18:08:07.70 spid9s Creating procedure sp_verify_schedule...
2023-08-16 18:08:07.72 spid9s
2023-08-16 18:08:07.72 spid9s Creating procedure sp_add_schedule...
2023-08-16 18:08:07.73 spid9s
2023-08-16 18:08:07.73 spid9s Creating procedure sp_attach_schedule ...
2023-08-16 18:08:07.74 spid9s
2023-08-16 18:08:07.74 spid9s Creating procedure sp_detach_schedule ...
2023-08-16 18:08:07.75 spid9s
2023-08-16 18:08:07.75 spid9s Creating procedure sp_update_replication_job_parameter...
2023-08-16 18:08:07.75 spid9s
2023-08-16 18:08:07.75 spid9s Creating procedure sp_update_schedule ...
2023-08-16 18:08:07.76 spid9s
2023-08-16 18:08:07.76 spid9s Creating procedure sp_delete_schedule ...
2023-08-16 18:08:07.77 spid9s
2023-08-16 18:08:07.77 spid9s Creating procedure sp_get_jobstep_db_username...
2023-08-16 18:08:07.78 spid9s
2023-08-16 18:08:07.78 spid9s Creating procedure sp_verify_jobstep...
2023-08-16 18:08:07.79 spid9s
2023-08-16 18:08:07.79 spid9s Creating procedure sp_add_jobstep_internal...
2023-08-16 18:08:07.80 spid9s
2023-08-16 18:08:07.80 spid9s Creating procedure sp_add_jobstep...
2023-08-16 18:08:07.81 spid9s
2023-08-16 18:08:07.81 spid9s Creating procedure sp_update_jobstep...
2023-08-16 18:08:07.82 spid9s
2023-08-16 18:08:07.82 spid9s Creating procedure sp_delete_jobstep...
2023-08-16 18:08:07.83 spid9s
2023-08-16 18:08:07.83 spid9s Creating procedure sp_help_jobstep...
2023-08-16 18:08:07.83 spid9s
2023-08-16 18:08:07.83 spid9s Creating procedure sp_write_sysjobstep_log...
2023-08-16 18:08:07.84 spid9s
2023-08-16 18:08:07.84 spid9s Creating procedure sp_help_jobsteplog...
2023-08-16 18:08:07.84 spid9s
2023-08-16 18:08:07.84 spid9s Creating procedure sp_delete_jobsteplog...
2023-08-16 18:08:07.85 spid9s
2023-08-16 18:08:07.85 spid9s Creating procedure sp_get_schedule_description...
2023-08-16 18:08:07.87 spid9s
2023-08-16 18:08:07.87 spid9s Creating procedure sp_add_jobschedule...
2023-08-16 18:08:07.88 spid9s
2023-08-16 18:08:07.88 spid9s Creating procedure sp_update_jobschedule...
2023-08-16 18:08:07.90 spid9s
2023-08-16 18:08:07.90 spid9s Creating procedure sp_delete_jobschedule...
2023-08-16 18:08:07.91 spid9s
2023-08-16 18:08:07.92 spid9s Creating procedure sp_help_schedule...
2023-08-16 18:08:07.93 spid9s
2023-08-16 18:08:07.93 spid9s Creating procedure sp_help_jobschedule...
2023-08-16 18:08:07.96 spid9s
2023-08-16 18:08:07.96 spid9s Creating procedure sp_verify_job...
2023-08-16 18:08:07.99 spid9s
2023-08-16 18:08:07.99 spid9s Creating procedure sp_add_job...
2023-08-16 18:08:07.99 spid9s
2023-08-16 18:08:07.99 spid9s Creating procedure sp_update_job...
2023-08-16 18:08:08.02 spid9s
2023-08-16 18:08:08.02 spid9s Creating procedure sp_delete_job...
2023-08-16 18:08:08.04 spid9s
2023-08-16 18:08:08.04 spid9s Creating procedure sp_get_composite_job_info...
2023-08-16 18:08:08.06 spid9s
2023-08-16 18:08:08.06 spid9s Creating procedure sp_help_job...
2023-08-16 18:08:08.09 spid9s
2023-08-16 18:08:08.09 spid9s Creating procedure sp_help_jobcount...
2023-08-16 18:08:08.09 spid9s
2023-08-16 18:08:08.09 spid9s Creating procedure sp_help_jobs_in_schedule...
2023-08-16 18:08:08.09 spid9s
2023-08-16 18:08:08.09 spid9s Creating procedure sp_manage_jobs_by_login...
2023-08-16 18:08:08.10 spid9s
2023-08-16 18:08:08.10 spid9s Creating procedure sp_apply_job_to_targets...
2023-08-16 18:08:08.12 spid9s
2023-08-16 18:08:08.12 spid9s Creating procedure sp_remove_job_from_targets...
2023-08-16 18:08:08.13 spid9s
2023-08-16 18:08:08.13 spid9s Creating procedure sp_get_job_alerts...
2023-08-16 18:08:08.13 spid9s
2023-08-16 18:08:08.13 spid9s Creating procedure sp_start_job...
2023-08-16 18:08:08.14 spid9s
2023-08-16 18:08:08.14 spid9s Creating procedure sp_stop_job...
2023-08-16 18:08:08.15 spid9s
2023-08-16 18:08:08.15 spid9s Creating procedure sp_cycle_agent_errorlog...
2023-08-16 18:08:08.15 spid9s
2023-08-16 18:08:08.15 spid9s Creating procedure sp_get_chunked_jobstep_params...
2023-08-16 18:08:08.15 spid9s
2023-08-16 18:08:08.15 spid9s Creating procedure sp_check_for_owned_jobs...
2023-08-16 18:08:08.16 spid9s
2023-08-16 18:08:08.16 spid9s Creating procedure sp_check_for_owned_jobsteps...
2023-08-16 18:08:08.16 spid9s
2023-08-16 18:08:08.16 spid9s Creating procedure sp_sqlagent_refresh_job...
2023-08-16 18:08:08.17 spid9s
2023-08-16 18:08:08.17 spid9s Creating procedure sp_jobhistory_row_limiter...
2023-08-16 18:08:08.17 spid9s
2023-08-16 18:08:08.17 spid9s Creating procedure [dbo].[sp_sqlagent_set_job_completion_state]...
2023-08-16 18:08:08.17 spid9s
2023-08-16 18:08:08.17 spid9s Creating procedure [dbo].[sp_sqlagent_set_jobstep_completion_state]...
2023-08-16 18:08:08.18 spid9s
2023-08-16 18:08:08.18 spid9s Creating procedure [dbo].[sp_sqlagent_create_jobactivity]...
2023-08-16 18:08:08.18 spid9s
2023-08-16 18:08:08.18 spid9s Creating procedure [dbo].[sp_sqlagent_update_jobactivity_next_scheduled_date]...
2023-08-16 18:08:08.18 spid9s
2023-08-16 18:08:08.18 spid9s Creating procedure [dbo].[sp_sqlagent_update_jobactivity_requested_date]...
2023-08-16 18:08:08.19 spid9s
2023-08-16 18:08:08.19 spid9s Creating procedure [dbo].[sp_sqlagent_update_jobactivity_queued_date]...
2023-08-16 18:08:08.19 spid9s
2023-08-16 18:08:08.19 spid9s Creating procedure [dbo].[sp_sqlagent_update_jobactivity_start_execution_date]...
2023-08-16 18:08:08.20 spid9s
2023-08-16 18:08:08.20 spid9s Creating procedure sp_sqlagent_log_jobhistory...
2023-08-16 18:08:08.21 spid9s
2023-08-16 18:08:08.21 spid9s Creating procedure sp_sqlagent_check_msx_version...
2023-08-16 18:08:08.22 spid9s
2023-08-16 18:08:08.22 spid9s Creating procedure sp_sqlagent_probe_msx...
2023-08-16 18:08:08.22 spid9s
2023-08-16 18:08:08.22 spid9s Creating procedure sp_set_local_time...
2023-08-16 18:08:08.23 spid9s
2023-08-16 18:08:08.23 spid9s Creating procedure sp_multi_server_job_summary...
2023-08-16 18:08:08.23 spid9s
2023-08-16 18:08:08.23 spid9s Creating procedure sp_target_server_summary...
2023-08-16 18:08:08.26 spid9s
2023-08-16 18:08:08.26 spid9s Creating [legacy] procedure sp_uniquetaskname...
2023-08-16 18:08:08.26 spid9s
2023-08-16 18:08:08.26 spid9s Creating [legacy] procedure sp_addtask...
2023-08-16 18:08:08.27 spid9s
2023-08-16 18:08:08.27 spid9s Creating [legacy] procedure sp_droptask...
2023-08-16 18:08:08.28 spid9s
2023-08-16 18:08:08.28 spid9s Creating trigger trig_targetserver_insert...
2023-08-16 18:08:08.30 spid9s
2023-08-16 18:08:08.30 spid9s Creating procedure sp_add_alert_internal...
2023-08-16 18:08:08.31 spid9s
2023-08-16 18:08:08.31 spid9s Creating procedure sp_add_alert...
2023-08-16 18:08:08.31 spid9s
2023-08-16 18:08:08.31 spid9s Creating procedure sp_delete_alert...
2023-08-16 18:08:08.32 spid9s
2023-08-16 18:08:08.32 spid9s Creating procedure sp_help_alert...
2023-08-16 18:08:08.33 spid9s
2023-08-16 18:08:08.33 spid9s Creating procedure sp_verify_operator...
2023-08-16 18:08:08.33 spid9s
2023-08-16 18:08:08.33 spid9s Creating procedure sp_add_operator...
2023-08-16 18:08:08.34 spid9s
2023-08-16 18:08:08.34 spid9s Creating procedure sp_update_operator...
2023-08-16 18:08:08.35 spid9s
2023-08-16 18:08:08.35 spid9s Creating procedure sp_help_operator...
2023-08-16 18:08:08.35 spid9s
2023-08-16 18:08:08.35 spid9s Creating procedure sp_help_operator_jobs...
2023-08-16 18:08:08.35 spid9s
2023-08-16 18:08:08.35 spid9s Creating procedure sp_verify_operator_identifiers...
2023-08-16 18:08:08.36 spid9s
2023-08-16 18:08:08.36 spid9s Creating procedure sp_notify_operator...
2023-08-16 18:08:08.37 spid9s
2023-08-16 18:08:08.37 spid9s Creating procedure sp_verify_notification...
2023-08-16 18:08:08.38 spid9s
2023-08-16 18:08:08.38 spid9s Creating procedure sp_add_notification...
2023-08-16 18:08:08.39 spid9s
2023-08-16 18:08:08.39 spid9s Creating procedure sp_update_notification...
2023-08-16 18:08:08.40 spid9s
2023-08-16 18:08:08.40 spid9s Creating procedure sp_delete_notification...
2023-08-16 18:08:08.41 spid9s
2023-08-16 18:08:08.41 spid9s Creating procedure sp_help_notification...
2023-08-16 18:08:08.42 spid9s
2023-08-16 18:08:08.42 spid9s Creating procedure sp_help_jobactivity...
2023-08-16 18:08:08.44 spid9s
2023-08-16 18:08:08.44 spid9s Creating trigger trig_notification_ins_or_upd...
2023-08-16 18:08:08.45 spid9s
2023-08-16 18:08:08.45 spid9s Creating trigger trig_notification_delete...
2023-08-16 18:08:08.46 spid9s
2023-08-16 18:08:08.46 spid9s Setting object permissions...
2023-08-16 18:08:08.62 spid9s Error: 2714, Severity: 16, State: 6.
2023-08-16 18:08:08.62 spid9s There is already an object named 'TargetServersRole' in the database.
2023-08-16 18:08:08.62 spid9s Error: 2759, Severity: 16, State: 0.
2023-08-16 18:08:08.62 spid9s CREATE SCHEMA failed due to previous errors.
2023-08-16 18:08:08.62 spid9s Error: 912, Severity: 21, State: 2.
2023-08-16 18:08:08.62 spid9s Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 2714, state 6, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
2023-08-16 18:08:08.62 spid9s Error: 3417, Severity: 21, State: 3.
2023-08-16 18:08:08.62 spid9s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
2023-08-16 18:08:08.62 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. - M_RusuAug 23, 2023Copper ContributorYes, can you please send me the location of this file?
- Aug 23, 2023
see this article to find the location in your own installation
Viewing the SQL Server Error Log
Program Files\Microsoft SQL Server\MSSQL.
xx\MSSQL\LOG\ERRORLOG
- M_RusuAug 23, 2023Copper ContributorFound it and posted the log. Will take some time, Outlook reports "posting is in review by Microsoft"
Found this:
Error: 2714, Severity: 16, State: 6.
2023-08-16 18:08:08.62 spid9s There is already an object named 'TargetServersRole' in the database.
2023-08-16 18:08:08.62 spid9s Error: 2759, Severity: 16, State: 0.
2023-08-16 18:08:08.62 spid9s CREATE SCHEMA failed due to previous errors.
2023-08-16 18:08:08.62 spid9s Error: 912, Severity: 21, State: 2.
2023-08-16 18:08:08.62 spid9s Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 2714, state 6, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.