从Azure下载SQL备份 [英] Download SQL Backups from Azure
问题描述
我在prem上设置了MS Azure备份服务,并同步到Azure,并且正在prem SQL服务器上进行备份.是否可以直接从Azure门户下载.db或.bak文件,还是必须通过备份服务器下载?我可以看到 在Vault中进行备份,但找不到直接下载它们的方法.
sKroesen,
是的,可以在不使用内部备份服务器的情况下进行SQL备份,以下是详细信息.
a.使用存储帐户在Azure Portal中创建Azure Blob容器.
b.创建SQL Server凭据,用于存储连接到SQL Server外部资源所需的身份验证信息,备份和还原过程使用此凭据连接到Blob存储.
c.使用SQL命令备份数据库.
BACKUP DATABASE [DBName]
转到URL ='https://mystorageaccount.blob.core.windows.net/privatecontainertest/DBName.bak'
WITH CREDENTIAL ='mycredential';
开始请参阅文档以获取更多详细信息
https://docs.microsoft.com/zh-cn/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server -2017
-----------------------------------
如果这可以解决您的问题,请标记为已回答.
也投票给答案.
I setup MS Azure Backup Service on prem and sync up to Azure and I am backing up on prem SQL servers. Is there a way to download the .db or .bak files direct from the Azure portal, or does it have to be through a backup server? I can see the backups in the vault, but cannot find a way to download them directly.
sKroesen,
YES, It is possible to take the SQL backups without using the on-premise backup server, and below are the details.
a. Create Azure Blob Container in Azure Portal using the storage account.
b. Create SQL Server Credential, it is used to store authentication information required to connect to a resource outside SQL Server, backup and restore process use this credentials to connect to blob storage.
c. backup the database using the SQL commands.
BACKUP DATABASE[DBName]
TO URL = 'https://mystorageaccount.blob.core.windows.net/privatecontainertest/DBName.bak'
WITH CREDENTIAL = 'mycredential';
GOplease refer to the documentation for more details
https://docs.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-2017
-----------------------------------
If this resolve your issue, please mark it as answered.
Also vote for the answer.
这篇关于从Azure下载SQL备份的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!