2023-03-09 20:03:13.91 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Data Center Edition (64-bit) on Windows NT 6.2 (Build 9200: ) 2023-03-09 20:03:13.92 Server (c) Microsoft Corporation. 2023-03-09 20:03:13.92 Server All rights reserved. 2023-03-09 20:03:13.92 Server Server process ID is 6584. 2023-03-09 20:03:13.92 Server System Manufacturer: 'Dell Inc.', System Model: 'PowerEdge T630'. 2023-03-09 20:03:13.92 Server Authentication mode is MIXED. 2023-03-09 20:03:13.92 Server Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2023-03-09 20:03:13.92 Server Registry startup parameters: -d D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf -e D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG -l D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2023-03-09 20:03:13.92 Server Command Line Startup Parameters: -m SqlSetup -f -Q -q Chinese_PRC_CI_AS -T 4022 -T 4010 -T 3659 -T 3610 2023-03-09 20:03:13.92 Server Warning: The server instance was started using minimal configuration startup option (-f). Starting an instance of SQL Server with minimal configuration places the server in single-user mode automatically. After the server has been started with minimal configuration, you should change the appropriate server option value or values, stop, and then restart the server. 2023-03-09 20:03:13.92 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2023-03-09 20:03:13.92 Server Detected 48 CPUs. This is an informational message; no user action is required. 2023-03-09 20:03:13.92 Server Cannot use Large Page Extensions: lock memory privilege was not granted. 2023-03-09 20:03:14.77 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled. 2023-03-09 20:03:15.19 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-03-09 20:03:15.19 Server Lock partitioning is enabled. This is an informational message only. No user action is required. 2023-03-09 20:03:15.21 Server Node configuration: node 0: CPU mask: 0x0000ffffffffffff:0 Active CPU mask: 0x0000ffffffffffff: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-03-09 20:03:15.22 Server Support for distributed transactions was not enabled for this instance of the Database Engine because it was started using the minimal configuration option. This is an informational message only. No user action is required. 2023-03-09 20:03:15.23 spid4s Warning ****************** 2023-03-09 20:03:15.23 spid4s SQL Server started in single-user mode. This an informational message only. No user action is required. 2023-03-09 20:03:15.23 spid4s Starting up database 'master'. 2023-03-09 20:03:15.24 spid4s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2023-03-09 20:03:15.25 spid4s SQL Server was started using the -f flag. SQL Server Audit is disabled. This is an informational message. No user action is required. 2023-03-09 20:03:15.25 spid4s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. 2023-03-09 20:03:15.25 spid4s Server started with '-f' option. Auditing will not be started. This is an informational message only; no user action is required. 2023-03-09 20:03:15.25 spid4s Starting up database 'mssqlsystemresource'. 2023-03-09 20:03:15.26 spid4s The resource database build version is 10.50.1600. This is an informational message only. No user action is required. 2023-03-09 20:03:15.29 spid4s Password policy update was successful. 2023-03-09 20:03:15.29 spid8s Starting up database 'model'. 2023-03-09 20:03:15.29 spid4s Server name is 'CHINAMI-LEC2PB7'. This is an informational message only. No user action is required. 2023-03-09 20:03:15.31 spid8s Clearing tempdb database. 2023-03-09 20:03:15.33 Server A self-generated certificate was successfully loaded for encryption. 2023-03-09 20:03:15.33 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. 2023-03-09 20:03:15.33 Server 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. 2023-03-09 20:03:15.33 spid8s Starting up database 'tempdb'. 2023-03-09 20:03:15.34 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies. 2023-03-09 20:03:15.34 Server SQL Server is now ready for client connections. This is an informational message; no user action is required. 2023-03-09 20:03:15.47 spid8s A new instance of the full-text filter daemon host process has been successfully started. 2023-03-09 20:03:15.49 spid4s Warning ****************** 2023-03-09 20:03:15.49 spid4s Attempting to change default collation to Chinese_PRC_CI_AS. 2023-03-09 20:03:15.50 spid4s index restored for master.syspriorities. 2023-03-09 20:03:15.51 spid4s index restored for master.sysbrickfiles. 2023-03-09 20:03:15.51 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.51 spid4s index restored for master.sysowners. 2023-03-09 20:03:15.51 spid4s index restored for master.sysdbreg. 2023-03-09 20:03:15.52 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.52 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.52 spid4s index restored for master.sysschobjs. 2023-03-09 20:03:15.52 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.52 spid4s index restored for master.syscolpars. 2023-03-09 20:03:15.52 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.53 spid4s index restored for master.sysxlgns. 2023-03-09 20:03:15.53 spid4s index restored for master.sysxsrvs. 2023-03-09 20:03:15.53 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.53 spid4s index restored for master.sysnsobjs. 2023-03-09 20:03:15.53 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.53 spid4s index restored for master.syscerts. 2023-03-09 20:03:15.53 spid4s index restored for master.sysrmtlgns. 2023-03-09 20:03:15.53 spid4s index restored for master.sysxprops. 2023-03-09 20:03:15.54 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.54 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.54 spid4s index restored for master.sysscalartypes. 2023-03-09 20:03:15.54 spid4s index restored for master.sysidxstats. 2023-03-09 20:03:15.54 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.54 spid4s index restored for master.sysendpts. 2023-03-09 20:03:15.54 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.54 spid4s index restored for master.sysclsobjs. 2023-03-09 20:03:15.54 spid4s index restored for master.sysremsvcbinds. 2023-03-09 20:03:15.55 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.55 spid4s index restored for master.sysrts. 2023-03-09 20:03:15.55 spid4s index restored for master.sysasymkeys. 2023-03-09 20:03:15.55 spid4s index restored for master.syssqlguides. 2023-03-09 20:03:15.55 spid4s index restored for master.syssoftobjrefs. 2023-03-09 20:03:15.56 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.56 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.57 spid4s index restored for master.spt_values. 2023-03-09 20:03:15.57 spid4s index restored for master.MSreplication_options. 2023-03-09 20:03:15.58 spid4s index restored for tempdb.syspriorities. 2023-03-09 20:03:15.58 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.58 spid4s index restored for tempdb.sysowners. 2023-03-09 20:03:15.58 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.58 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.58 spid4s index restored for tempdb.sysschobjs. 2023-03-09 20:03:15.58 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.59 spid4s index restored for tempdb.syscolpars. 2023-03-09 20:03:15.59 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.59 spid4s index restored for tempdb.sysnsobjs. 2023-03-09 20:03:15.59 spid4s index restored for tempdb.syscerts. 2023-03-09 20:03:15.59 spid4s index restored for tempdb.sysxprops. 2023-03-09 20:03:15.59 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.59 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.59 spid4s index restored for tempdb.sysscalartypes. 2023-03-09 20:03:15.59 spid4s index restored for tempdb.sysidxstats. 2023-03-09 20:03:15.60 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.60 spid4s index restored for tempdb.sysclsobjs. 2023-03-09 20:03:15.60 spid4s index restored for tempdb.sysremsvcbinds. 2023-03-09 20:03:15.60 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.60 spid4s index restored for tempdb.sysrts. 2023-03-09 20:03:15.60 spid4s index restored for tempdb.sysasymkeys. 2023-03-09 20:03:15.60 spid4s index restored for tempdb.syssqlguides. 2023-03-09 20:03:15.60 spid4s index restored for tempdb.syssoftobjrefs. 2023-03-09 20:03:15.61 spid4s index restored for model.syspriorities. 2023-03-09 20:03:15.62 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.62 spid4s index restored for model.sysowners. 2023-03-09 20:03:15.62 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.62 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.62 spid4s index restored for model.sysschobjs. 2023-03-09 20:03:15.62 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.62 spid4s index restored for model.syscolpars. 2023-03-09 20:03:15.63 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.63 spid4s index restored for model.sysnsobjs. 2023-03-09 20:03:15.63 spid4s index restored for model.syscerts. 2023-03-09 20:03:15.63 spid4s index restored for model.sysxprops. 2023-03-09 20:03:15.63 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.63 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.63 spid4s index restored for model.sysscalartypes. 2023-03-09 20:03:15.63 spid4s index restored for model.sysidxstats. 2023-03-09 20:03:15.63 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.64 spid4s index restored for model.sysclsobjs. 2023-03-09 20:03:15.64 spid4s index restored for model.sysremsvcbinds. 2023-03-09 20:03:15.64 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.64 spid4s index restored for model.sysrts. 2023-03-09 20:03:15.64 spid4s index restored for model.sysasymkeys. 2023-03-09 20:03:15.64 spid4s index restored for model.syssqlguides. 2023-03-09 20:03:15.64 spid4s index restored for model.syssoftobjrefs. 2023-03-09 20:03:15.64 spid4s Starting up database 'msdb'. 2023-03-09 20:03:15.68 spid4s index restored for msdb.syspriorities. 2023-03-09 20:03:15.68 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.68 spid4s index restored for msdb.sysowners. 2023-03-09 20:03:15.69 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.69 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.70 spid4s index restored for msdb.sysschobjs. 2023-03-09 20:03:15.70 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.72 spid4s index restored for msdb.syscolpars. 2023-03-09 20:03:15.72 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.72 spid4s index restored for msdb.sysnsobjs. 2023-03-09 20:03:15.72 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.72 spid4s index restored for msdb.syscerts. 2023-03-09 20:03:15.72 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.72 spid4s index restored for msdb.sysxprops. 2023-03-09 20:03:15.73 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.73 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.73 spid4s index restored for msdb.sysscalartypes. 2023-03-09 20:03:15.73 spid4s index restored for msdb.sysidxstats. 2023-03-09 20:03:15.73 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.73 spid4s index restored for msdb.sysclsobjs. 2023-03-09 20:03:15.73 spid4s index restored for msdb.sysremsvcbinds. 2023-03-09 20:03:15.74 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.74 spid4s index restored for msdb.sysrts. 2023-03-09 20:03:15.74 spid4s index restored for msdb.sysasymkeys. 2023-03-09 20:03:15.74 spid4s index restored for msdb.syssqlguides. 2023-03-09 20:03:15.74 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.75 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.76 spid4s index restored for msdb.syssoftobjrefs. 2023-03-09 20:03:15.76 spid4s index restored for msdb.syspolicy_policies_internal. 2023-03-09 20:03:15.76 spid4s index restored for msdb.sysproxies. 2023-03-09 20:03:15.77 spid4s index restored for msdb.syscollector_execution_stats_internal. 2023-03-09 20:03:15.77 spid4s index restored for msdb.syssubsystems. 2023-03-09 20:03:15.77 spid4s index restored for msdb.log_shipping_primary_secondaries. 2023-03-09 20:03:15.77 spid4s index restored for msdb.sysdownloadlist. 2023-03-09 20:03:15.77 spid4s index restored for msdb.log_shipping_monitor_primary. 2023-03-09 20:03:15.78 spid4s index restored for msdb.sysoriginatingservers. 2023-03-09 20:03:15.78 spid4s index restored for msdb.log_shipping_monitor_history_detail. 2023-03-09 20:03:15.78 spid4s index restored for msdb.log_shipping_monitor_error_detail. 2023-03-09 20:03:15.78 spid4s index restored for msdb.log_shipping_secondary. 2023-03-09 20:03:15.78 spid4s index restored for msdb.log_shipping_secondary_databases. 2023-03-09 20:03:15.79 spid4s index restored for msdb.log_shipping_monitor_secondary. 2023-03-09 20:03:15.79 spid4s index restored for msdb.sysjobs. 2023-03-09 20:03:15.79 spid4s index restored for msdb.sysutility_ucp_mi_file_space_health_internal. 2023-03-09 20:03:15.79 spid4s index restored for msdb.sysutility_ucp_mi_database_health_internal. 2023-03-09 20:03:15.79 spid4s index restored for msdb.syscollector_blobs_internal. 2023-03-09 20:03:15.80 spid4s index restored for msdb.sysutility_mi_dac_execution_statistics_internal. 2023-03-09 20:03:15.80 spid4s index restored for msdb.sysjobsteps. 2023-03-09 20:03:15.80 spid4s index restored for msdb.sysutility_ucp_dac_file_space_health_internal. 2023-03-09 20:03:15.80 spid4s index restored for msdb.logmarkhistory. 2023-03-09 20:03:15.80 spid4s index restored for msdb.sysutility_mi_session_statistics_internal. 2023-03-09 20:03:15.81 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.81 spid4s index restored for msdb.sysdtscategories. 2023-03-09 20:03:15.81 spid4s index restored for msdb.syspolicy_target_sets_internal. 2023-03-09 20:03:15.81 spid4s index restored for msdb.sysutility_ucp_mi_volume_space_health_internal. 2023-03-09 20:03:15.81 spid4s index restored for msdb.sysschedules. 2023-03-09 20:03:15.81 spid4s index restored for msdb.sysdac_instances_internal. 2023-03-09 20:03:15.82 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.82 spid4s index restored for msdb.sysssispackages. 2023-03-09 20:03:15.82 spid4s index restored for msdb.sysutility_ucp_computer_cpu_health_internal. 2023-03-09 20:03:15.82 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.82 spid4s index restored for msdb.sysssispackagefolders. 2023-03-09 20:03:15.82 spid4s index restored for msdb.sysdac_history_internal. 2023-03-09 20:03:15.83 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.83 spid4s index restored for msdb.syscategories. 2023-03-09 20:03:15.83 spid4s index restored for msdb.systargetservers. 2023-03-09 20:03:15.83 spid4s index restored for msdb.systargetservergroups. 2023-03-09 20:03:15.83 spid4s index restored for msdb.syspolicy_policy_category_subscriptions_internal. 2023-03-09 20:03:15.83 spid4s index restored for msdb.sysalerts. 2023-03-09 20:03:15.84 spid4s index restored for msdb.sysoperators. 2023-03-09 20:03:15.84 spid4s index restored for msdb.syspolicy_system_health_state_internal. 2023-03-09 20:03:15.84 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.84 spid4s index restored for msdb.syscollector_config_store_internal. 2023-03-09 20:03:15.84 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.84 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.85 spid4s index restored for msdb.sysmanagement_shared_server_groups_internal. 2023-03-09 20:03:15.85 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.85 spid4s index restored for msdb.sysutility_mi_smo_properties_to_collect_internal. 2023-03-09 20:03:15.85 spid4s index restored for msdb.sysmanagement_shared_registered_servers_internal. 2023-03-09 20:03:15.85 spid4s index restored for msdb.syscachedcredentials. 2023-03-09 20:03:15.86 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.86 spid4s index restored for msdb.syscollector_collection_sets_internal. 2023-03-09 20:03:15.86 spid4s index restored for msdb.sysutility_ucp_dac_health_internal. 2023-03-09 20:03:15.86 spid4s index restored for msdb.MSdbms. 2023-03-09 20:03:15.86 spid4s index restored for msdb.MSdbms_datatype. 2023-03-09 20:03:15.86 spid4s index restored for msdb.sysmail_profile. 2023-03-09 20:03:15.87 spid4s index restored for msdb.sysutility_ucp_managed_instances_internal. 2023-03-09 20:03:15.87 spid4s index restored for msdb.syspolicy_management_facets. 2023-03-09 20:03:15.87 spid4s index restored for msdb.sysutility_ucp_mi_health_internal. 2023-03-09 20:03:15.87 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.87 spid4s index restored for msdb.syscollector_collector_types_internal. 2023-03-09 20:03:15.88 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.88 spid4s index restored for msdb.syspolicy_configuration_internal. 2023-03-09 20:03:15.88 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.88 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.88 spid4s index restored for msdb.syspolicy_facet_events. 2023-03-09 20:03:15.88 spid4s index restored for msdb.sysmail_account. 2023-03-09 20:03:15.89 spid4s index restored for msdb.syspolicy_conditions_internal. 2023-03-09 20:03:15.89 spid4s index restored for msdb.sysutility_ucp_health_policies_internal. 2023-03-09 20:03:15.89 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.89 spid4s index restored for msdb.syscollector_collection_items_internal. 2023-03-09 20:03:15.89 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.90 spid4s index restored for msdb.sysmail_servertype. 2023-03-09 20:03:15.90 spid4s index restored for msdb.sysutility_ucp_filegroups_with_policy_violations_internal. 2023-03-09 20:03:15.90 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.90 spid4s index restored for msdb.sysutility_ucp_policy_check_conditions_internal. 2023-03-09 20:03:15.90 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.90 spid4s index restored for msdb.sysutility_ucp_configuration_internal. 2023-03-09 20:03:15.91 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.91 spid4s index restored for msdb.sysutility_ucp_policy_target_conditions_internal. 2023-03-09 20:03:15.91 spid4s index restored for msdb.sysmail_server. 2023-03-09 20:03:15.91 spid4s index restored for msdb.syspolicy_policy_categories_internal. 2023-03-09 20:03:15.91 spid4s index restored for msdb.syspolicy_object_sets_internal. 2023-03-09 20:03:15.91 spid4s Index creation operation will use 1024 KB of memory specified in the advanced sp_configure option "min memory per query (KB)" instead of 704 KB specified in "index create memory (KB)" option because the former has to be smaller than the latter. 2023-03-09 20:03:15.91 spid4s index restored for msdb.sysmail_configuration. 2023-03-09 20:03:15.92 spid4s index restored for msdb.sysdbmaintplan_databases. 2023-03-09 20:03:15.92 spid4s index restored for msdb.log_shipping_primary_databases. 2023-03-09 20:03:15.94 spid4s The default collation was successfully changed. 2023-03-09 20:03:15.94 spid4s Recovery is complete. This is an informational message only. No user action is required. 2023-03-09 20:03:16.00 spid51 Changed database context to 'master'. 2023-03-09 20:03:16.00 spid51 Changed language setting to us_english. 2023-03-09 20:03:16.03 spid51 Setting database option RECOVERY to FULL for database model. 2023-03-09 20:03:16.05 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. 2023-03-09 20:03:16.05 spid51 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. 2023-03-09 20:03:16.08 spid51 Configuration option 'default language' changed from 0 to 30. Run the RECONFIGURE statement to install. 2023-03-09 20:03:16.08 spid51 Configuration option 'default full-text language' changed from 1033 to 2052. Run the RECONFIGURE statement to install. 2023-03-09 20:03:16.08 spid51 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. 2023-03-09 20:03:16.08 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. 2023-03-09 20:03:16.08 spid51 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. 2023-03-09 20:03:16.10 spid51 Setting database option NEW_BROKER to ON for database tempdb. 2023-03-09 20:03:16.11 spid51 Setting database option NEW_BROKER to ON for database msdb.