Restore MSSQL Database from .bak file using Docker & Azure Data Studio on MacOS



Prerequisites:
Installing SQL Server in Mac using Docker – https://www.youtube.com/watch?v=R37X3SfOLXo

Thank you to my *awesome* instructor at Bow Valley College for requesting the video! Happy to learn others find it helpful.

29 Comments

  1. Brother that video is necessary because it is short straight to the point and without complications. For more videos of this quality, thank you very much

  2. Sam, the setup was successful, but when I try to restore the backup, I'm getting the following error: Msg 3203, Level 16, State 1, Line 2 Read on "/tmp/backup.bak" failed: 13(The data is invalid.) – what might you think is the issue? is the backup corrupted?

  3. sr My English so bad. i need your help , when i using " Docker cp….", it it doesn't work and it asks me to use " docker cp [OPTIONS] CONTAINER:SRC_PATH DEST_PATH|-
    docker cp [OPTIONS] SRC_PATH|- CONTAINER:DEST_PATH" and i don't understand how to do that.

  4. When I put my .bak file I am getting this error; An exception occurred while executing a Transact-SQL statement or batch. Cannot open backup device '/var/backups/TurkishSuperLeague_20211207_StudentVersion.bak'
    Operating system error 5(Access is denied.). RESTORE HEADERONLY is terminating abnormally.

  5. Hi Sam, I got an error trying to restore the DB. Operating system error 5 (Access is denied)….. Can you help me please? Thanks

  6. Hi Sam, I forgot my server password and I cant seem to find resources that help with restoring it. Can you assist so I can go ahead and follow through with this video. Thank you.

Leave a Reply

© 2023 53GB