2025-06-19 19:51:19.35 Server Microsoft SQL Server 2022 (RTM-CU18) (KB5050771) - 16.0.4185.3 (X64) Feb 28 2025 18:24:49 Copyright (C) 2022 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 (Build 20348: ) (Hypervisor) 2025-06-19 19:51:19.35 Server UTC adjustment: -7:00 2025-06-19 19:51:19.35 Server (c) Microsoft Corporation. 2025-06-19 19:51:19.35 Server All rights reserved. 2025-06-19 19:51:19.35 Server Server process ID is 8272. 2025-06-19 19:51:19.35 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware20,1'. 2025-06-19 19:51:19.35 Server Authentication mode is MIXED. 2025-06-19 19:51:19.35 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2025-06-19 19:51:19.35 Server The service account is 'OXCITY\CITY-WIN-SQL05$'. This is an informational message; no user action is required. 2025-06-19 19:51:19.35 Server Registry startup parameters: -d C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2025-06-19 19:51:19.35 Server Command Line Startup Parameters: -s "MSSQLSERVER" -m "SqlSetup" -T 4022 -T 4010 -T 1905 -T 3701 -T 8015 2025-06-19 19:51:19.36 Server SQL Server detected 1 sockets with 2 cores per socket and 2 logical processors per socket, 2 total logical processors; using 2 logical processors based on SQL Server licensing. This is an informational message; no user action is required. 2025-06-19 19:51:19.36 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2025-06-19 19:51:19.36 Server Detected 32767 MB of RAM, 30111 MB of available memory, 35160 MB of available page file. This is an informational message; no user action is required. 2025-06-19 19:51:19.36 Server Using locked pages in the memory manager. 2025-06-19 19:51:19.36 Server Detected pause instruction latency: 40 cycles. 2025-06-19 19:51:19.36 Server SQL Server detected the following NUMA node configuration (NUMA Node number 0, Processor Group number 0, CPU Mask 0x0000000000000003). 2025-06-19 19:51:19.36 Server Page exclusion bitmap is enabled. 2025-06-19 19:51:19.41 Server Buffer Pool: Allocating 67108864 bytes for 4259840 hashPages. 2025-06-19 19:51:19.43 Server Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033) 2025-06-19 19:51:19.45 Server Buffer pool extension is already disabled. No action is necessary. 2025-06-19 19:51:19.48 Server CPU vectorization level(s) detected: SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX POPCNT 2025-06-19 19:51:19.49 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled. 2025-06-19 19:51:19.50 Server Query Store settings initialized with enabled = 1, 2025-06-19 19:51:19.50 Server The maximum number of dedicated administrator connections for this instance is '1' 2025-06-19 19:51:19.51 Server This instance of SQL Server last reported using a process ID of 4108 at 6/19/2025 7:51:18 PM (local) 6/20/2025 2:51:18 AM (UTC). This is an informational message only; no user action is required. 2025-06-19 19:51:19.51 Server Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 2025-06-19 19:51:19.57 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. 2025-06-19 19:51:19.58 Server In-Memory OLTP initialized on lowend machine. 2025-06-19 19:51:19.59 Server [INFO] Created Extended Events session 'hkenginexesession' 2025-06-19 19:51:19.59 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. 2025-06-19 19:51:19.60 Server Total Log Writer threads: 1. This is an informational message; no user action is required. 2025-06-19 19:51:19.61 Server Database Mirroring Transport is disabled in the endpoint configuration. 2025-06-19 19:51:19.61 Server clflush is selected for pmem flush operation. 2025-06-19 19:51:19.62 spid15s Warning ****************** 2025-06-19 19:51:19.62 spid15s SQL Server started in single-user mode. This an informational message only. No user action is required. 2025-06-19 19:51:19.62 Server CLR version v4.0.30319 loaded. 2025-06-19 19:51:19.62 spid15s Starting up database 'master'. 2025-06-19 19:51:19.67 spid15s 14 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required. 2025-06-19 19:51:19.67 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\. 2025-06-19 19:51:19.70 spid15s 0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required. 2025-06-19 19:51:19.70 spid15s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2025-06-19 19:51:19.76 Server Software Usage Metrics is enabled. 2025-06-19 19:51:19.80 spid15s CHECKDB for database 'master' finished without errors on 2024-11-23 20:00:03.173 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:19.81 spid15s Starting up database 'model_replicatedmaster'. 2025-06-19 19:51:20.21 spid20s A self-generated certificate was successfully loaded for encryption. 2025-06-19 19:51:20.22 spid20s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. 2025-06-19 19:51:20.26 spid20s Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required. 2025-06-19 19:51:20.26 spid16s Starting up database 'mssqlsystemresource'. 2025-06-19 19:51:20.26 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. 2025-06-19 19:51:20.29 spid16s The resource database build version is 16.00.4185. This is an informational message only. No user action is required. 2025-06-19 19:51:20.30 spid15s 1 transactions rolled forward in database 'model_replicatedmaster' (32762:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.31 spid15s 0 transactions rolled back in database 'model_replicatedmaster' (32762:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.32 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/city-win-SQL05.oxcity.local ] for the SQL Server service. 2025-06-19 19:51:20.32 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/city-win-SQL05.oxcity.local:1433 ] for the SQL Server service. 2025-06-19 19:51:20.32 spid15s Starting up database 'model_msdb'. 2025-06-19 19:51:20.35 spid16s Starting up database 'model'. 2025-06-19 19:51:20.35 spid15s 1 transactions rolled forward in database 'model_msdb' (32761:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.36 spid15s 0 transactions rolled back in database 'model_msdb' (32761:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.38 spid15s SQL Server Audit is starting the audits. This is an informational message. No user action is required. 2025-06-19 19:51:20.38 spid15s SQL Server Audit has started the audits. This is an informational message. No user action is required. 2025-06-19 19:51:20.40 spid16s CHECKDB for database 'model' finished without errors on 2024-11-23 20:00:04.013 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.41 spid15s SQL Trace ID 1 was started by login "sa". 2025-06-19 19:51:20.41 spid15s Server name is 'city-win-SQL05'. This is an informational message only. No user action is required. 2025-06-19 19:51:20.42 spid15s Always On Availability Groups was not started because the SQL Server instance is running in single-user mode. This is an informational message. No user action is required. 2025-06-19 19:51:20.43 spid16s Clearing tempdb database. 2025-06-19 19:51:20.43 spid25s Starting up database 'msdb'. 2025-06-19 19:51:20.43 spid27s Starting up database 'HTE'. 2025-06-19 19:51:20.43 spid30s Starting up database 'FireInspections'. 2025-06-19 19:51:20.43 spid31s Starting up database 'DistributionDB'. 2025-06-19 19:51:20.43 spid29s Starting up database 'ABC'. 2025-06-19 19:51:20.43 spid28s Starting up database 'FrontierData'. 2025-06-19 19:51:20.43 spid32s Starting up database 'ReportServerTempDB'. 2025-06-19 19:51:20.43 spid27s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [6] 2025-06-19 19:51:20.43 spid27s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 6. 2025-06-19 19:51:20.43 spid30s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [9] 2025-06-19 19:51:20.43 spid30s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 9. 2025-06-19 19:51:20.43 spid33s Starting up database 'ReportServer'. 2025-06-19 19:51:20.43 spid29s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [8] 2025-06-19 19:51:20.43 spid29s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 8. 2025-06-19 19:51:20.43 spid31s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [10] 2025-06-19 19:51:20.43 spid31s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 10. 2025-06-19 19:51:20.44 spid28s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [7] 2025-06-19 19:51:20.44 spid28s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 7. 2025-06-19 19:51:20.44 spid32s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [11] 2025-06-19 19:51:20.44 spid32s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 11. 2025-06-19 19:51:20.44 spid33s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [12] 2025-06-19 19:51:20.44 spid33s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 12. 2025-06-19 19:51:20.49 Server External governance manager initialized 2025-06-19 19:51:20.50 spid33s Parallel redo is started for database 'ReportServer' with worker pool size [1]. 2025-06-19 19:51:20.51 spid33s 4 transactions rolled forward in database 'ReportServer' (12:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.51 spid30s Parallel redo is started for database 'FireInspections' with worker pool size [1]. 2025-06-19 19:51:20.51 spid29s Parallel redo is started for database 'ABC' with worker pool size [1]. 2025-06-19 19:51:20.53 spid30s 5 transactions rolled forward in database 'FireInspections' (9:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.53 spid29s 5 transactions rolled forward in database 'ABC' (8:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.54 spid33s 0 transactions rolled back in database 'ReportServer' (12:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.54 spid33s Parallel redo is shutdown for database 'ReportServer' with worker pool size [1]. 2025-06-19 19:51:20.55 spid30s 0 transactions rolled back in database 'FireInspections' (9:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.56 spid30s Parallel redo is shutdown for database 'FireInspections' with worker pool size [1]. 2025-06-19 19:51:20.56 spid29s 0 transactions rolled back in database 'ABC' (8:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.56 spid29s Parallel redo is shutdown for database 'ABC' with worker pool size [1]. 2025-06-19 19:51:20.57 spid32s Parallel redo is started for database 'ReportServerTempDB' with worker pool size [1]. 2025-06-19 19:51:20.57 spid28s Parallel redo is started for database 'FrontierData' with worker pool size [1]. 2025-06-19 19:51:20.58 spid28s 5 transactions rolled forward in database 'FrontierData' (7:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.58 spid32s 5 transactions rolled forward in database 'ReportServerTempDB' (11:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.61 spid31s Parallel redo is started for database 'DistributionDB' with worker pool size [1]. 2025-06-19 19:51:20.62 spid31s 5 transactions rolled forward in database 'DistributionDB' (10:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.62 spid32s 0 transactions rolled back in database 'ReportServerTempDB' (11:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.62 spid33s CHECKDB for database 'ReportServer' finished without errors on 2025-06-14 04:00:12.213 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.62 spid33s Starting up database 'Telecom'. 2025-06-19 19:51:20.62 spid33s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [13] 2025-06-19 19:51:20.62 spid33s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 13. 2025-06-19 19:51:20.63 spid32s Parallel redo is shutdown for database 'ReportServerTempDB' with worker pool size [1]. 2025-06-19 19:51:20.63 spid31s 0 transactions rolled back in database 'DistributionDB' (10:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.63 spid31s Parallel redo is shutdown for database 'DistributionDB' with worker pool size [1]. 2025-06-19 19:51:20.64 spid28s 0 transactions rolled back in database 'FrontierData' (7:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.64 spid30s CHECKDB for database 'FireInspections' finished without errors on 2025-06-14 04:00:07.997 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.67 spid33s Parallel redo is started for database 'Telecom' with worker pool size [1]. 2025-06-19 19:51:20.68 spid28s Parallel redo is shutdown for database 'FrontierData' with worker pool size [1]. 2025-06-19 19:51:20.68 spid30s Starting up database 'xTempDB'. 2025-06-19 19:51:20.68 spid33s 5 transactions rolled forward in database 'Telecom' (13:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.69 spid29s CHECKDB for database 'ABC' finished without errors on 2025-06-14 04:00:06.663 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.69 spid30s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [16] 2025-06-19 19:51:20.69 spid30s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 16. 2025-06-19 19:51:20.70 spid29s Starting up database 'FireAnalytics'. 2025-06-19 19:51:20.70 spid29s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [17] 2025-06-19 19:51:20.70 spid29s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 17. 2025-06-19 19:51:20.70 spid33s 0 transactions rolled back in database 'Telecom' (13:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.70 spid32s CHECKDB for database 'ReportServerTempDB' finished without errors on 2025-06-14 04:00:11.233 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.71 spid33s Parallel redo is shutdown for database 'Telecom' with worker pool size [1]. 2025-06-19 19:51:20.71 spid32s Starting up database 'SourceControl'. 2025-06-19 19:51:20.71 spid32s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [18] 2025-06-19 19:51:20.71 spid32s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 18. 2025-06-19 19:51:20.73 spid31s CHECKDB for database 'DistributionDB' finished without errors on 2025-06-14 04:00:09.433 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.73 spid31s Starting up database 'xWebDB'. 2025-06-19 19:51:20.73 spid31s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [19] 2025-06-19 19:51:20.73 spid31s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 19. 2025-06-19 19:51:20.74 spid25s Recovery of database 'msdb' (4) is 0% complete (approximately 14 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required. 2025-06-19 19:51:20.74 spid27s Parallel redo is started for database 'HTE' with worker pool size [1]. 2025-06-19 19:51:20.75 spid27s 4 transactions rolled forward in database 'HTE' (6:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.77 spid33s CHECKDB for database 'Telecom' finished without errors on 2025-06-14 04:00:13.317 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.78 spid33s Starting up database 'ProductionDB'. 2025-06-19 19:51:20.78 spid33s RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [20] 2025-06-19 19:51:20.78 spid33s RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 20. 2025-06-19 19:51:20.78 spid27s 0 transactions rolled back in database 'HTE' (6:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.79 spid27s Parallel redo is shutdown for database 'HTE' with worker pool size [1]. 2025-06-19 19:51:20.80 spid32s Parallel redo is started for database 'SourceControl' with worker pool size [1]. 2025-06-19 19:51:20.81 spid32s 5 transactions rolled forward in database 'SourceControl' (18:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.83 spid27s CHECKDB for database 'HTE' finished without errors on 2025-06-14 04:00:03.710 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.84 spid32s 0 transactions rolled back in database 'SourceControl' (18:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.84 spid32s Parallel redo is shutdown for database 'SourceControl' with worker pool size [1]. 2025-06-19 19:51:20.86 spid32s CHECKDB for database 'SourceControl' finished without errors on 2025-06-14 04:02:12.600 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.86 spid25s 880 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.88 spid28s CHECKDB for database 'FrontierData' finished without errors on 2025-06-14 04:00:05.033 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.89 spid25s 0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.89 spid25s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required. 2025-06-19 19:51:20.91 spid30s Parallel redo is started for database 'xTempDB' with worker pool size [1]. 2025-06-19 19:51:20.91 spid25s CHECKDB for database 'msdb' finished without errors on 2024-11-23 20:00:04.517 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:20.91 spid31s Parallel redo is started for database 'xWebDB' with worker pool size [1]. 2025-06-19 19:51:20.92 spid30s 5 transactions rolled forward in database 'xTempDB' (16:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.92 spid31s 5 transactions rolled forward in database 'xWebDB' (19:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.96 spid30s 0 transactions rolled back in database 'xTempDB' (16:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.96 spid30s Parallel redo is shutdown for database 'xTempDB' with worker pool size [1]. 2025-06-19 19:51:20.97 spid31s 0 transactions rolled back in database 'xWebDB' (19:0). This is an informational message only. No user action is required. 2025-06-19 19:51:20.97 spid31s Parallel redo is shutdown for database 'xWebDB' with worker pool size [1]. 2025-06-19 19:51:20.97 spid29s Parallel redo is started for database 'FireAnalytics' with worker pool size [1]. 2025-06-19 19:51:20.98 spid29s 5 transactions rolled forward in database 'FireAnalytics' (17:0). This is an informational message only. No user action is required. 2025-06-19 19:51:21.02 spid16s Starting up database 'tempdb'. 2025-06-19 19:51:21.02 spid29s 0 transactions rolled back in database 'FireAnalytics' (17:0). This is an informational message only. No user action is required. 2025-06-19 19:51:21.02 spid29s Parallel redo is shutdown for database 'FireAnalytics' with worker pool size [1]. 2025-06-19 19:51:21.03 spid31s CHECKDB for database 'xWebDB' finished without errors on 2025-06-14 04:03:10.713 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:21.03 spid30s CHECKDB for database 'xTempDB' finished without errors on 2025-06-14 04:00:14.390 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:21.06 spid29s CHECKDB for database 'FireAnalytics' finished without errors on 2025-06-14 04:00:18.583 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:21.10 spid33s Parallel redo is started for database 'ProductionDB' with worker pool size [1]. 2025-06-19 19:51:21.12 spid33s 5 transactions rolled forward in database 'ProductionDB' (20:0). This is an informational message only. No user action is required. 2025-06-19 19:51:21.15 spid33s 0 transactions rolled back in database 'ProductionDB' (20:0). This is an informational message only. No user action is required. 2025-06-19 19:51:21.15 spid33s Recovery is writing a checkpoint in database 'ProductionDB' (20). This is an informational message only. No user action is required. 2025-06-19 19:51:21.17 spid33s Parallel redo is shutdown for database 'ProductionDB' with worker pool size [1]. 2025-06-19 19:51:21.20 spid33s CHECKDB for database 'ProductionDB' finished without errors on 2025-06-14 04:03:58.143 (local time). This is an informational message only; no user action is required. 2025-06-19 19:51:21.31 spid16s The tempdb database has 4 data file(s). 2025-06-19 19:51:21.31 spid16s The tempdb database data files are not configured with the same initial size and autogrowth settings. To reduce potential allocation contention, the initial size and autogrowth of the files should be same. 2025-06-19 19:51:21.77 spid15s Database 'master' is upgrading script 'msdb110_upgrade.sql' from level 268439601 to level 268439641. 2025-06-19 19:51:21.77 spid15s ---------------------------------- 2025-06-19 19:51:21.77 spid15s Starting execution of PRE_MSDB.SQL 2025-06-19 19:51:21.77 spid15s ---------------------------------- 2025-06-19 19:51:21.89 spid15s Setting database option COMPATIBILITY_LEVEL to 100 for database 'msdb'. 2025-06-19 19:51:21.93 spid15s ----------------------------------------- 2025-06-19 19:51:21.93 spid15s Starting execution of PRE_SQLAGENT100.SQL 2025-06-19 19:51:21.93 spid15s ----------------------------------------- 2025-06-19 19:51:21.95 spid15s Setting database option COMPATIBILITY_LEVEL to 160 for database 'msdb'. 2025-06-19 19:51:22.54 spid15s Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required. 2025-06-19 19:51:22.55 spid15s Using 'xpstar.dll' version '2022.160.4185' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required. 2025-06-19 19:51:22.55 spid15s DBCC TRACEOFF 1717, server process ID (SPID) 15. This is an informational message only; no user action is required. 2025-06-19 19:51:22.55 spid15s DBCC execution completed. If DBCC printed error messages, contact your system administrator. 2025-06-19 19:51:22.56 spid15s 2025-06-19 19:51:22.56 spid15s Creating table temp_sysjobschedules 2025-06-19 19:51:22.70 spid15s 2025-06-19 19:51:22.70 spid15s Alter table sysdownloadlist... 2025-06-19 19:51:22.71 spid15s 2025-06-19 19:51:22.71 spid15s Alter table sysjobhistory... 2025-06-19 19:51:22.72 spid15s 2025-06-19 19:51:22.72 spid15s Alter table systargetservers... 2025-06-19 19:51:22.73 spid15s 2025-06-19 19:51:22.73 spid15s Alter table sysjobsteps... 2025-06-19 19:51:22.76 spid15s 2025-06-19 19:51:22.76 spid15s PRE_SQLAGENT100... (dbo.syssubsystems table) 2025-06-19 19:51:22.76 spid15s PRE_SQLAGENT100::Creating tempdb.dbo.subsystemsettings 2025-06-19 19:51:22.76 spid15s PRE_SQLAGENT100::Backing up max_worker_threads to tempdb.dbo.subsystemsettings 2025-06-19 19:51:22.76 spid15s PRE_SQLAGENT100::Dropping msdb.dbo.subsystems (will be recreated later) 2025-06-19 19:51:22.82 spid15s 2025-06-19 19:51:22.82 spid15s ----------------------------------------- 2025-06-19 19:51:22.82 spid15s Execution of PRE_SQLAGENT100.SQL complete 2025-06-19 19:51:22.82 spid15s ----------------------------------------- 2025-06-19 19:51:22.83 spid15s DMF pre-upgrade steps... 2025-06-19 19:51:23.12 spid15s DC pre-upgrade steps... 2025-06-19 19:51:23.12 spid15s Check if Data collector config table exists... 2025-06-19 19:51:23.12 spid15s Data Collector state before upgrade: 0 2025-06-19 19:51:23.12 spid15s pre_dc100::Check if syscollector_collection_sets_internal table exists... 2025-06-19 19:51:23.12 spid15s pre_dc100::Capturing Collection set status in temp table... 2025-06-19 19:51:23.18 spid15s Deleting cached auto-generated T-SQL Data Collection packages from msdb... 2025-06-19 19:51:23.18 spid15s End of DC pre-upgrade steps. 2025-06-19 19:51:23.18 spid15s DAC pre-upgrade steps... 2025-06-19 19:51:23.19 spid15s Starting DAC pre-upgrade steps ... 2025-06-19 19:51:23.19 spid15s End of DAC pre-upgrade steps. 2025-06-19 19:51:23.19 spid15s ---------------------------------- 2025-06-19 19:51:23.19 spid15s Starting execution of MSDB.SQL 2025-06-19 19:51:23.19 spid15s ---------------------------------- 2025-06-19 19:51:23.26 spid15s Checking the size of MSDB... 2025-06-19 19:51:24.78 spid15s 2025-06-19 19:51:24.78 spid15s Setting database option TRUSTWORTHY to ON for database 'msdb'. 2025-06-19 19:51:24.85 spid15s Setting database option RECOVERY to SIMPLE for database 'msdb'. 2025-06-19 19:51:24.89 spid15s ---------------------------------- 2025-06-19 19:51:24.89 spid15s Finished execution of MSDB.SQL 2025-06-19 19:51:24.89 spid15s ---------------------------------- 2025-06-19 19:51:24.89 spid15s ----------------------------------------- 2025-06-19 19:51:24.89 spid15s Starting execution of MSDB_VERSIONING.SQL 2025-06-19 19:51:24.89 spid15s ----------------------------------------- 2025-06-19 19:51:24.91 spid15s ----------------------------------------- 2025-06-19 19:51:24.91 spid15s Finished execution of MSDB_VERSIONING.SQL 2025-06-19 19:51:24.91 spid15s ----------------------------------------- 2025-06-19 19:51:24.97 spid15s 2025-06-19 19:51:24.97 spid15s Creating procedure sp_agent_add_job... 2025-06-19 19:51:24.98 spid15s 2025-06-19 19:51:24.98 spid15s Creating procedure sp_agent_delete_job... 2025-06-19 19:51:24.98 spid15s 2025-06-19 19:51:24.98 spid15s Creating procedure sp_agent_add_jobstep... 2025-06-19 19:51:24.98 spid15s 2025-06-19 19:51:24.98 spid15s Creating procedure sp_agent_start_job... 2025-06-19 19:51:24.99 spid15s 2025-06-19 19:51:24.99 spid15s Creating procedure sp_agent_get_jobstep... 2025-06-19 19:51:24.99 spid15s 2025-06-19 19:51:24.99 spid15s Creating procedure sp_agent_log_job_history... 2025-06-19 19:51:24.99 spid15s 2025-06-19 19:51:24.99 spid15s Creating procedure sp_agent_write_sysjobstep_log... 2025-06-19 19:51:24.99 spid15s 2025-06-19 19:51:24.99 spid15s Creating table syssubsystems... 2025-06-19 19:51:25.00 spid15s 2025-06-19 19:51:25.00 spid15s Creating view sysproxyloginsubsystem_view... 2025-06-19 19:51:25.02 spid15s 2025-06-19 19:51:25.02 spid15s Creating trigger trig_sysoriginatingservers_delete... 2025-06-19 19:51:25.02 spid15s 2025-06-19 19:51:25.02 spid15s Creating view sysoriginatingservers_view... 2025-06-19 19:51:25.02 spid15s 2025-06-19 19:51:25.02 spid15s Creating trigger trig_sysjobs_insert_update... 2025-06-19 19:51:25.03 spid15s 2025-06-19 19:51:25.03 spid15s Creating view sysjobs_view... 2025-06-19 19:51:25.05 spid15s 2025-06-19 19:51:25.05 spid15s Creating trigger trig_sysschedules_insert_update... 2025-06-19 19:51:25.05 spid15s 2025-06-19 19:51:25.05 spid15s Creating view sysschedules_localserver_view... 2025-06-19 19:51:25.08 spid15s 2025-06-19 19:51:25.08 spid15s Creating view systargetservers_view... 2025-06-19 19:51:25.10 spid15s 2025-06-19 19:51:25.10 spid15s Creating view sysalerts_performance_counters_view... 2025-06-19 19:51:25.11 spid15s 2025-06-19 19:51:25.11 spid15s Creating function SQLAGENT_SUSER_SNAME ... 2025-06-19 19:51:25.11 spid15s 2025-06-19 19:51:25.11 spid15s Creating function SQLAGENT_SUSER_SID ... 2025-06-19 19:51:25.12 spid15s 2025-06-19 19:51:25.12 spid15s Creating procedure SP_SQLAGENT_IS_SRVROLEMEMBER... 2025-06-19 19:51:25.12 spid15s 2025-06-19 19:51:25.12 spid15s Creating procedure sp_get_traceflag_status_internal... 2025-06-19 19:51:25.12 spid15s 2025-06-19 19:51:25.12 spid15s Creating procedure sp_verify_category_identifiers... 2025-06-19 19:51:25.12 spid15s 2025-06-19 19:51:25.12 spid15s Creating function agent_datetime... 2025-06-19 19:51:25.12 spid15s 2025-06-19 19:51:25.12 spid15s Creating procedure sp_verify_proxy_identifiers... 2025-06-19 19:51:25.12 spid15s 2025-06-19 19:51:25.12 spid15s Creating procedure sp_verify_credential_identifiers... 2025-06-19 19:51:25.13 spid15s 2025-06-19 19:51:25.13 spid15s Creating procedure sp_verify_subsystems... 2025-06-19 19:51:25.13 spid15s 2025-06-19 19:51:25.13 spid15s Creating procedure sp_verify_subsystem_identifiers... 2025-06-19 19:51:25.14 spid15s 2025-06-19 19:51:25.14 spid15s Creating procedure sp_verify_login_identifiers... 2025-06-19 19:51:25.14 spid15s 2025-06-19 19:51:25.14 spid15s Creating procedure sp_verify_proxy... 2025-06-19 19:51:25.14 spid15s 2025-06-19 19:51:25.14 spid15s Creating procedure sp_add_proxy... 2025-06-19 19:51:25.14 spid15s 2025-06-19 19:51:25.14 spid15s Creating procedure sp_delete_proxy... 2025-06-19 19:51:25.15 spid15s 2025-06-19 19:51:25.15 spid15s Creating procedure sp_update_proxy... 2025-06-19 19:51:25.15 spid15s 2025-06-19 19:51:25.15 spid15s Creating procedure sp_sqlagent_is_member... 2025-06-19 19:51:25.15 spid15s 2025-06-19 19:51:25.15 spid15s Creating procedure sp_verify_proxy_permissions... 2025-06-19 19:51:25.16 spid15s 2025-06-19 19:51:25.16 spid15s Creating procedure sp_help_proxy... 2025-06-19 19:51:25.17 spid15s 2025-06-19 19:51:25.17 spid15s Creating procedure sp_get_proxy_properties... 2025-06-19 19:51:25.17 spid15s 2025-06-19 19:51:25.17 spid15s Creating procedure sp_grant_proxy_to_subsystem... 2025-06-19 19:51:25.18 spid15s 2025-06-19 19:51:25.18 spid15s Creating procedure sp_grant_login_to_proxy... 2025-06-19 19:51:25.18 spid15s 2025-06-19 19:51:25.18 spid15s Creating procedure sp_revoke_login_from_proxy... 2025-06-19 19:51:25.18 spid15s 2025-06-19 19:51:25.18 spid15s Creating procedure sp_revoke_proxy_from_subsystem... 2025-06-19 19:51:25.18 spid15s 2025-06-19 19:51:25.18 spid15s Creating procedure sp_enum_proxy_for_subsystem... 2025-06-19 19:51:25.19 spid15s 2025-06-19 19:51:25.19 spid15s Creating procedure sp_enum_login_for_proxy... 2025-06-19 19:51:25.19 spid15s 2025-06-19 19:51:25.19 spid15s Creating procedure sp_reassign_proxy... 2025-06-19 19:51:25.19 spid15s 2025-06-19 19:51:25.19 spid15s Creating procedure sp_sqlagent_get_startup_info... 2025-06-19 19:51:25.19 spid15s 2025-06-19 19:51:25.19 spid15s Creating procedure sp_sqlagent_update_agent_xps... 2025-06-19 19:51:25.19 spid15s 2025-06-19 19:51:25.19 spid15s Creating procedure sp_sqlagent_has_server_access... 2025-06-19 19:51:25.23 spid15s 2025-06-19 19:51:25.23 spid15s Creating procedure sp_sqlagent_get_perf_counters... 2025-06-19 19:51:25.24 spid15s 2025-06-19 19:51:25.24 spid15s Creating procedure sp_sqlagent_notify... 2025-06-19 19:51:25.25 spid15s 2025-06-19 19:51:25.25 spid15s Creating procedure sp_is_sqlagent_starting... 2025-06-19 19:51:25.25 spid15s 2025-06-19 19:51:25.25 spid15s Creating procedure sp_verify_job_identifiers... 2025-06-19 19:51:25.25 spid15s 2025-06-19 19:51:25.25 spid15s Creating procedure sp_verify_schedule_identifiers... 2025-06-19 19:51:25.26 spid15s 2025-06-19 19:51:25.26 spid15s Creating procedure sp_verify_jobproc_caller... 2025-06-19 19:51:25.26 spid15s 2025-06-19 19:51:25.26 spid15s Creating procedure sp_downloaded_row_limiter... 2025-06-19 19:51:25.26 spid15s 2025-06-19 19:51:25.26 spid15s Creating procedure sp_post_msx_operation... 2025-06-19 19:51:25.27 spid15s 2025-06-19 19:51:25.27 spid15s Creating procedure sp_verify_performance_condition... 2025-06-19 19:51:25.27 spid15s 2025-06-19 19:51:25.27 spid15s Creating procedure sp_verify_job_date... 2025-06-19 19:51:25.27 spid15s 2025-06-19 19:51:25.27 spid15s Creating procedure sp_verify_job_time... 2025-06-19 19:51:25.27 spid15s 2025-06-19 19:51:25.27 spid15s Creating procedure sp_verify_alert... 2025-06-19 19:51:25.28 spid15s 2025-06-19 19:51:25.28 spid15s Creating procedure sp_update_alert... 2025-06-19 19:51:25.29 spid15s 2025-06-19 19:51:25.29 spid15s Creating procedure sp_delete_job_references... 2025-06-19 19:51:25.30 spid15s 2025-06-19 19:51:25.30 spid15s Creating procedure sp_delete_all_msx_jobs... 2025-06-19 19:51:25.30 spid15s 2025-06-19 19:51:25.30 spid15s Creating procedure sp_generate_target_server_job_assignment_sql... 2025-06-19 19:51:25.30 spid15s 2025-06-19 19:51:25.30 spid15s Creating procedure sp_generate_server_description... 2025-06-19 19:51:25.31 spid15s 2025-06-19 19:51:25.31 spid15s Creating procedure sp_msx_set_account... 2025-06-19 19:51:25.31 spid15s 2025-06-19 19:51:25.31 spid15s Creating procedure sp_msx_get_account... 2025-06-19 19:51:25.31 spid15s 2025-06-19 19:51:25.31 spid15s Creating procedure sp_delete_operator... 2025-06-19 19:51:25.31 spid15s 2025-06-19 19:51:25.31 spid15s Creating procedure sp_msx_defect... 2025-06-19 19:51:25.32 spid15s 2025-06-19 19:51:25.32 spid15s Creating procedure sp_msx_enlist... 2025-06-19 19:51:25.33 spid15s 2025-06-19 19:51:25.33 spid15s Creating procedure sp_delete_targetserver... 2025-06-19 19:51:25.33 spid15s 2025-06-19 19:51:25.33 spid15s Creating procedure sp_enlist_tsx 2025-06-19 19:51:25.34 spid15s 2025-06-19 19:51:25.34 spid15s Creating procedure sp_get_sqlagent_properties... 2025-06-19 19:51:25.34 spid15s 2025-06-19 19:51:25.34 spid15s Create procedure sp_set_sqlagent_properties... 2025-06-19 19:51:25.35 spid15s 2025-06-19 19:51:25.35 spid15s Creating procedure sp_add_targetservergroup... 2025-06-19 19:51:25.35 spid15s 2025-06-19 19:51:25.35 spid15s Creating procedure sp_update_targetservergroup... 2025-06-19 19:51:25.35 spid15s 2025-06-19 19:51:25.35 spid15s Creating procedure sp_delete_targetservergroup... 2025-06-19 19:51:25.35 spid15s 2025-06-19 19:51:25.35 spid15s Creating procedure sp_help_targetservergroup... 2025-06-19 19:51:25.36 spid15s 2025-06-19 19:51:25.36 spid15s Creating procedure sp_add_targetsvgrp_member... 2025-06-19 19:51:25.36 spid15s 2025-06-19 19:51:25.36 spid15s Creating procedure sp_delete_targetsvrgrp_member... 2025-06-19 19:51:25.36 spid15s 2025-06-19 19:51:25.36 spid15s Creating procedure sp_verify_category... 2025-06-19 19:51:25.36 spid15s 2025-06-19 19:51:25.36 spid15s Creating procedure sp_add_category... 2025-06-19 19:51:25.36 spid15s 2025-06-19 19:51:25.36 spid15s Creating procedure sp_update_category... 2025-06-19 19:51:25.37 spid15s 2025-06-19 19:51:25.37 spid15s Creating procedure sp_delete_category... 2025-06-19 19:51:25.37 spid15s 2025-06-19 19:51:25.37 spid15s Creating procedure sp_help_category... 2025-06-19 19:51:25.37 spid15s 2025-06-19 19:51:25.37 spid15s Creating procedure sp_help_targetserver... 2025-06-19 19:51:25.38 spid15s 2025-06-19 19:51:25.38 spid15s Creating procedure sp_resync_targetserver... 2025-06-19 19:51:25.39 spid15s 2025-06-19 19:51:25.39 spid15s Creating procedure sp_purge_jobhistory... 2025-06-19 19:51:25.40 spid15s 2025-06-19 19:51:25.40 spid15s Creating procedure sp_help_jobhistory... 2025-06-19 19:51:25.40 spid15s 2025-06-19 19:51:25.40 spid15s Creating procedure sp_add_jobserver... 2025-06-19 19:51:25.41 spid15s 2025-06-19 19:51:25.41 spid15s Creating procedure sp_delete_jobserver... 2025-06-19 19:51:25.41 spid15s 2025-06-19 19:51:25.41 spid15s Creating procedure sp_help_jobserver... 2025-06-19 19:51:25.41 spid15s 2025-06-19 19:51:25.41 spid15s Creating procedure sp_help_downloadlist... 2025-06-19 19:51:25.41 spid15s 2025-06-19 19:51:25.41 spid15s Creating procedure sp_enum_sqlagent_subsystems_internal... 2025-06-19 19:51:25.42 spid15s 2025-06-19 19:51:25.42 spid15s Creating procedure sp_enum_sqlagent_subsystems... 2025-06-19 19:51:25.42 spid15s 2025-06-19 19:51:25.42 spid15s Creating procedure sp_verify_subsystem... 2025-06-19 19:51:25.42 spid15s 2025-06-19 19:51:25.42 spid15s Creating procedure sp_verify_schedule... 2025-06-19 19:51:25.43 spid15s 2025-06-19 19:51:25.43 spid15s Creating procedure sp_add_schedule... 2025-06-19 19:51:25.43 spid15s 2025-06-19 19:51:25.43 spid15s Creating procedure sp_attach_schedule ... 2025-06-19 19:51:25.43 spid15s 2025-06-19 19:51:25.43 spid15s Creating procedure sp_detach_schedule ... 2025-06-19 19:51:25.44 spid15s 2025-06-19 19:51:25.44 spid15s Creating procedure sp_update_replication_job_parameter... 2025-06-19 19:51:25.44 spid15s 2025-06-19 19:51:25.44 spid15s Creating procedure sp_update_schedule ... 2025-06-19 19:51:25.45 spid15s 2025-06-19 19:51:25.45 spid15s Creating procedure sp_delete_schedule ... 2025-06-19 19:51:25.45 spid15s 2025-06-19 19:51:25.45 spid15s Creating procedure sp_get_jobstep_db_username... 2025-06-19 19:51:25.45 spid15s 2025-06-19 19:51:25.45 spid15s Creating procedure sp_verify_jobstep... 2025-06-19 19:51:25.46 spid15s 2025-06-19 19:51:25.46 spid15s Creating procedure sp_add_jobstep_internal... 2025-06-19 19:51:25.47 spid15s 2025-06-19 19:51:25.47 spid15s Creating procedure sp_add_jobstep... 2025-06-19 19:51:25.47 spid15s 2025-06-19 19:51:25.47 spid15s Creating procedure sp_update_jobstep... 2025-06-19 19:51:25.48 spid15s 2025-06-19 19:51:25.48 spid15s Creating procedure sp_delete_jobstep... 2025-06-19 19:51:25.48 spid15s 2025-06-19 19:51:25.48 spid15s Creating procedure sp_help_jobstep... 2025-06-19 19:51:25.48 spid15s 2025-06-19 19:51:25.48 spid15s Creating procedure sp_write_sysjobstep_log... 2025-06-19 19:51:25.49 spid15s 2025-06-19 19:51:25.49 spid15s Creating procedure sp_help_jobsteplog... 2025-06-19 19:51:25.49 spid15s 2025-06-19 19:51:25.49 spid15s Creating procedure sp_delete_jobsteplog... 2025-06-19 19:51:25.49 spid15s 2025-06-19 19:51:25.49 spid15s Creating procedure sp_get_schedule_description... 2025-06-19 19:51:25.50 spid15s 2025-06-19 19:51:25.50 spid15s Creating procedure sp_add_jobschedule... 2025-06-19 19:51:25.51 spid15s 2025-06-19 19:51:25.51 spid15s Creating procedure sp_update_jobschedule... 2025-06-19 19:51:25.52 spid15s 2025-06-19 19:51:25.52 spid15s Creating procedure sp_delete_jobschedule... 2025-06-19 19:51:25.52 spid15s 2025-06-19 19:51:25.52 spid15s Creating procedure sp_help_schedule... 2025-06-19 19:51:25.53 spid15s 2025-06-19 19:51:25.53 spid15s Creating procedure sp_help_jobschedule... 2025-06-19 19:51:25.54 spid15s 2025-06-19 19:51:25.54 spid15s Creating procedure sp_verify_job... 2025-06-19 19:51:25.55 spid15s 2025-06-19 19:51:25.55 spid15s Creating procedure sp_add_job... 2025-06-19 19:51:25.56 spid15s 2025-06-19 19:51:25.56 spid15s Creating procedure sp_update_job... 2025-06-19 19:51:25.57 spid15s 2025-06-19 19:51:25.57 spid15s Creating procedure sp_delete_job... 2025-06-19 19:51:25.58 spid15s 2025-06-19 19:51:25.58 spid15s Creating procedure sp_get_composite_job_info... 2025-06-19 19:51:25.60 spid15s 2025-06-19 19:51:25.60 spid15s Creating procedure sp_help_job... 2025-06-19 19:51:25.61 spid15s 2025-06-19 19:51:25.61 spid15s Creating procedure sp_help_jobcount... 2025-06-19 19:51:25.61 spid15s 2025-06-19 19:51:25.61 spid15s Creating procedure sp_help_jobs_in_schedule... 2025-06-19 19:51:25.61 spid15s 2025-06-19 19:51:25.61 spid15s Creating procedure sp_manage_jobs_by_login... 2025-06-19 19:51:25.61 spid15s 2025-06-19 19:51:25.61 spid15s Creating procedure sp_apply_job_to_targets... 2025-06-19 19:51:25.62 spid15s 2025-06-19 19:51:25.62 spid15s Creating procedure sp_remove_job_from_targets... 2025-06-19 19:51:25.62 spid15s 2025-06-19 19:51:25.62 spid15s Creating procedure sp_get_job_alerts... 2025-06-19 19:51:25.62 spid15s 2025-06-19 19:51:25.62 spid15s Creating procedure sp_start_job... 2025-06-19 19:51:25.63 spid15s 2025-06-19 19:51:25.63 spid15s Creating procedure sp_stop_job... 2025-06-19 19:51:25.63 spid15s 2025-06-19 19:51:25.63 spid15s Creating procedure sp_cycle_agent_errorlog... 2025-06-19 19:51:25.63 spid15s 2025-06-19 19:51:25.63 spid15s Creating procedure sp_get_chunked_jobstep_params... 2025-06-19 19:51:25.63 spid15s 2025-06-19 19:51:25.63 spid15s Creating procedure sp_check_for_owned_jobs... 2025-06-19 19:51:25.63 spid15s 2025-06-19 19:51:25.63 spid15s Creating procedure sp_check_for_owned_jobsteps... 2025-06-19 19:51:25.64 spid15s 2025-06-19 19:51:25.64 spid15s Creating procedure sp_sqlagent_refresh_job... 2025-06-19 19:51:25.64 spid15s 2025-06-19 19:51:25.64 spid15s Creating procedure sp_jobhistory_row_limiter... 2025-06-19 19:51:25.65 spid15s 2025-06-19 19:51:25.65 spid15s Creating procedure [dbo].[sp_sqlagent_set_job_completion_state]... 2025-06-19 19:51:25.65 spid15s 2025-06-19 19:51:25.65 spid15s Creating procedure [dbo].[sp_sqlagent_set_jobstep_completion_state]... 2025-06-19 19:51:25.65 spid15s 2025-06-19 19:51:25.65 spid15s Creating procedure [dbo].[sp_sqlagent_create_jobactivity]... 2025-06-19 19:51:25.65 spid15s 2025-06-19 19:51:25.65 spid15s Creating procedure [dbo].[sp_sqlagent_update_jobactivity_next_scheduled_date]... 2025-06-19 19:51:25.66 spid15s 2025-06-19 19:51:25.66 spid15s Creating procedure [dbo].[sp_sqlagent_update_jobactivity_requested_date]... 2025-06-19 19:51:25.66 spid15s 2025-06-19 19:51:25.66 spid15s Creating procedure [dbo].[sp_sqlagent_update_jobactivity_queued_date]... 2025-06-19 19:51:25.66 spid15s 2025-06-19 19:51:25.66 spid15s Creating procedure [dbo].[sp_sqlagent_update_jobactivity_start_execution_date]... 2025-06-19 19:51:25.66 spid15s 2025-06-19 19:51:25.66 spid15s Creating procedure sp_sqlagent_log_jobhistory... 2025-06-19 19:51:25.67 spid15s 2025-06-19 19:51:25.67 spid15s Creating procedure sp_sqlagent_check_msx_version... 2025-06-19 19:51:25.67 spid15s 2025-06-19 19:51:25.67 spid15s Creating procedure sp_sqlagent_probe_msx... 2025-06-19 19:51:25.67 spid15s 2025-06-19 19:51:25.67 spid15s Creating procedure sp_set_local_time... 2025-06-19 19:51:25.68 spid15s 2025-06-19 19:51:25.68 spid15s Creating procedure sp_multi_server_job_summary... 2025-06-19 19:51:25.68 spid15s 2025-06-19 19:51:25.68 spid15s Creating procedure sp_target_server_summary... 2025-06-19 19:51:25.69 spid15s 2025-06-19 19:51:25.69 spid15s Creating [legacy] procedure sp_uniquetaskname... 2025-06-19 19:51:25.69 spid15s 2025-06-19 19:51:25.69 spid15s Creating [legacy] procedure sp_addtask... 2025-06-19 19:51:25.70 spid15s 2025-06-19 19:51:25.70 spid15s Creating [legacy] procedure sp_droptask... 2025-06-19 19:51:25.70 spid15s 2025-06-19 19:51:25.70 spid15s Creating trigger trig_targetserver_insert... 2025-06-19 19:51:25.71 spid15s 2025-06-19 19:51:25.71 spid15s Creating procedure sp_add_alert_internal... 2025-06-19 19:51:25.72 spid15s 2025-06-19 19:51:25.72 spid15s Creating procedure sp_add_alert... 2025-06-19 19:51:25.72 spid15s 2025-06-19 19:51:25.72 spid15s Creating procedure sp_delete_alert... 2025-06-19 19:51:25.72 spid15s 2025-06-19 19:51:25.72 spid15s Creating procedure sp_help_alert... 2025-06-19 19:51:25.73 spid15s 2025-06-19 19:51:25.73 spid15s Creating procedure sp_verify_operator... 2025-06-19 19:51:25.73 spid15s 2025-06-19 19:51:25.73 spid15s Creating procedure sp_add_operator... 2025-06-19 19:51:25.73 spid15s 2025-06-19 19:51:25.73 spid15s Creating procedure sp_update_operator... 2025-06-19 19:51:25.74 spid15s 2025-06-19 19:51:25.74 spid15s Creating procedure sp_help_operator... 2025-06-19 19:51:25.74 spid15s 2025-06-19 19:51:25.74 spid15s Creating procedure sp_help_operator_jobs... 2025-06-19 19:51:25.74 spid15s 2025-06-19 19:51:25.74 spid15s Creating procedure sp_verify_operator_identifiers... 2025-06-19 19:51:25.75 spid15s 2025-06-19 19:51:25.75 spid15s Creating procedure sp_notify_operator... 2025-06-19 19:51:25.75 spid15s 2025-06-19 19:51:25.75 spid15s Creating procedure sp_verify_notification... 2025-06-19 19:51:25.75 spid15s 2025-06-19 19:51:25.75 spid15s Creating procedure sp_add_notification... 2025-06-19 19:51:25.75 spid15s 2025-06-19 19:51:25.75 spid15s Creating procedure sp_update_notification... 2025-06-19 19:51:25.75 spid15s 2025-06-19 19:51:25.75 spid15s Creating procedure sp_delete_notification... 2025-06-19 19:51:25.76 spid15s 2025-06-19 19:51:25.76 spid15s Creating procedure sp_help_notification... 2025-06-19 19:51:25.76 spid15s 2025-06-19 19:51:25.76 spid15s Creating procedure sp_help_jobactivity... 2025-06-19 19:51:25.78 spid15s 2025-06-19 19:51:25.78 spid15s Creating trigger trig_notification_ins_or_upd... 2025-06-19 19:51:25.78 spid15s 2025-06-19 19:51:25.78 spid15s Creating trigger trig_notification_delete... 2025-06-19 19:51:25.78 spid15s 2025-06-19 19:51:25.78 spid15s Setting object permissions... 2025-06-19 19:51:25.88 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.89 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.90 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.91 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.91 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.91 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.91 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.91 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:25.92 spid15s 2025-06-19 19:51:25.92 spid15s Creating procedure sp_sem_add_message... 2025-06-19 19:51:25.93 spid15s 2025-06-19 19:51:25.93 spid15s Creating procedure sp_sem_drop_message... 2025-06-19 19:51:25.93 spid15s 2025-06-19 19:51:25.93 spid15s Creating procedure sp_get_message_description... 2025-06-19 19:51:25.95 spid15s 2025-06-19 19:51:25.95 spid15s Creating procedure sp_convert_jobid_to_char... 2025-06-19 19:51:26.08 spid15s 2025-06-19 19:51:26.08 spid15s Creating view sysmail_allitems... 2025-06-19 19:51:26.09 spid15s 2025-06-19 19:51:26.09 spid15s Creating view sysmail_sentitems... 2025-06-19 19:51:26.09 spid15s 2025-06-19 19:51:26.09 spid15s Creating view sysmail_unsentitems... 2025-06-19 19:51:26.09 spid15s 2025-06-19 19:51:26.09 spid15s Creating view sysmail_faileditems... 2025-06-19 19:51:26.10 spid15s Creating sysmail_delete_mailitems_sp 2025-06-19 19:51:26.16 spid15s 2025-06-19 19:51:26.16 spid15s Creating view sysmail_mailattachments... 2025-06-19 19:51:26.29 spid15s 2025-06-19 19:51:26.29 spid15s Creating view sysmail_event_log... 2025-06-19 19:51:26.29 spid15s Creating sysmail_delete_log_sp 2025-06-19 19:51:26.30 spid15s 2025-06-19 19:51:26.30 spid15s Creating trigger trig_sysmail_profile... 2025-06-19 19:51:26.30 spid15s 2025-06-19 19:51:26.30 spid15s Creating trigger trig_principalprofile... 2025-06-19 19:51:26.30 spid15s 2025-06-19 19:51:26.30 spid15s Creating trigger trig_sysmail_account... 2025-06-19 19:51:26.31 spid15s 2025-06-19 19:51:26.31 spid15s Creating trigger trig_sysmail_profileaccount... 2025-06-19 19:51:26.31 spid15s 2025-06-19 19:51:26.31 spid15s Creating trigger trig_sysmail_profile_delete... 2025-06-19 19:51:26.31 spid15s 2025-06-19 19:51:26.31 spid15s Creating trigger trig_sysmail_servertype... 2025-06-19 19:51:26.31 spid15s 2025-06-19 19:51:26.31 spid15s Creating trigger trig_sysmail_server... 2025-06-19 19:51:26.31 spid15s 2025-06-19 19:51:26.31 spid15s Creating trigger trig_sysmail_configuration... 2025-06-19 19:51:26.32 spid15s 2025-06-19 19:51:26.32 spid15s Creating procedure sysmail_verify_accountparams_sp... 2025-06-19 19:51:26.32 spid15s 2025-06-19 19:51:26.32 spid15s Creating procedure sysmail_verify_addressparams_sp... 2025-06-19 19:51:26.33 spid15s 2025-06-19 19:51:26.33 spid15s Creating procedure sysmail_verify_principal_sp... 2025-06-19 19:51:26.33 spid15s 2025-06-19 19:51:26.33 spid15s Creating procedure sysmail_verify_profile_sp... 2025-06-19 19:51:26.33 spid15s 2025-06-19 19:51:26.33 spid15s Creating procedure sysmail_verify_account_sp... 2025-06-19 19:51:26.34 spid15s 2025-06-19 19:51:26.34 spid15s Creating procedure sysmail_add_profile_sp... 2025-06-19 19:51:26.34 spid15s 2025-06-19 19:51:26.34 spid15s Creating procedure sysmail_update_profile_sp... 2025-06-19 19:51:26.34 spid15s 2025-06-19 19:51:26.34 spid15s Creating procedure sysmail_delete_profile_sp... 2025-06-19 19:51:26.35 spid15s 2025-06-19 19:51:26.35 spid15s Creating procedure sysmail_help_profile_sp... 2025-06-19 19:51:26.35 spid15s 2025-06-19 19:51:26.35 spid15s Creating procedure sysmail_create_user_credential_sp... 2025-06-19 19:51:26.35 spid15s 2025-06-19 19:51:26.35 spid15s Creating procedure sysmail_alter_user_credential_sp... 2025-06-19 19:51:26.35 spid15s 2025-06-19 19:51:26.35 spid15s Creating procedure sysmail_drop_user_credential_sp... 2025-06-19 19:51:26.35 spid15s 2025-06-19 19:51:26.35 spid15s Creating procedure sysmail_add_account_sp... 2025-06-19 19:51:26.36 spid15s 2025-06-19 19:51:26.36 spid15s Creating procedure sysmail_update_account_sp... 2025-06-19 19:51:26.36 spid15s 2025-06-19 19:51:26.36 spid15s Creating procedure sysmail_delete_account_sp... 2025-06-19 19:51:26.36 spid15s 2025-06-19 19:51:26.36 spid15s Creating procedure sysmail_help_account_sp... 2025-06-19 19:51:26.36 spid15s 2025-06-19 19:51:26.36 spid15s Creating procedure sysmail_help_admin_account_sp... 2025-06-19 19:51:26.37 spid15s 2025-06-19 19:51:26.37 spid15s Creating procedure sysmail_add_profileaccount_sp... 2025-06-19 19:51:26.37 spid15s 2025-06-19 19:51:26.37 spid15s Creating procedure sysmail_update_profileaccount_sp... 2025-06-19 19:51:26.37 spid15s 2025-06-19 19:51:26.37 spid15s Creating procedure sysmail_delete_profileaccount_sp... 2025-06-19 19:51:26.37 spid15s 2025-06-19 19:51:26.37 spid15s Creating procedure sysmail_help_profileaccount_sp... 2025-06-19 19:51:26.38 spid15s 2025-06-19 19:51:26.38 spid15s Creating procedure sysmail_configure_sp... 2025-06-19 19:51:26.38 spid15s 2025-06-19 19:51:26.38 spid15s Creating procedure sysmail_help_configure_sp... 2025-06-19 19:51:26.38 spid15s 2025-06-19 19:51:26.38 spid15s Creating procedure sysmail_help_configure_value_sp... 2025-06-19 19:51:26.38 spid15s 2025-06-19 19:51:26.38 spid15s Creating procedure sysmail_add_principalprofile_sp... 2025-06-19 19:51:26.38 spid15s 2025-06-19 19:51:26.38 spid15s Creating procedure sysmail_update_principalprofile_sp... 2025-06-19 19:51:26.38 spid15s 2025-06-19 19:51:26.38 spid15s Creating procedure sysmail_delete_principalprofile_sp... 2025-06-19 19:51:26.39 spid15s 2025-06-19 19:51:26.39 spid15s Creating procedure sysmail_help_principalprofile_sp... 2025-06-19 19:51:26.39 spid15s Creating sysmail_logmailevent_sp 2025-06-19 19:51:26.39 spid15s Creating sysmail_start_sp 2025-06-19 19:51:26.39 spid15s Creating sysmail_stop_sp 2025-06-19 19:51:26.40 spid15s Creating sysmail_help_status_sp 2025-06-19 19:51:26.40 spid15s Creating sysmail_help_queue_sp 2025-06-19 19:51:26.41 spid15s Creating sp_SendMailMessage 2025-06-19 19:51:26.41 spid15s Creating sp_isprohibited 2025-06-19 19:51:26.41 spid15s Creating sp_SendMailQueues 2025-06-19 19:51:26.41 spid15s Creating sp_ProcessResponse 2025-06-19 19:51:26.42 spid15s Creating sp_MailItemResultSets 2025-06-19 19:51:26.42 spid15s Creating sp_process_DialogTimer 2025-06-19 19:51:26.42 spid15s Creating sp_readrequest 2025-06-19 19:51:26.43 spid15s Creating sp_GetAttachmentData 2025-06-19 19:51:26.43 spid15s Creating sp_RunMailQuery 2025-06-19 19:51:26.44 spid15s Creating sp_send_dbmail 2025-06-19 19:51:26.45 spid15s Creating sp_ExternalMailQueueListener 2025-06-19 19:51:26.46 spid15s Creating sp_sysmail_activate 2025-06-19 19:51:26.52 spid15s 2025-06-19 19:51:26.52 spid15s Dropping Database Mail MESSAGES, CONTRACTS, QUEUES AND SERVICES... 2025-06-19 19:51:26.52 spid15s 2025-06-19 19:51:26.52 spid15s Dropping SERVICE InternalMailService 2025-06-19 19:51:26.52 spid15s Dropping SERVICE ExternalMailService 2025-06-19 19:51:26.52 spid15s Dropping QUEUE InternalMailQueue 2025-06-19 19:51:26.52 spid15s Dropping QUEUE ExternalMailQueue 2025-06-19 19:51:26.52 spid15s Dropping CONTRACT [//www.microsoft.com/databasemail/contracts/SendMail/v1.0] 2025-06-19 19:51:26.53 spid15s Dropping MESSAGE TYPE [{//www.microsoft.com/databasemail/messages}SendMail] 2025-06-19 19:51:26.53 spid15s Dropping MESSAGE TYPE [{//www.microsoft.com/databasemail/messages}SendMailStatus] 2025-06-19 19:51:26.53 spid15s 2025-06-19 19:51:26.53 spid15s Creating MESSAGES, CONTRACTS, QUEUES AND SERVICES... 2025-06-19 19:51:26.53 spid15s 2025-06-19 19:51:26.53 spid15s Creating MESSAGE TYPE [{//www.microsoft.com/databasemail/messages}SendMail] 2025-06-19 19:51:26.53 spid15s Creating CONTRACT [//www.microsoft.com/databasemail/contracts/SendMail/v1.0] 2025-06-19 19:51:26.53 spid15s Creating QUEUE InternalMailQueue 2025-06-19 19:51:26.53 spid15s Creating QUEUE ExternalMailQueue 2025-06-19 19:51:26.53 spid15s Creating SERVICE InternalMailService ON QUEUE InternalMailQueue 2025-06-19 19:51:26.53 spid15s Creating SERVICE ExternalMailService ON QUEUE ExternalMailQueue 2025-06-19 19:51:26.55 spid15s 2025-06-19 19:51:26.55 spid15s Creating procedure sp_maintplan_delete_log... 2025-06-19 19:51:26.55 spid15s 2025-06-19 19:51:26.55 spid15s Creating procedure sp_maintplan_delete_subplan... 2025-06-19 19:51:26.55 spid15s 2025-06-19 19:51:26.55 spid15s Creating procedure sp_maintplan_update_subplan_tsx... 2025-06-19 19:51:26.55 spid15s 2025-06-19 19:51:26.55 spid15s Creating procedure sp_maintplan_subplans_by_job... 2025-06-19 19:51:26.56 spid15s 2025-06-19 19:51:26.56 spid15s Creating procedure sp_maintplan_open_logentry... 2025-06-19 19:51:26.56 spid15s 2025-06-19 19:51:26.56 spid15s Creating procedure sp_maintplan_close_logentry... 2025-06-19 19:51:26.56 spid15s 2025-06-19 19:51:26.56 spid15s Creating procedure sp_maintplan_update_log... 2025-06-19 19:51:26.56 spid15s 2025-06-19 19:51:26.56 spid15s Creating procedure sp_maintplan_update_subplan... 2025-06-19 19:51:26.56 spid15s 2025-06-19 19:51:26.56 spid15s Creating procedure sp_maintplan_delete_plan... 2025-06-19 19:51:26.57 spid15s 2025-06-19 19:51:26.57 spid15s Creating procedure sp_maintplan_start... 2025-06-19 19:51:26.89 spid15s 2025-06-19 19:51:26.89 spid15s No foreign keys reference table 'sysdbmaintplan_history', or you do not have permissions on referencing tables. 2025-06-19 19:51:26.89 spid15s 2025-06-19 19:51:26.89 spid15s Creating procedure sp_clear_dbmaintplan_by_db... 2025-06-19 19:51:26.89 spid15s 2025-06-19 19:51:26.89 spid15s Creating procedure sp_add_maintenance_plan... 2025-06-19 19:51:26.89 spid15s 2025-06-19 19:51:26.89 spid15s Creating procedure sp_delete_maintenance_plan... 2025-06-19 19:51:26.90 spid15s 2025-06-19 19:51:26.90 spid15s Creating procedure sp_add_maintenance_plan_db... 2025-06-19 19:51:26.90 spid15s 2025-06-19 19:51:26.90 spid15s Creating procedure sp_delete_maintenance_plan_db... 2025-06-19 19:51:26.90 spid15s 2025-06-19 19:51:26.90 spid15s Creating procedure sp_add_maintenance_plan_job... 2025-06-19 19:51:26.90 spid15s 2025-06-19 19:51:26.90 spid15s Creating procedure sp_delete_maintenance_plan_job... 2025-06-19 19:51:26.90 spid15s 2025-06-19 19:51:26.90 spid15s Creating procedure sp_help_maintenance_plan... 2025-06-19 19:51:27.31 spid15s 2025-06-19 19:51:27.31 spid15s Creating procedure sp_delete_database_backuphistory... 2025-06-19 19:51:27.32 spid15s 2025-06-19 19:51:27.32 spid15s Creating procedure sp_delete_backuphistory... 2025-06-19 19:51:27.38 spid15s 2025-06-19 19:51:27.38 spid15s Creating procedure sp_add_log_shipping_monitor_jobs... 2025-06-19 19:51:27.39 spid15s 2025-06-19 19:51:27.39 spid15s Creating procedure sp_add_log_shipping_primary... 2025-06-19 19:51:27.39 spid15s 2025-06-19 19:51:27.39 spid15s Creating procedure sp_add_log_shipping_secondary... 2025-06-19 19:51:27.39 spid15s 2025-06-19 19:51:27.39 spid15s Creating procedure sp_delete_log_shipping_monitor_jobs... 2025-06-19 19:51:27.40 spid15s 2025-06-19 19:51:27.40 spid15s Creating procedure sp_delete_log_shipping_primary... 2025-06-19 19:51:27.40 spid15s 2025-06-19 19:51:27.40 spid15s Creating sp_delete_log_shipping_secondary... 2025-06-19 19:51:27.40 spid15s 2025-06-19 19:51:27.40 spid15s Creating procedure sp_log_shipping_in_sync... 2025-06-19 19:51:27.40 spid15s 2025-06-19 19:51:27.40 spid15s Creating procedure sp_log_shipping_get_date_from_file... 2025-06-19 19:51:27.40 spid15s 2025-06-19 19:51:27.40 spid15s Creating procedure sp_get_log_shipping_monitor_info... 2025-06-19 19:51:27.41 spid15s 2025-06-19 19:51:27.41 spid15s Creating procedure sp_update_log_shipping_monitor_info... 2025-06-19 19:51:27.41 spid15s 2025-06-19 19:51:27.41 spid15s Creating procedure sp_delete_log_shipping_monitor_info... 2025-06-19 19:51:27.41 spid15s 2025-06-19 19:51:27.41 spid15s Creating procedure sp_remove_log_shipping_monitor_account... 2025-06-19 19:51:27.42 spid15s 2025-06-19 19:51:27.42 spid15s Creating procedure sp_log_shipping_monitor_backup... 2025-06-19 19:51:27.42 spid15s 2025-06-19 19:51:27.42 spid15s Creating procedure sp_log_shipping_monitor_restore... 2025-06-19 19:51:27.42 spid15s 2025-06-19 19:51:27.42 spid15s Creating procedure sp_change_monitor_role... 2025-06-19 19:51:27.42 spid15s 2025-06-19 19:51:27.42 spid15s Creating procedure sp_create_log_shipping_monitor_account... 2025-06-19 19:51:27.46 spid15s 2025-06-19 19:51:27.46 spid15s Creating view sysmaintplan_plans... 2025-06-19 19:51:27.51 spid15s The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 2025-06-19 19:51:27.56 spid15s 2025-06-19 19:51:27.56 spid15s Create dc_operator role... 2025-06-19 19:51:27.57 spid15s 2025-06-19 19:51:27.57 spid15s Create dc_admin role... 2025-06-19 19:51:27.58 spid15s 2025-06-19 19:51:27.58 spid15s Create dc_proxy role... 2025-06-19 19:51:27.60 spid15s 2025-06-19 19:51:27.60 spid15s Create loginless user that has ownership of data collector agent-related securables... 2025-06-19 19:51:27.60 spid15s Creating view [dbo].[syscollector_config_store]... 2025-06-19 19:51:27.61 spid15s Creating procedure [dbo].[sp_syscollector_verify_collector_state]... 2025-06-19 19:51:27.61 spid15s 2025-06-19 19:51:27.61 spid15s Creating procedure [dbo].[sp_syscollector_set_warehouse_instance_name]... 2025-06-19 19:51:27.61 spid15s 2025-06-19 19:51:27.61 spid15s Creating procedure [dbo].[sp_syscollector_set_warehouse_database_name]... 2025-06-19 19:51:27.62 spid15s 2025-06-19 19:51:27.62 spid15s Creating procedure [dbo].[sp_syscollector_set_cache_directory]... 2025-06-19 19:51:27.62 spid15s 2025-06-19 19:51:27.62 spid15s Creating procedure [dbo].[sp_syscollector_set_cache_window]... 2025-06-19 19:51:27.62 spid15s 2025-06-19 19:51:27.62 spid15s Creating procedure [dbo].[sp_syscollector_get_warehouse_connection_string]... 2025-06-19 19:51:27.62 spid15s Creating procedure [dbo].[sp_syscollector_snapshot_dm_exec_requests_internal]... 2025-06-19 19:51:27.63 spid15s Creating procedure [dbo].[sp_syscollector_snapshot_dm_exec_query_stats_internal]... 2025-06-19 19:51:27.63 spid15s Creating procedure [dbo].[sp_syscollector_get_query_activity_collection_item_params]... 2025-06-19 19:51:27.64 spid15s Creating procedure [dbo].[sp_syscollector_snapshot_dm_exec_requests]... 2025-06-19 19:51:27.64 spid15s Creating procedure [dbo].[sp_syscollector_snapshot_dm_exec_query_stats]... 2025-06-19 19:51:27.64 spid15s 2025-06-19 19:51:27.64 spid15s Creating function [dbo].[fn_syscollector_highest_incompatible_mdw_version]... 2025-06-19 19:51:27.68 spid15s Creating view [dbo].[syscollector_collection_sets]... 2025-06-19 19:51:27.68 spid15s Creating procedure [dbo].[sp_syscollector_verify_collection_set]... 2025-06-19 19:51:27.70 spid15s Creating procedure [dbo].[sp_syscollector_create_jobs]... 2025-06-19 19:51:27.70 spid15s Creating procedure [dbo].[sp_syscollector_create_collection_set]... 2025-06-19 19:51:27.71 spid15s Creating procedure [dbo].[sp_syscollector_update_job_proxy]... 2025-06-19 19:51:27.71 spid15s Creating procedure [dbo].[sp_syscollector_update_collection_set_internal]... 2025-06-19 19:51:27.71 spid15s Creating procedure [dbo].[sp_syscollector_update_collection_set]... 2025-06-19 19:51:27.73 spid15s 2025-06-19 19:51:27.73 spid15s Creating procedure [dbo].[sp_syscollector_configure_sql_dumper]... 2025-06-19 19:51:27.73 spid15s Creating function [dbo].[fn_syscollector_get_package_path]... 2025-06-19 19:51:27.73 spid15s Creating view [dbo].[syscollector_collector_types]... 2025-06-19 19:51:27.73 spid15s Creating procedure [dbo].[sp_syscollector_verify_collector_type]... 2025-06-19 19:51:27.74 spid15s Creating procedure [dbo].[sp_syscollector_create_collector_type]... 2025-06-19 19:51:27.74 spid15s Creating procedure [dbo].[sp_syscollector_update_collector_type]... 2025-06-19 19:51:27.74 spid15s Creating procedure [dbo].[sp_syscollector_validate_xml]... 2025-06-19 19:51:27.76 spid15s Creating view [dbo].[syscollector_collection_items]... 2025-06-19 19:51:27.76 spid15s Creating procedure [dbo].[sp_syscollector_delete_collector_type]... 2025-06-19 19:51:27.76 spid15s Creating procedure [dbo].[sp_syscollector_verify_collection_item]... 2025-06-19 19:51:27.77 spid15s Creating procedure [dbo].[sp_syscollector_create_collection_item]... 2025-06-19 19:51:27.77 spid15s Creating procedure [dbo].[sp_syscollector_update_collection_item_internal]... 2025-06-19 19:51:27.77 spid15s Creating procedure [dbo].[sp_syscollector_update_collection_item]... 2025-06-19 19:51:27.78 spid15s Creating procedure [dbo].[sp_syscollector_delete_collection_item_internal]... 2025-06-19 19:51:27.78 spid15s Creating procedure [dbo].[sp_syscollector_delete_collection_item]... 2025-06-19 19:51:27.78 spid15s 2025-06-19 19:51:27.78 spid15s Creating procedure [dbo].[sp_syscollector_start_collection_set]... 2025-06-19 19:51:27.79 spid15s 2025-06-19 19:51:27.79 spid15s Creating procedure [dbo].[sp_syscollector_stop_collection_set]... 2025-06-19 19:51:27.79 spid15s Creating procedure [dbo].[sp_syscollector_get_collection_set_execution_status]... 2025-06-19 19:51:27.79 spid15s 2025-06-19 19:51:27.79 spid15s Creating procedure [dbo].[sp_syscollector_upload_collection_set]... 2025-06-19 19:51:27.80 spid15s 2025-06-19 19:51:27.80 spid15s Creating procedure [dbo].[sp_syscollector_run_collection_set]... 2025-06-19 19:51:27.81 spid15s Creating trigger [dbo].[syscollector_collection_set_is_running_update_trigger] on [dbo].[syscollector_collection_sets_internal] 2025-06-19 19:51:27.81 spid15s 2025-06-19 19:51:27.81 spid15s Creating stored procedure syscollector_stop_collection_set_jobs... 2025-06-19 19:51:27.82 spid15s 2025-06-19 19:51:27.82 spid15s Creating stored procedure syscollector_start_collection_set_jobs... 2025-06-19 19:51:27.82 spid15s 2025-06-19 19:51:27.82 spid15s Creating view syscollector_execution_log... 2025-06-19 19:51:27.82 spid15s Creating procedure [dbo].[sp_syscollector_delete_jobs]... 2025-06-19 19:51:27.82 spid15s 2025-06-19 19:51:27.82 spid15s Creating view syscollector_execution_stats... 2025-06-19 19:51:27.83 spid15s 2025-06-19 19:51:27.83 spid15s Creating stored procedure sp_syscollector_verify_event_log_id... 2025-06-19 19:51:27.83 spid15s 2025-06-19 19:51:27.83 spid15s Creating stored procedure sp_syscollector_event_oncollectionstart... 2025-06-19 19:51:27.83 spid15s 2025-06-19 19:51:27.83 spid15s Creating stored procedure sp_syscollector_event_oncollectionstop... 2025-06-19 19:51:27.83 spid15s 2025-06-19 19:51:27.83 spid15s Creating stored procedure sp_syscollector_event_oncollectionbegin... 2025-06-19 19:51:27.83 spid15s 2025-06-19 19:51:27.83 spid15s Creating stored procedure sp_syscollector_event_oncollectionend... 2025-06-19 19:51:27.84 spid15s 2025-06-19 19:51:27.84 spid15s Creating stored procedure sp_syscollector_event_onpackagebegin... 2025-06-19 19:51:27.84 spid15s 2025-06-19 19:51:27.84 spid15s Creating stored procedure sp_syscollector_event_onpackageend... 2025-06-19 19:51:27.84 spid15s 2025-06-19 19:51:27.84 spid15s Creating stored procedure sp_syscollector_event_onpackageupdate... 2025-06-19 19:51:27.84 spid15s 2025-06-19 19:51:27.84 spid15s Creating stored procedure sp_syscollector_event_onerror... 2025-06-19 19:51:27.84 spid15s 2025-06-19 19:51:27.84 spid15s Creating stored procedure sp_syscollector_event_onstatsupdate... 2025-06-19 19:51:27.85 spid15s 2025-06-19 19:51:27.85 spid15s Creating function [dbo].[fn_syscollector_find_collection_set_root] ... 2025-06-19 19:51:27.85 spid15s 2025-06-19 19:51:27.85 spid15s Creating function [dbo].[fn_syscollector_get_execution_log_tree] ... 2025-06-19 19:51:27.85 spid15s 2025-06-19 19:51:27.85 spid15s Creating function [dbo].[fn_syscollector_get_execution_stats] ... 2025-06-19 19:51:27.85 spid15s 2025-06-19 19:51:27.85 spid15s Creating function [dbo].[fn_syscollector_get_execution_details] ... 2025-06-19 19:51:27.85 spid15s 2025-06-19 19:51:27.85 spid15s Creating view syscollector_execution_log_full... 2025-06-19 19:51:27.86 spid15s Creating procedure [dbo].[sp_syscollector_delete_execution_log_tree] ... 2025-06-19 19:51:27.86 spid15s Creating procedure [dbo].[sp_syscollector_delete_collection_set_internal]... 2025-06-19 19:51:27.86 spid15s Creating procedure [dbo].[sp_syscollector_delete_collection_set]... 2025-06-19 19:51:27.86 spid15s 2025-06-19 19:51:27.86 spid15s Creating stored procedure sp_syscollector_purge_collection_logs... 2025-06-19 19:51:27.87 spid15s Creating procedure [dbo].[sp_syscollector_enable_collector]... 2025-06-19 19:51:27.87 spid15s Creating procedure [dbo].[sp_syscollector_disable_collector]... 2025-06-19 19:51:27.87 spid15s Creating procedure [dbo].[sp_syscollector_get_trace_info]... 2025-06-19 19:51:27.87 spid15s Creating procedure [dbo].[sp_syscollector_text_query_plan_lookpup]... 2025-06-19 19:51:27.88 spid15s Creating procedure [dbo].[sp_syscollector_sql_text_lookup]... 2025-06-19 19:51:27.88 spid15s Installing out of the box Collector objects 2025-06-19 19:51:27.88 spid15s 2025-06-19 19:51:27.95 spid15s Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. 2025-06-19 19:51:27.95 spid15s Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. 2025-06-19 19:51:27.95 spid15s Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install. 2025-06-19 19:51:27.95 spid15s Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install. 2025-06-19 19:51:27.96 spid15s Creating SSIS folders... 2025-06-19 19:51:27.96 spid15s Creating procedure [dbo].[sp_syscollector_get_instmdw]... 2025-06-19 19:51:27.97 spid15s Creating procedure [dbo].[sp_syscollector_upload_instmdw]... 2025-06-19 19:51:27.98 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\SqlTraceCollect.dtsx 2025-06-19 19:51:27.98 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\SqlTraceCollect.dtsx 2025-06-19 19:51:27.99 spid15s Loaded 37732 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\SqlTraceCollect.dtsx' 2025-06-19 19:51:28.01 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\SqlTraceUpload.dtsx 2025-06-19 19:51:28.01 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\SqlTraceUpload.dtsx 2025-06-19 19:51:28.05 spid15s Loaded 693081 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\SqlTraceUpload.dtsx' 2025-06-19 19:51:28.07 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\TSQLQueryCollect.dtsx 2025-06-19 19:51:28.07 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\TSQLQueryCollect.dtsx 2025-06-19 19:51:28.08 spid15s Loaded 20989 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\TSQLQueryCollect.dtsx' 2025-06-19 19:51:28.08 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\TSQLQueryUpload.dtsx 2025-06-19 19:51:28.08 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\TSQLQueryUpload.dtsx 2025-06-19 19:51:28.09 spid15s Loaded 16576 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\TSQLQueryUpload.dtsx' 2025-06-19 19:51:28.10 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\PerfCountersCollect.dtsx 2025-06-19 19:51:28.10 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\PerfCountersCollect.dtsx 2025-06-19 19:51:28.10 spid15s Loaded 63074 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\PerfCountersCollect.dtsx' 2025-06-19 19:51:28.11 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\PerfCountersUpload.dtsx 2025-06-19 19:51:28.11 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\PerfCountersUpload.dtsx 2025-06-19 19:51:28.12 spid15s Loaded 164276 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\PerfCountersUpload.dtsx' 2025-06-19 19:51:28.12 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\QueryActivityCollect.dtsx 2025-06-19 19:51:28.12 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\QueryActivityCollect.dtsx 2025-06-19 19:51:28.14 spid15s Loaded 305787 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\QueryActivityCollect.dtsx' 2025-06-19 19:51:28.15 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\QueryActivityUpload.dtsx 2025-06-19 19:51:28.15 spid15s Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\QueryActivityUpload.dtsx 2025-06-19 19:51:28.20 spid15s Loaded 1647171 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Install\QueryActivityUpload.dtsx' 2025-06-19 19:51:28.24 spid15s Creating or updating Collection Types... 2025-06-19 19:51:28.24 spid15s Updating Performance counters collector type 2025-06-19 19:51:28.28 spid15s Updating TSQL Query collector type 2025-06-19 19:51:28.28 spid15s Creating trigger [dbo].[syscollector_collection_item_parameter_update_trigger] on [dbo].[syscollector_collection_items_internal] 2025-06-19 19:51:28.29 spid15s Creating trigger [dbo].[syscollector_tsql_query_collector_delete_trigger] on [dbo].[syscollector_tsql_query_collector] 2025-06-19 19:51:28.29 spid15s Creating procedure [dbo].[sp_syscollector_create_tsql_query_collector]... 2025-06-19 19:51:28.29 spid15s Creating procedure [dbo].[sp_syscollector_get_tsql_query_collector_package_ids]... 2025-06-19 19:51:28.29 spid15s Creating procedure [dbo].[sp_syscollector_cleanup_collector] ... 2025-06-19 19:51:28.30 spid15s Updating SQL Trace collector type 2025-06-19 19:51:28.32 spid15s Updating Query Activity Collector Type 2025-06-19 19:51:28.37 spid15s Creating data collector schedules 2025-06-19 19:51:28.38 spid15s Creating system Collection Sets... 2025-06-19 19:51:28.38 spid15s Updating system Collection Set "Disk Usage"... 2025-06-19 19:51:28.43 spid15s Updating Collection Item "Disk Usage - Data Files"... 2025-06-19 19:51:28.45 spid15s Updating Collection Item "Disk Usage - Log Files"... 2025-06-19 19:51:28.46 spid15s Updating system Collection Set "Server Activity"... 2025-06-19 19:51:28.47 spid15s Updating Collection Item "Server Activity - DMV Snapshots"... 2025-06-19 19:51:28.47 spid15s Updating Collection Item "Server Activity - Performance Counters"... 2025-06-19 19:51:28.48 spid15s Updating system Collection Set "Query Statistics"... 2025-06-19 19:51:28.48 spid15s Updating Collection Item "Query Statistics - Query Activity"... 2025-06-19 19:51:28.49 spid15s Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. 2025-06-19 19:51:28.49 spid15s Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. 2025-06-19 19:51:28.49 spid15s Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. 2025-06-19 19:51:28.49 spid15s Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. 2025-06-19 19:51:28.49 spid15s 2025-06-19 19:51:28.49 spid15s Granting permissions to data collector roles... 2025-06-19 19:51:28.52 spid15s Object "[dbo].[sp_syspolicy_add_target_set_condition_reference]" does not exist, will not drop 2025-06-19 19:51:28.52 spid15s Object "[dbo].[sp_syspolicy_update_target_set_condition_reference]" does not exist, will not drop 2025-06-19 19:51:28.52 spid15s Object "[dbo].[syspolicy_target_set_condition_references]" does not exist, will not drop 2025-06-19 19:51:28.53 spid15s Object "[dbo].[syspolicy_update_condition_trigger]" does not exist, will not drop 2025-06-19 19:51:28.53 spid15s Executing "drop TRIGGER [dbo].[syspolicy_validate_events]" 2025-06-19 19:51:28.53 spid15s Done dropping all DMF and Shared Registered Server procedures 2025-06-19 19:51:28.55 spid15s Creating trigger [sysmanagement_delete_shared_server_group_trigger]... 2025-06-19 19:51:28.57 spid15s Creating view [dbo].[sysmanagement_shared_server_groups]... 2025-06-19 19:51:28.57 spid15s Creating view [dbo].[sysmanagement_shared_registered_servers]... 2025-06-19 19:51:28.57 spid15s Creating procedure [dbo].[sp_sysmanagement_verify_shared_server_type]... 2025-06-19 19:51:28.58 spid15s Creating procedure [dbo].[sp_sysmanagement_add_shared_server_group]... 2025-06-19 19:51:28.58 spid15s Creating procedure [dbo].[sp_sysmanagement_add_shared_registered_server]... 2025-06-19 19:51:28.58 spid15s Creating procedure [dbo].[sp_sysmanagement_delete_shared_server_group]... 2025-06-19 19:51:28.58 spid15s Creating procedure [dbo].[sp_sysmanagement_delete_shared_registered_server]... 2025-06-19 19:51:28.59 spid15s Creating procedure [dbo].[sp_sysmanagement_move_shared_server_group]... 2025-06-19 19:51:28.59 spid15s Creating procedure [dbo].[sp_sysmanagement_move_shared_registered_server]... 2025-06-19 19:51:28.59 spid15s Creating procedure [dbo].[sp_sysmanagement_update_shared_server_group]... 2025-06-19 19:51:28.60 spid15s Creating procedure [dbo].[sp_sysmanagement_update_shared_registered_server]... 2025-06-19 19:51:28.60 spid15s Creating procedure [dbo].[sp_sysmanagement_rename_shared_server_group]... 2025-06-19 19:51:28.60 spid15s Creating procedure [dbo].[sp_sysmanagement_rename_shared_registered_server]... 2025-06-19 19:51:28.93 spid15s Creating view [dbo].[syspolicy_conditions]... 2025-06-19 19:51:28.94 spid15s Creating procedure [dbo].[sp_syspolicy_add_condition]... 2025-06-19 19:51:28.94 spid15s Creating procedure [dbo].[sp_syspolicy_verify_condition_identifiers]... 2025-06-19 19:51:28.94 spid15s Creating procedure [dbo].[sp_syspolicy_update_condition]... 2025-06-19 19:51:28.95 spid15s Creating procedure [dbo].[sp_syspolicy_delete_condition]... 2025-06-19 19:51:28.95 spid15s Creating procedure [dbo].[sp_syspolicy_rename_condition]... 2025-06-19 19:51:28.96 spid15s Creating view [dbo].[syspolicy_policy_categories]... 2025-06-19 19:51:28.98 spid15s Creating view [dbo].[syspolicy_object_sets]... 2025-06-19 19:51:28.98 spid15s Creating procedure [dbo].[sp_syspolicy_verify_object_set_identifiers]... 2025-06-19 19:51:28.98 spid15s Creating procedure [dbo].[sp_syspolicy_verify_object_set_references]... 2025-06-19 19:51:28.99 spid15s Creating procedure [dbo].[sp_syspolicy_add_object_set]... 2025-06-19 19:51:28.99 spid15s Creating procedure [dbo].[sp_syspolicy_delete_object_set]... 2025-06-19 19:51:29.00 spid15s Creating procedure [dbo].[sp_syspolicy_create_job]... 2025-06-19 19:51:29.00 spid15s Creating function [dbo].[fn_syspolicy_get_ps_command] ... 2025-06-19 19:51:29.01 spid15s Creating trigger [dbo].[syspolicy_insert_job_create_trigger] on [dbo].[syspolicy_policies_internal] 2025-06-19 19:51:29.02 spid15s Creating trigger [dbo].[syspolicy_update_job_update_trigger] on [dbo].[syspolicy_policies_internal] 2025-06-19 19:51:29.03 spid15s Creating trigger [dbo].[syspolicy_insert_policy_trigger] on [dbo].[syspolicy_policies_internal] 2025-06-19 19:51:29.03 spid15s Creating trigger [dbo].[syspolicy_update_policy_trigger] on [dbo].[syspolicy_policies_internal] 2025-06-19 19:51:29.04 spid15s Creating trigger [dbo].[syspolicy_delete_job_delete_trigger] on [dbo].[syspolicy_policies_internal] 2025-06-19 19:51:29.04 spid15s Creating trigger [dbo].[syspolicy_instead_delete_policy_trigger] on [dbo].[syspolicy_policies_internal] 2025-06-19 19:51:29.04 spid15s Creating view [dbo].[syspolicy_policies]... 2025-06-19 19:51:29.05 spid15s 2025-06-19 19:51:29.05 spid15s Creating trigger syspolicy_insert_condition_trigger... 2025-06-19 19:51:29.05 spid15s 2025-06-19 19:51:29.05 spid15s Creating trigger dbo.syspolicy_for_update_condition_trigger... 2025-06-19 19:51:29.06 spid15s 2025-06-19 19:51:29.06 spid15s Creating trigger syspolicy_after_update_condition_trigger... 2025-06-19 19:51:29.06 spid15s Creating procedure [dbo].[sp_syspolicy_verify_policy_category_identifiers]... 2025-06-19 19:51:29.06 spid15s Creating procedure [dbo].[sp_syspolicy_add_policy_category]... 2025-06-19 19:51:29.06 spid15s Creating procedure [dbo].[sp_syspolicy_delete_policy_category]... 2025-06-19 19:51:29.07 spid15s Creating procedure [dbo].[sp_syspolicy_rename_policy_category]... 2025-06-19 19:51:29.07 spid15s Creating procedure [dbo].[sp_syspolicy_update_policy_category]... 2025-06-19 19:51:29.07 spid15s Creating procedure [dbo].[sp_syspolicy_add_policy]... 2025-06-19 19:51:29.08 spid15s Creating procedure [dbo].[sp_syspolicy_verify_policy_identifiers]... 2025-06-19 19:51:29.08 spid15s Creating procedure [dbo].[sp_syspolicy_rename_policy]... 2025-06-19 19:51:29.08 spid15s Creating procedure [dbo].[sp_syspolicy_update_policy]... 2025-06-19 19:51:29.08 spid15s Creating procedure [dbo].[sp_syspolicy_delete_policy]... 2025-06-19 19:51:29.09 spid15s Creating function [dbo].[syspolicy_fn_get_bad_filters]... 2025-06-19 19:51:29.09 spid15s Creating view [dbo].[syspolicy_target_sets]... 2025-06-19 19:51:29.09 spid15s Creating view [dbo].[syspolicy_target_set_levels]... 2025-06-19 19:51:29.10 spid15s Creating procedure [dbo].[sp_syspolicy_add_target_set]... 2025-06-19 19:51:29.10 spid15s Creating procedure [dbo].[sp_syspolicy_update_target_set]... 2025-06-19 19:51:29.10 spid15s Creating procedure [dbo].[sp_syspolicy_delete_target_set]... 2025-06-19 19:51:29.10 spid15s Creating procedure [dbo].[sp_syspolicy_add_target_set_level]... 2025-06-19 19:51:29.10 spid15s Creating procedure [dbo].[sp_syspolicy_update_target_set_level]... 2025-06-19 19:51:29.11 spid15s Creating function [dbo].[syspolicy_fn_eventing_filter] 2025-06-19 19:51:29.11 spid15s Creating function [dbo].[syspolicy_fn_filter_complete] 2025-06-19 19:51:29.11 spid15s Creating trigger [dbo].[syspolicy_insert_target_set_level_trigger] on [dbo].[syspolicy_target_set_levels_internal] 2025-06-19 19:51:29.11 spid15s Creating trigger [dbo].[syspolicy_update_target_set_level_trigger] on [dbo].[syspolicy_target_set_levels_internal] 2025-06-19 19:51:29.12 spid15s Creating trigger [dbo].[syspolicy_insert_target_set_trigger] on [dbo].[syspolicy_target_sets_internal] 2025-06-19 19:51:29.12 spid15s Creating trigger [dbo].[syspolicy_delete_target_set_trigger] on [dbo].[syspolicy_target_sets_internal] 2025-06-19 19:51:29.13 spid15s Creating view [dbo].[syspolicy_policy_category_subscriptions]... 2025-06-19 19:51:29.14 spid15s Creating procedure [dbo].[sp_syspolicy_add_policy_category_subscription]... 2025-06-19 19:51:29.14 spid15s Creating procedure [dbo].[sp_syspolicy_update_policy_category_subscription]... 2025-06-19 19:51:29.14 spid15s Creating procedure [dbo].[sp_syspolicy_delete_policy_category_subscription]... 2025-06-19 19:51:29.17 spid15s Creating trigger [syspolicy_update_system_health_state]... 2025-06-19 19:51:29.19 spid15s Creating procedure [dbo].[sp_syspolicy_log_policy_execution_start]... 2025-06-19 19:51:29.19 spid15s Creating procedure [dbo].[sp_syspolicy_log_policy_execution_end]... 2025-06-19 19:51:29.19 spid15s Creating procedure [dbo].[sp_syspolicy_log_policy_execution_detail]... 2025-06-19 19:51:29.20 spid15s Creating procedure [dbo].[sp_syspolicy_delete_policy_execution_history]... 2025-06-19 19:51:29.20 spid15s Creating procedure [dbo].[sp_syspolicy_mark_system]... 2025-06-19 19:51:29.20 spid15s Creating function [dbo].[syspolicy_fn_get_type_name]... 2025-06-19 19:51:29.21 spid15s Creating procedure [dbo].[sp_syspolicy_dispatch_event]... 2025-06-19 19:51:29.21 spid15s Dropping service [syspolicy_event_listener]... 2025-06-19 19:51:29.22 spid15s Dropping queue [syspolicy_event_queue]... 2025-06-19 19:51:29.23 spid15s Creating queue [syspolicy_event_queue]... 2025-06-19 19:51:29.24 spid15s Creating service [syspolicy_event_listener]... 2025-06-19 19:51:29.24 spid15s Creating view [dbo].[syspolicy_configuration] ... 2025-06-19 19:51:29.24 spid15s Creating procedure [dbo].[sp_syspolicy_set_config_history_retention] ... 2025-06-19 19:51:29.24 spid15s Creating procedure [dbo].[sp_syspolicy_set_log_on_success] ... 2025-06-19 19:51:29.25 spid15s Creating procedure [dbo].[sp_syspolicy_set_config_enabled] ... 2025-06-19 19:51:29.25 spid15s Creating procedure [dbo].[sp_syspolicy_configure] ... 2025-06-19 19:51:29.25 spid15s Creating function [dbo].[fn_syspolicy_is_automation_enabled] ... 2025-06-19 19:51:29.25 spid15s Creating procedure [dbo].[sp_syspolicy_repair_policy_automation] ... 2025-06-19 19:51:29.26 spid15s Creating procedure [dbo].[sp_syspolicy_purge_history] ... 2025-06-19 19:51:29.27 spid15s Creating procedure [dbo].[sp_syspolicy_create_purge_job] ... 2025-06-19 19:51:29.27 spid15s Creating procedure [dbo].[sp_syspolicy_purge_health_state] ... 2025-06-19 19:51:29.47 spid15s Error: 15138, Severity: 16, State: 1. 2025-06-19 19:51:29.47 spid15s The database principal owns a schema in the database, and cannot be dropped. 2025-06-19 19:51:29.47 spid15s The failed batch of t-sql statements : -- Do not recreate the user for Managed instance (EngineEdition 8). -- Recreation of the existing login does not happen for MI, so we don't need to recreate the user. IF EXISTS (SELECT * from sys.database_principals where name = N'##MS_PolicyEventProcessingLogin##') AND SERVERPROPERTY('EngineEdition') <> 8 DROP USER [##MS_PolicyEventProcessingLogin##] 2025-06-19 19:51:29.47 spid15s Error: 912, Severity: 21, State: 2. 2025-06-19 19:51:29.47 spid15s Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 15138, state 1, severity 16. 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. 2025-06-19 19:51:29.48 spid15s Error: 3417, Severity: 21, State: 3. 2025-06-19 19:51:29.48 spid15s 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. 2025-06-19 19:51:29.48 spid15s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. 2025-06-19 19:51:29.49 spid20s The SQL Server Network Interface library could not deregister the Service Principal Name (SPN) [ MSSQLSvc/city-win-SQL05.oxcity.local ] for the SQL Server service. Error: 0x2af9, state: 61. Administrator should deregister this SPN manually to avoid client authentication errors. 2025-06-19 19:51:29.49 spid20s The SQL Server Network Interface library could not deregister the Service Principal Name (SPN) [ MSSQLSvc/city-win-SQL05.oxcity.local:1433 ] for the SQL Server service. Error: 0x2af9, state: 61. Administrator should deregister this SPN manually to avoid client authentication errors.