gpt4 book ai didi

Database's backup location that created by Azure Data Studio on Mac M1(由Mac M1上的Azure Data Studio创建的数据库的备份位置)

转载 作者:bug小助手 更新时间:2023-10-25 21:49:36 26 4
gpt4 key购买 nike



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文件的地方放了图片。


enter image description here


更多回答

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com