Please see the code below from a docker compose file:
sql.data:
image: microsoft/mssql-server-linux:2017-latest
volumes:
- mssql-server-linux-data:/var/opt/mssql/data
The code works exactly as expected i.e. the data outlives the application i.e. it is persistent.
Where exactly is this data stored on my Windows PC (Docker for Windows - Linux Containers). For example, if I wanted to ensure that the data files are backed up each night then where would I look. I have spent hours Googling this today and I have found no answer. I even read that these data files are not stored on the filesystem - surely they have to be stored on the file system.