I have a database that is running locally in a sql docker container, which I want to backup and be able to use as part of a COPY command when creating a custom sql docker image then eventually use it as part of a RESTORE DATABASE command with sqlcmd.
However, when I right click on the DB in SSMS and go to backup I can only seem to backup inside the container, and not locally on my C: drive.
Is there a way I can retrieve the .bak file to my local drive?