I have a MsSQL database in my Azure Data Studio with Docker. I tried to create a Backup file of this database, but Azure Dara Studio showed me 'Backup Files /var/opt/mssql/data/idatabase-202396-16-47-4.bak' in the backup options. How can I access this file? I want to copy this backup file to another computer.
我在Azure Data Studio中有一个MsSQL数据库。我尝试创建此数据库的备份文件,但Azure Dara Studio在备份选项中显示了“Backup Files/var/opt/mssql/data/idatabase-202396-16-47-4.bak”。如何访问此文件?我想将此备份文件复制到另一台计算机。
更多回答
The file paths in backup and restore operations are relative to the location of the SQL Server instance itself (not the client), so the backup will be located wherever the SQL Server instance is. When that's a Docker container then the backup is inside the container's file system, so you can use docker cp
to copy it out. You could save yourself some steps with future containers by using volumes to mount a portion of the Docker host's file system inside the Docker container.
备份和恢复操作中的文件路径相对于SQL Server实例本身(而不是客户端)的位置,因此备份将位于SQL Server实例所在的任何位置。如果是Docker容器,则备份位于容器的文件系统中,因此您可以使用docker cp将其复制出来。通过使用卷将Docker主机的文件系统的一部分挂载到Docker容器中,您可以省去使用未来容器的一些步骤。
优秀答案推荐
While thinking @AlwaysLearnin 's comment, I have found that, you can access files inside the server with Docker Desktop. I put picture that where I found the .bak file.
在思考@Always sLearnin‘S评论时,我发现,可以用Docker Desktop访问服务器内部的文件。我在找到.bak文件的地方放了图片。
更多回答
我是一名优秀的程序员,十分优秀!