bak file, you don’t need to do this step.įor this tutorial, I’m going to restore the WideWorldImporters sample database. I should point out that, even though the examples on this page were done on a Mac, all steps should work on both macOS and Linux. This tutorial assumes that you’ve installed SQL Server on your Mac using a Docker container, and you’ve installed Azure Data Studio. bak file into the Docker container, you can go ahead and use Azure Data Studio to restore the database. If the backup file is located outside the Docker container that’s running SQL Server, you’ll need to copy it into the Docker container before you do the restore. However, if you’re running your SQL Server instance inside a Docker container (which of course, you would be if you’re running SQL Server on Mac or Linux), there’s something you need to be aware of if your backup file is located outside the Docker container. So when SQL Server restores the database, it’s using the. bak file contains a backup of the database you want to restore. This restore process allows you to navigate through the computer’s file system to locate the. Simply click Restore and follow the prompts. It’s a similar process to doing it with SQL Server Management Studio.
Restoring a database is a piece of cake with Azure Data Studio.
0 kommentar(er)
