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?
