Let's find out the logical file names and paths inside the backup.Click the Restore button at the bottom of the window.At Backup file path, click the browse button (three dots) and browse to the correct backup file in the /var/opt/ mssql/backup directory.At Restore from, select the From File option.Select the new connection in the connections tree view and click the Restore button.Provide the sa username and the password that was supplied in the docker run command above.If you mapped the container to a port that is different from the default port 1433 you must use localhost,# instead, replacing the # with the actual port number. Expand the SERVERS node and click on the New Connection icon.Connect to the database in the container.Download from (or choco install azure-data-studio or winget install Microsoft.AzureDataStudio).Note that the directories mentioned below may change in the future (or already has) as the Docker team sees fit. Option 1: Restore using Azure Data Studio Let's restore the backup into an actual database! Now that the backup file is located in the the volume, the database server has access to it. Alternatively, you can specify its actual path in the docker cp statement below. DATABASE.bak) is located in the current directory. Since this is just a playground, 2GB should be enough. To be safe, increase it to 4GB if you can. Increase the Memory By default, Docker will have 2GB of memory allocated to it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |