Forum Discussion

valentinsasek's avatar
valentinsasek
Copper Contributor
Jul 19, 2024

How to prevent SQL Server from entering the setup stage on every start

I am running SQL Server inside Docker. Every time I start SQL Server, it runs the setup stage.

I tested this manually inside the container:

2024-07-19 21:16:07.41 spid26s SQL Server shutdown due to Ctrl-C or Ctrl-Break signal. This is an informational message only. No user action is required.
2024-07-19 21:16:09.43 spid52 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2024-07-19 21:16:09.44 spid52 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
2024-07-19 21:16:09.45 spid52 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2024-07-19 21:16:11.41 spid26s SQL Server Agent service is not running.
2024-07-19 21:16:11.41 spid26s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
root@73b846f21ea4:/# opt/mssql/bin/sqlservr
2024-07-19 21:16:21.72 Server Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.mdf' to '/var/opt/mssql/data/model_replicatedmaster.mdf'.
2024-07-19 21:16:21.75 Server Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.ldf' to '/var/opt/mssql/data/model_replicatedmaster.ldf'.
2024-07-19 21:16:21.75 Server Setup step is FORCE copying system data file 'C:\templatedata\model_msdbdata.mdf' to '/var/opt/mssql/data/model_msdbdata.mdf'.
2024-07-19 21:16:21.77 Server Setup step is FORCE copying system data file 'C:\templatedata\model_msdblog.ldf' to '/var/opt/mssql/data/model_msdblog.ldf'.
2024-07-19 21:16:21.81 Server Microsoft SQL Server 2022 (RTM-CU13) (KB5036432) - 16.0.4125.3 (X64)
May 1 2024 15:05:56
Copyright (C) 2022 Microsoft Corporation
Developer Edition (64-bit) on Linux (Ubuntu 20.04.6 LTS) <X64>
No RepliesBe the first to reply

Resources