mssql-docker
mssql-docker copied to clipboard
microsoft
Cannot Create Database - Sql2025 Docker Desktop Win11 WSL2 Ubuntu 24.04
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'
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.
- Create a volume in Docker Desktop named
mssqldb. - 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.
Same issue and error message with SQL Server 2025 on Linux trying to create user database on a SMB share
Microsoft SQL Server 2025 (RTM) - 17.0.1000.7 (X64) Oct 21 2025 12:05:57 Copyright (C) 2025 Microsoft Corporation Enterprise Developer Edition (64-bit) on Linux (Ubuntu 22.04.5 LTS) <X64>
oddly, the system databases had no issue being created by:
sudo /opt/mssql/bin/mssql-conf setup
but no avail for user databases. I have tried through SSMS 22 as well as with sqlcmd inside the VM
this used to be fine in SQL Server 2019 with the same VM setup and the same samba share
Don't use Windows paths for volume mounts with databases... you're begging for corruption and slow performance because of how Docker integrates volumes... it's okay for a backup/restore directory, but not for live databases.
You should use either named volume mounts (that exist inside docker), or use your WSL(2) environment to stow the volumes themselves for best results. Looks like you did this in your later example.
Also, try a prior, specific version(s) instead of :latest I've noticed quite a few people having issues with unstable recent releases.
Oh yeah... if you're using a volume path, try giving the directory chmod +rwX permissions... in case it's an ownership issue. I don't recall the specific user:group number for the SQL images.
Hi, same issue here with Podman on Windows 11 (WSL).
I just need to run Sql 2025 for testing the new features (no production and not interested in performances). I'd like to place the mdf and ldf files on Win 11 disk, so outside the container and not losing them if I recreate the container.
Case 1: run the image without changes. So /var/opt/mssql/data inside container. Everything is OK but mdf and ldf are inside container. Not what I need.
podman run --name sql2025test -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD=SqlTest123 -e MSSQL_PID=Developer -p 1433:1433 -d mcr.microsoft.com/mssql/server:2025-latest
Case 2: bind mount a previously manually created folder inside Podman machine to container. I need to give chmod 777 permission or run sql as root. Result: sql2025 starts, the mdf and ldf are outside the container but I would like to have them on my Win 11 disk. So, not completely OK.
podman run --name sql2025test -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD=SqlTest123 -e MSSQL_PID=Developer -p 1433:1433 --volume /mypodmandata/shared/s1:/var/opt/mssql/data -d mcr.microsoft.com/mssql/server:2025-latest
podman run --name sql2025test -u 0:0 -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD=SqlTest123 -e MSSQL_PID=Developer -p 1433:1433 --volume /mypodmandata/shared/s2:/var/opt/mssql/data -d mcr.microsoft.com/mssql/server:2025-latest
Case 3: KO, using Windows 11 disk, automatically mounted as /mnt/c on Podman machine. I have found no way to make it work. I always get errors:
podman run --name sql2025test -u 0:0 -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD=SqlTest123 -e MSSQL_PID=Developer -p 1433:1433 --volume /mnt/c/Temp/PodmanShare/sql2025/data:/var/opt/mssql/data -d mcr.microsoft.com/mssql/server:2025-latest
spid30s Error: 17053, Severity: 16, State: 1.
spid30s /var/opt/mssql/data/tempdb.mdf: Operating system error 31(A device attached to the system is not functioning.) encountered.
Some mdf/ldf are created but it hangs on creating tempdb files.
I have also tried mcr.microsoft.com/mssql/server:2025-RTM-ubuntu-24.04-preview. Same results.
Is it normal not to have any response -- not even a triage message -- from Microsoft, even a month after an issue is reported?