Restore database from backup in Docker

[utterances-bot]

Restore database from backup in Docker | Chad’s Blog

Spent about an hour trying to restore a database to SQL Server in Docker. Decided to convert my notes to a blog post, hopefully this will help someone else out there who also didn’t read the 20 other blog posts about it :)

https://chadbaldwin.net/2021/11/04/restore-database-in-docker.html

[gsalvacruz]

Thank you for this. Your simple solution helped a lot.

[revgeo]

Fantastic. Very easy to follow and worked perfectly.

[chadbaldwin]

@revgeo nice! Glad it worked for you. Though, FYI, I believe since writing this post, either Docker, WSL or Windows updated something to make it MUCH easier to do this so you don't have to copy the backup into the container in order to restore every single time. For whatever reason, at the time I wrote this, I could not for the life of me get a windows directory to mount as a volume to a Linux container running on WSL2.

But you can now! You can actually access it directly from the container into a virtually mapped directory (volume). No copying.

I haven't had time to update the post, I also totally forgot about this, but maybe I'll get around to that soon.

I would suggest looking into setting up a mapped volume instead.