0

I run SQL Server instance on Docker, using the command:

docker run -d --rm -e "TZ=Europe/Rome" -e MSSQL_COLLATION=Latin1_General_CI_AS --name sql_server -e 'encrypt=disable' -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=Administrator1' -p 1433:1433 -v D:\DbBackups:/_dbBackups -v sqlvolume:/var/opt/mssql mcr.microsoft.com/mssql/server:2022-CU8-ubuntu-20.04

If I try to create a snapshot from SQL server Management Studio, issuing the query:

CREATE DATABASE Db_Snapshot ON  
(  
    NAME = MyDb_new,  
    FILENAME = '/_dbBackups/DB_Test_Snapshot.ss' 
)  
AS SNAPSHOT OF [MyDb];

Returns error:

Msg 1823, Level 16, State 2, Line 1

A database snapshot cannot be created because it failed to start.

Completion time: 2025-04-02T17:36:29.4221798+02:00

(lot of space is available on the disk)

Any suggestion to create the snapshot?

Greg Askew
  • 39,132

0 Answers0