Skip to content

Cannot Create Database - Sql2025 Docker Desktop Win11 WSL2 Ubuntu 24.04 #948

@ZarehD

Description

@ZarehD

Create database (using SSMS or sqlcmd) fails with error:
MODIFY FILE encountered operating system error 31(...) while atempting to expand the physical file 'testdb.mdf'

Image
Host:
  Win 11 25H2 (fresh install)
  Docker Desktop (v4.5.1)
  C: (Win11) has ~3.5TB free
  D: (Data) has ~400GB free
Ubuntu:
  No LSB modules are available.
  Distributor ID: Ubuntu
  Description:    Ubuntu 24.04.3 LTS
  Release:        24.04
  Codename:       noble
WSL2:
  WSL version: 2.6.1.0
  Kernel version: 6.6.87.2-1
  WSLg version: 1.0.66
  MSRDC version: 1.2.6353
  Direct3D version: 1.611.1-81528511
  DXCore version: 10.0.26100.1-240331-1435.ge-release
  Windows version: 10.0.26200.7171

Sql2025 Image:

PS> docker pull mcr.microsoft.com/mssql/server:latest

Docker run command:

docker run `
--name mssql `
--restart unless-stopped `
--hostname mssql `
--shm-size 1g `
--cpus 2 `
-m 4GB `
-d `
-p 1433:1433 `
-v D:\Apps\Docker\FileShare\MsSql\Db\Data:/var/opt/mssql/data `
-v D:\Apps\Docker\FileShare\MsSql\Db\Log:/var/opt/mssql/log `
-v D:\Apps\Docker\FileShare\MsSql\Db\Secrets:/var/opt/mssql/secrets `
-e "ACCEPT_EULA=Y" `
-e "MSSQL_SA_PASSWORD=Xxxx1234" `
-e "TZ=America/Los_Angeles" `
mcr.microsoft.com/mssql/server:latest

Using alternate docker run command below, container goes into restart loop w error dumps in logs.

  1. Create a volume in Docker Desktop named mssqldb.
  2. Docker run:
    docker run `
    --name mssql `
    --restart unless-stopped `
    --hostname mssql `
    --shm-size 1g `
    --cpus 2 `
    -m 2GB `
    -d `
    -p 1433:1433 `
    -v mssqldb:/var/opt/mssql `
    -e "ACCEPT_EULA=Y" `
    -e "MSSQL_SA_PASSWORD=Xxxx1234" `
    -e "TZ=America/Los_Angeles" `
    mcr.microsoft.com/mssql/server:latest
    

Container log (clear log, start container):

2025-11-18 21:45:47.086 | SQL Server 2025 will run as non-root by default.
2025-11-18 21:45:47.086 | This container is running as user mssql.
2025-11-18 21:45:47.086 | Your master database file is owned by mssql.
2025-11-18 21:45:47.086 | To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216.
2025-11-18 21:45:51.731 | 2025-11-18 21:45:51.71 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.mdf' to '/var/opt/mssql/data/model_replicatedmaster.mdf'.
2025-11-18 21:45:51.862 | 
2025-11-17 16:00:00.000 | 21:45:51.85 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.ldf' to '/var/opt/mssql/data/model_replicatedmaster.ldf'.
2025-11-18 21:45:51.931 | 
2025-11-17 16:00:00.000 | 21:45:51.92 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_msdbdata.mdf' to '/var/opt/mssql/data/model_msdbdata.mdf'.
2025-11-18 21:45:52.195 | 
2025-11-17 16:00:00.000 | 21:45:52.19 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_msdblog.ldf' to '/var/opt/mssql/data/model_msdblog.ldf'.
2025-11-18 21:45:52.392 | 
2025-11-17 16:00:00.000 | 21:45:52.38 Server      Microsoft SQL Server 2025 (RTM) - 17.0.1000.7 (X64) 
2025-11-18 21:45:52.392 | 
2025-11-18 21:45:52.292 | 	Oct 21 2025 12:05:57 
2025-11-18 21:45:52.392 | 
2025-11-18 21:45:52.292 | 	Copyright (C) 2025 Microsoft Corporation
2025-11-18 21:45:52.393 | 
2025-11-18 21:45:52.292 | 	Enterprise Developer Edition (64-bit) on Linux (Ubuntu 22.04.5 LTS) <X64>
2025-11-18 21:45:52.394 | 
2025-11-17 16:00:00.000 | 21:45:52.39 Server      UTC adjustment: -8:00
2025-11-18 21:45:52.395 | 
2025-11-17 16:00:00.000 | 21:45:52.39 Server      (c) Microsoft Corporation.
2025-11-18 21:45:52.396 | 
2025-11-17 16:00:00.000 | 21:45:52.39 Server      All rights reserved.
2025-11-18 21:45:52.396 | 
2025-11-17 16:00:00.000 | 21:45:52.39 Server      Server process ID is 1008.
2025-11-18 21:45:52.398 | 
2025-11-17 16:00:00.000 | 21:45:52.39 Server      Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.
2025-11-18 21:45:52.399 | 
2025-11-17 16:00:00.000 | 21:45:52.39 Server      Registry startup parameters: 
2025-11-18 21:45:52.399 | 
2025-11-18 21:45:52.298 | 	 -d /var/opt/mssql/data/master.mdf
2025-11-18 21:45:52.399 | 
2025-11-18 21:45:52.298 | 	 -l /var/opt/mssql/data/mastlog.ldf
2025-11-18 21:45:52.399 | 
2025-11-18 21:45:52.298 | 	 -e /var/opt/mssql/log/errorlog
2025-11-18 21:45:52.413 | 
2025-11-17 16:00:00.000 | 21:45:52.40 Server      SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2025-11-18 21:45:52.416 | 
2025-11-17 16:00:00.000 | 21:45:52.41 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2025-11-18 21:45:52.416 | 
2025-11-17 16:00:00.000 | 21:45:52.41 Server      Using conventional memory in the memory manager.
2025-11-18 21:45:52.418 | 
2025-11-17 16:00:00.000 | 21:45:52.41 Server      SQL Server detected the following NUMA node configuration (NUMA Node number 0, Processor Group number 0, CPU Mask 0x000000000000ffff).
2025-11-18 21:45:52.419 | 
2025-11-17 16:00:00.000 | 21:45:52.41 Server      Page exclusion bitmap is enabled.
2025-11-18 21:45:52.481 | 
2025-11-17 16:00:00.000 | 21:45:52.47 Server      Detected 3277 MB of RAM, 1714 MB of available memory, 1714 MB of available page file. This is an informational message; no user action is required.
2025-11-18 21:45:52.482 | 
2025-11-17 16:00:00.000 | 21:45:52.47 Server      Buffer pool extension is not supported on Linux platform.
2025-11-18 21:45:52.490 | 
2025-11-17 16:00:00.000 | 21:45:52.48 Server      Buffer Pool: Allocating 4194304 bytes for 266642 hashPages.
2025-11-18 21:45:52.765 | 
2025-11-17 16:00:00.000 | 21:45:52.76 Server      Buffer pool extension is already disabled. No action is necessary.
2025-11-18 21:45:52.784 | 
2025-11-18 21:45:52.679 | [EnableRbpexForGP] : Rbpex non HS FS Toggled, isGeneralPurpose:[0] 
2025-11-18 21:45:52.785 | 
2025-11-18 21:45:52.680 | [EnableRbpexForLogicalMaster] : Rbpex for LM Toggled
2025-11-18 21:45:52.912 | 
2025-11-18 21:45:52.805 | [RbpexEnableGrowWithoutShrink] : Rbpex Thin Provisioning FS Toggled
2025-11-18 21:45:53.357 | 
2025-11-17 16:00:00.000 | 21:45:53.35 Server      Skipping small memory environment configuration. State 1.
2025-11-18 21:45:53.386 | 
2025-11-18 21:45:53.278 | [INFO] [InitXdbSrvGlobals]: In InitXdbSrvGlobals, FAlternateIoFactorEnabled() = [1]. IsRBPEXEnabledNonHyperscaleEdition() = [0].
2025-11-18 21:45:53.445 | 
2025-11-18 21:45:53.331 | [RSC Capacity config] MaximumNumberOfCachePerDb: 0, MaximumSpaceForCachePerDbInMB: -1, MaximumNumberOfCacheGlobal: -1
2025-11-18 21:45:53.468 | 
2025-11-18 21:45:53.354 | [INFO] [InitServerComponents]: IsRBPEXEnabledNonHyperscaleEdition() = [0], IsSubCoreCPUAllocation = [0], GetSchedulersNumber*100 = [1600], GetCPUCorePercentCap = [1600.000000], EnableResilientBufferPoolExtension = [0], , RbpexEnableShrink (thin provisioning)  = [0], RbpexEnableGrowWithoutShrink = [0].
2025-11-18 21:45:53.484 | 
2025-11-17 16:00:00.000 | 21:45:53.47 Server      Installing Client TLS certificates to the store.
2025-11-18 21:45:53.504 | 
2025-11-17 16:00:00.000 | 21:45:53.49 Server      CPU vectorization level(s) detected:  SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2 AVX512 (F CD BW DQ VL IFMA VBMI VBMI2 VNNI BITALG VPOQCNTDQ BF16)
2025-11-18 21:45:53.567 | 
2025-11-18 21:45:53.451 | SqlInstanceNetworkManager: Finished setting callback functions for network IO tracking in UCS broker.
2025-11-18 21:45:53.600 | 
2025-11-17 16:00:00.000 | 21:45:53.59 Server      Successfully initialized the TLS configuration. Allowed TLS protocol versions are ['1.0 1.1 1.2 1.3']. Allowed TLS ciphers are ['TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_128_GCM_SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA256:AES128-SHA256:AES256-SHA:AES128-SHA:!DHE-RSA-AES256-GCM-SHA384:!DHE-RSA-AES128-GCM-SHA256:!DHE-RSA-AES256-SHA:!DHE-RSA-AES128-SHA'].
2025-11-18 21:45:53.629 | 
2025-11-17 16:00:00.000 | 21:45:53.62 Server      Query Store settings initialized with enabled = 1, 
2025-11-18 21:45:53.641 | 
2025-11-17 16:00:00.000 | 21:45:53.63 Server      The maximum number of dedicated administrator connections for this instance is '1'
2025-11-18 21:45:53.653 | 
2025-11-17 16:00:00.000 | 21:45:53.64 Server      Node configuration: node 0: CPU mask: 0x000000000000ffff:0 Active CPU mask: 0x000000000000ffff: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-11-18 21:45:53.680 | 
2025-11-17 16:00:00.000 | 21:45:53.67 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-11-18 21:45:53.681 | 
2025-11-17 16:00:00.000 | 21:45:53.67 Server      Lock partitioning is enabled.  This is an informational message only. No user action is required.
2025-11-18 21:45:53.743 | 
2025-11-17 16:00:00.000 | 21:45:53.73 Server      In-Memory OLTP initialized on lowend machine.
2025-11-18 21:45:53.779 | 
2025-11-17 16:00:00.000 | 21:45:53.75 Server      CLR version v4.0.30319 loaded.
2025-11-18 21:45:53.964 | 
2025-11-17 16:00:00.000 | 21:45:53.93 Server      [INFO] Created Extended Events session 'hkenginexesession'
2025-11-18 21:45:53.967 | 
2025-11-17 16:00:00.000 | 21:45:53.93 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-11-18 21:45:53.972 | 
2025-11-18 21:45:53.851 | ForceFlush is enabled for this instance. 
2025-11-18 21:45:53.976 | 
2025-11-17 16:00:00.000 | 21:45:53.94 Server      Total Log Writer threads: 2. This is an informational message; no user action is required.
2025-11-18 21:45:53.984 | 
2025-11-17 16:00:00.000 | 21:45:53.95 Server      clwb is selected for pmem flush operation.
2025-11-18 21:45:53.988 | 
2025-11-17 16:00:00.000 | 21:45:53.96 Server      Software Usage Metrics is disabled.
2025-11-18 21:45:53.990 | 
2025-11-18 21:45:53.868 | Failed to open password policy registry path. Using default password policy values.
2025-11-18 21:45:54.032 | 
2025-11-17 16:00:00.000 | 21:45:54.00 spid45s     [1]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0. NestIdBasedHP: 0. m_nestIdBasedHPOnTempDB: 0
2025-11-18 21:45:54.034 | 
2025-11-17 16:00:00.000 | 21:45:54.00 spid45s     Starting up database 'master'.
2025-11-18 21:45:54.179 | 
2025-11-17 16:00:00.000 | 21:45:54.15 Server      Common language runtime (CLR) functionality initialized.
2025-11-18 21:45:54.448 | 
2025-11-17 16:00:00.000 | 21:45:54.42 Server      External governance manager initialized
2025-11-18 21:45:54.450 | 
2025-11-17 16:00:00.000 | 21:45:54.42 Server      Detected pause instruction latency: 44 cycles.
2025-11-18 21:45:54.529 | 
2025-11-18 21:45:54.401 | ForceFlush feature is enabled for log durability.
2025-11-18 21:45:54.554 | 
2025-11-17 16:00:00.000 | 21:45:54.52 spid45s     13 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2025-11-18 21:45:54.578 | 
2025-11-17 16:00:00.000 | 21:45:54.54 spid45s     0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2025-11-18 21:45:54.580 | 
2025-11-17 16:00:00.000 | 21:45:54.55 spid45s     Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2025-11-18 21:45:54.684 | 
2025-11-18 21:45:54.554 | [INFO] [StartUp::OpenDBsAndRecover]: In Startup, FEnableResilientBufferPoolExtensionEnabled() = [0]. IsRBPEXSupportedNonHyperscaleEdition() = [0]. IsSubCore = [0].
2025-11-18 21:45:54.689 | 
2025-11-17 16:00:00.000 | 21:45:54.66 spid45s     [32762]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0. NestIdBasedHP: 0. m_nestIdBasedHPOnTempDB: 0
2025-11-18 21:45:54.692 | 
2025-11-17 16:00:00.000 | 21:45:54.66 spid46s     [32767]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0. NestIdBasedHP: 0. m_nestIdBasedHPOnTempDB: 0
2025-11-18 21:45:54.694 | 
2025-11-17 16:00:00.000 | 21:45:54.66 spid45s     Starting up database 'model_replicatedmaster'.
2025-11-18 21:45:54.712 | 
2025-11-17 16:00:00.000 | 21:45:54.68 spid46s     Starting up database 'mssqlsystemresource'.
2025-11-18 21:45:54.717 | 
2025-11-17 16:00:00.000 | 21:45:54.68 spid46s     The resource database build version is 17.00.1000. This is an informational message only. No user action is required.
2025-11-18 21:45:54.745 | 
2025-11-17 16:00:00.000 | 21:45:54.71 spid46s     [3]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0. NestIdBasedHP: 0. m_nestIdBasedHPOnTempDB: 0
2025-11-18 21:45:54.747 | 
2025-11-17 16:00:00.000 | 21:45:54.71 spid46s     Starting up database 'model'.
2025-11-18 21:45:55.048 | 
2025-11-17 16:00:00.000 | 21:45:55.04 spid54s     A self-generated certificate was successfully loaded for encryption.
2025-11-18 21:45:55.049 | 
2025-11-17 16:00:00.000 | 21:45:55.04 spid54s     Server is listening on [ 'any' <ipv6> 1433] accept sockets 1.
2025-11-18 21:45:55.051 | 
2025-11-17 16:00:00.000 | 21:45:55.04 spid54s     Server is listening on [ 'any' <ipv4> 1433] accept sockets 1.
2025-11-18 21:45:55.084 | 
2025-11-17 16:00:00.000 | 21:45:55.08 Server      Server is listening on [ ::1 <ipv6> 1434] accept sockets 1.
2025-11-18 21:45:55.086 | 
2025-11-17 16:00:00.000 | 21:45:55.08 Server      Server is listening on [ 127.0.0.1 <ipv4> 1434] accept sockets 1.
2025-11-18 21:45:55.087 | 
2025-11-17 16:00:00.000 | 21:45:55.08 Server      Dedicated admin connection support was established for listening locally on port 1434.
2025-11-18 21:45:54.982 | 
2025-11-18 21:45:54.987 | TDS initialization result: 0.
2025-11-18 21:45:55.046 | 
2025-11-17 16:00:00.000 | 21:45:55.18 spid54s     Server is listening on [ ::1 <ipv6> 1431] accept sockets 1.
2025-11-18 21:45:55.048 | 
2025-11-17 16:00:00.000 | 21:45:55.18 spid54s     Server is listening on [ 127.0.0.1 <ipv4> 1431] accept sockets 1.
2025-11-18 21:45:55.052 | 
2025-11-18 21:45:55.056 | SQLSERVR_SSL_CERTIFICATE_DNS_OR_SUBJECT_NAME environment variable was not set as SSL cert is self signed or untrusted.
2025-11-18 21:45:55.053 | 
2025-11-17 16:00:00.000 | 21:45:55.18 spid54s     SQL Server is now ready for client connections. This is an informational message; no user action is required.
2025-11-18 21:45:55.114 | 
2025-11-17 16:00:00.000 | 21:45:55.25 spid45s     Converting database 'model_replicatedmaster' from version 984 to the current version 998.
2025-11-18 21:45:55.117 | 
2025-11-17 16:00:00.000 | 21:45:55.25 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 984 to version 985.
2025-11-18 21:45:55.135 | 
2025-11-17 16:00:00.000 | 21:45:55.27 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 985 to version 986.
2025-11-18 21:45:55.154 | 
2025-11-17 16:00:00.000 | 21:45:55.28 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 986 to version 987.
2025-11-18 21:45:55.170 | 
2025-11-17 16:00:00.000 | 21:45:55.30 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 987 to version 988.
2025-11-18 21:45:55.205 | 
2025-11-17 16:00:00.000 | 21:45:55.34 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 988 to version 989.
2025-11-18 21:45:55.222 | 
2025-11-17 16:00:00.000 | 21:45:55.35 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 989 to version 990.
2025-11-18 21:45:55.241 | 
2025-11-17 16:00:00.000 | 21:45:55.37 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 990 to version 991.
2025-11-18 21:45:55.244 | 
2025-11-17 16:00:00.000 | 21:45:55.38 spid45s     [METADATA] XE max_rollover_files update status is : 0.
2025-11-18 21:45:55.260 | 
2025-11-17 16:00:00.000 | 21:45:55.39 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 991 to version 992.
2025-11-18 21:45:55.277 | 
2025-11-17 16:00:00.000 | 21:45:55.41 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 992 to version 993.
2025-11-18 21:45:55.296 | 
2025-11-17 16:00:00.000 | 21:45:55.43 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 993 to version 994.
2025-11-18 21:45:55.418 | 
2025-11-17 16:00:00.000 | 21:45:55.55 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 994 to version 995.
2025-11-18 21:45:55.444 | 
2025-11-17 16:00:00.000 | 21:45:55.58 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 995 to version 996.
2025-11-18 21:45:55.460 | 
2025-11-17 16:00:00.000 | 21:45:55.59 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 996 to version 997.
2025-11-18 21:45:55.476 | 
2025-11-17 16:00:00.000 | 21:45:55.61 spid45s     Database 'model_replicatedmaster' running the upgrade step from version 997 to version 998.
2025-11-18 21:45:55.595 | 
2025-11-17 16:00:00.000 | 21:45:55.73 spid45s     Synchronize Database 'model_replicatedmaster' (32762) with Resource Database.
2025-11-18 21:45:55.816 | 
2025-11-17 16:00:00.000 | 21:45:55.94 spid45s     [32761]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0. NestIdBasedHP: 0. m_nestIdBasedHPOnTempDB: 0
2025-11-18 21:45:55.819 | 
2025-11-17 16:00:00.000 | 21:45:55.94 spid45s     Starting up database 'model_msdb'.
2025-11-18 21:45:56.271 | 
2025-11-17 16:00:00.000 | 21:45:56.28 spid45s     Converting database 'model_msdb' from version 984 to the current version 998.
2025-11-18 21:45:56.272 | 
2025-11-17 16:00:00.000 | 21:45:56.28 spid45s     Database 'model_msdb' running the upgrade step from version 984 to version 985.
2025-11-18 21:45:56.286 | 
2025-11-17 16:00:00.000 | 21:45:56.29 spid45s     Database 'model_msdb' running the upgrade step from version 985 to version 986.
2025-11-18 21:45:56.302 | 
2025-11-17 16:00:00.000 | 21:45:56.31 spid45s     Database 'model_msdb' running the upgrade step from version 986 to version 987.
2025-11-18 21:45:56.320 | 
2025-11-17 16:00:00.000 | 21:45:56.33 spid45s     Database 'model_msdb' running the upgrade step from version 987 to version 988.
2025-11-18 21:45:56.353 | 
2025-11-17 16:00:00.000 | 21:45:56.36 spid45s     Database 'model_msdb' running the upgrade step from version 988 to version 989.
2025-11-18 21:45:56.370 | 
2025-11-17 16:00:00.000 | 21:45:56.38 spid45s     Database 'model_msdb' running the upgrade step from version 989 to version 990.
2025-11-18 21:45:56.388 | 
2025-11-17 16:00:00.000 | 21:45:56.40 spid45s     Database 'model_msdb' running the upgrade step from version 990 to version 991.
2025-11-18 21:45:56.390 | 
2025-11-17 16:00:00.000 | 21:45:56.40 spid45s     [METADATA] XE max_rollover_files update status is : 0.
2025-11-18 21:45:56.405 | 
2025-11-17 16:00:00.000 | 21:45:56.42 spid45s     Database 'model_msdb' running the upgrade step from version 991 to version 992.
2025-11-18 21:45:56.419 | 
2025-11-17 16:00:00.000 | 21:45:56.43 spid45s     Database 'model_msdb' running the upgrade step from version 992 to version 993.
2025-11-18 21:45:56.434 | 
2025-11-17 16:00:00.000 | 21:45:56.45 spid45s     Database 'model_msdb' running the upgrade step from version 993 to version 994.
2025-11-18 21:45:56.449 | 
2025-11-17 16:00:00.000 | 21:45:56.46 spid45s     Database 'model_msdb' running the upgrade step from version 994 to version 995.
2025-11-18 21:45:56.475 | 
2025-11-17 16:00:00.000 | 21:45:56.49 spid45s     Database 'model_msdb' running the upgrade step from version 995 to version 996.
2025-11-18 21:45:56.571 | 
2025-11-17 16:00:00.000 | 21:45:56.59 spid45s     Database 'model_msdb' running the upgrade step from version 996 to version 997.
2025-11-18 21:45:56.586 | 
2025-11-17 16:00:00.000 | 21:45:56.61 spid45s     Database 'model_msdb' running the upgrade step from version 997 to version 998.
2025-11-18 21:45:56.602 | 
2025-11-17 16:00:00.000 | 21:45:56.62 spid45s     Synchronize Database 'model_msdb' (32761) with Resource Database.
2025-11-18 21:45:56.707 | 
2025-11-17 16:00:00.000 | 21:45:56.73 spid45s     Resource governor reconfiguration succeeded.
2025-11-18 21:45:56.710 | 
2025-11-17 16:00:00.000 | 21:45:56.73 spid45s     SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2025-11-18 21:45:56.711 | 
2025-11-18 21:45:56.722 | [Auditing][SecAuditPkg::AutoStartAuditSessions] Entered function.
2025-11-18 21:45:56.711 | 
2025-11-17 16:00:00.000 | 21:45:56.74 spid45s     [AutoStartAuditSessions] Starting audit session task
2025-11-18 21:45:56.715 | 
2025-11-17 16:00:00.000 | 21:45:56.74 spid45s     SQL Server Audit has started the audits. This is an informational message. No user action is required.
2025-11-18 21:45:56.990 | 
2025-11-17 16:00:00.000 | 21:45:56.99 spid45s     SQL Trace ID 1 was started by login "sa".
2025-11-18 21:45:57.004 | 
2025-11-17 16:00:00.000 | 21:45:57.00 spid45s     Server name is 'mssql'. This is an informational message only. No user action is required.
2025-11-18 21:45:57.037 | 
2025-11-17 16:00:00.000 | 21:45:57.04 spid46s     Clearing tempdb database.
2025-11-18 21:45:57.038 | 
2025-11-17 16:00:00.000 | 21:45:57.04 spid75s     Always On Availability Groups: The availability replica manager is starting. This is an informational message only. No user action is required.
2025-11-18 21:45:57.041 | 
2025-11-17 16:00:00.000 | 21:45:57.04 spid75s     Always On Availability Groups: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required.
2025-11-18 21:45:57.044 | 
2025-11-17 16:00:00.000 | 21:45:57.04 spid76s     [4]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0. NestIdBasedHP: 0. m_nestIdBasedHPOnTempDB: 0
2025-11-18 21:45:57.047 | 
2025-11-17 16:00:00.000 | 21:45:57.05 spid76s     Starting up database 'msdb'.
2025-11-18 21:45:57.581 | 
2025-11-17 16:00:00.000 | 21:45:57.60 spid76s     Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2025-11-18 21:45:58.226 | 
2025-11-17 16:00:00.000 | 21:45:58.22 spid46s     [2]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0. NestIdBasedHP: 0. m_nestIdBasedHPOnTempDB: 0
2025-11-18 21:45:58.227 | 
2025-11-17 16:00:00.000 | 21:45:58.22 spid46s     Starting up database 'tempdb'.
2025-11-18 21:45:58.686 | 
2025-11-17 16:00:00.000 | 21:45:58.69 spid46s     The tempdb database has 1 data file(s).
2025-11-18 21:45:58.693 | 
2025-11-17 16:00:00.000 | 21:45:58.70 spid52s     The Service Broker endpoint is in disabled or stopped state.
2025-11-18 21:45:58.695 | 
2025-11-17 16:00:00.000 | 21:45:58.70 spid52s     The Database Mirroring endpoint is in disabled or stopped state.
2025-11-18 21:45:58.703 | 
2025-11-17 16:00:00.000 | 21:45:58.71 spid45s     Recovery is complete. This is an informational message only. No user action is required.
2025-11-18 21:45:58.706 | 
2025-11-17 16:00:00.000 | 21:45:58.72 spid52s     Service Broker manager has started.
2025-11-18 21:46:09.827 | 
2025-11-17 16:00:00.000 | 21:46:09.82 spid81      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2025-11-18 21:46:09.842 | 
2025-11-17 16:00:00.000 | 21:46:09.84 spid81      Using 'xplog70.dll' version '2025.170.1000' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2025-11-18 21:46:10.169 | 
2025-11-17 16:00:00.000 | 21:46:10.17 spid84      Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2025-11-18 21:46:10.173 | 
2025-11-17 16:00:00.000 | 21:46:10.17 spid84      Using 'xpsqlbot.dll' version '2025.170.1000' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2025-11-18 21:46:14.395 | 
2025-11-17 16:00:00.000 | 21:46:14.39 spid81      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2025-11-18 21:46:14.411 | 
2025-11-17 16:00:00.000 | 21:46:14.40 spid81      Using 'xpstar.dll' version '2025.170.1000' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2025-11-18 21:46:18.427 | 
2025-11-17 16:00:00.000 | 21:46:18.42 spid81      [DBMgr::FindFreeDatabaseID] Next available DbId EX locked: 5
2025-11-18 21:46:18.653 | 
2025-11-17 16:00:00.000 | 21:46:18.64 spid81      Error: 17053, Severity: 16, State: 1.
2025-11-18 21:46:18.654 | 
2025-11-17 16:00:00.000 | 21:46:18.64 spid81      /var/opt/mssql/data/testdb.mdf: Operating system error 31(A device attached to the system is not functioning.) encountered.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions