为Azure数据库制作备份 [英] make a backup for azure database
问题描述
我需要备份到我的azure数据库,我正在尝试使用以下命令:
I need to make a backup to my azure database, I'm trying with this command:
"C:\Program Files\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe" /Action:Export /SourceServerName:"tcp:MyDataServer.database.windows.net,1433" /SourceDatabaseName:MyDatabase /SourceUser:MyUser /SourcePassword:MyPass /TargetFile:C:\backups\backup.bacpac
但是下载它的格式似乎是"bacpac",我需要将其设置为".bak".我尝试更改扩展名,但说:"TargetFile参数必须引用带有'.bacpac的文件扩展名"
but it seems that the format that downloads it is "bacpac" and I need it to be ".bak", I tried to change the extension but says: "The TargetFile argument must refer to a file with a '.bacpac' extension "
是否知道如何以".bak"格式下载数据库?
Any idea how to download the database in ".bak" format?
推荐答案
是否知道如何以".bak"格式下载数据库?
Any idea how to download the database in ".bak" format?
SQL Azure没有提供生成".bak"格式备份文件的本地方法.如果确实需要此格式文件,则可以将BACPAC文件导入本地SQL Server以创建新的用户数据库.然后,您可以从本地SQL Server生成".bak"格式的文件.
SQL Azure doesn't provide a native way to generate '.bak' format backup file. If you did need this format file, you could import the BACPAC File to your local SQL Server to create a new User Database. Then you could generate a '.bak' format file from your local SQL Server.
此外,您还可以尝试使用名为 SqlAzureBakMaker 的工具,该工具可以为你很容易.
In addition, you also could try a tool named SqlAzureBakMaker which could make '.bak' file for you easily.
这篇关于为Azure数据库制作备份的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!