从blob容器导入数据库 [英] Importing DB from blob container

问题描述

导入操作期间我收到以下错误（操作名称 - >设置数据库扩展名，错误代码= 0）：

during import operation I'm receiving following error (Operation name --> Set database extension, error code=0) :

此操作期间发生错误：'< string xmlns =" http://schemas.microsoft.com/2003/10/Serialization/"> ;服务操作期间遇到错误。 ;异常Microsoft.SqlServer.Management.Dac.Services.ServiceException：检索blob& amp;＃39;< serwer name>& amp;＃39;。;的元数据时遇到意外的
异常。内部异常Microsoft.WindowsAzure.Storage.StorageException：blob引用的Blob类型并不匹配blob的blob类型。内部
异常System.InvalidOperationException：blob引用的Blob类型并不匹配blob的blob类型。 < / string>'

数据库已恢复 - 但我是否已正确恢复？

Database is restored - but I'd is it restored properly?

Regs

Jarek

JD

推荐答案

Hi,

您可能需要页面blob 。通常，VM磁盘也会保存为页面blob ..

You might need Page blob here. Typically VM disks are also saved as page blobs..

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines- windows-use-storage-sql-server-backup-restore

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-use-storage-sql-server-backup-restore

https://docs.microsoft.com/en-us/rest/api/storageservices/Understanding-Block-Blobs- -Append-Blobs - 和-Page-Blobs？redirectedfrom = MSDN

https://docs.microsoft.com/en-us/rest/api/storageservices/Understanding-Block-Blobs--Append-Blobs--and-Page-Blobs?redirectedfrom=MSDN

我们按照以下文档开展工作：



https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-backup-retention-configure



https://docs.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-存储服务？view = sql-server-2017

We had it working by following the documentation below:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-backup-retention-configure

https://docs.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-2017

这篇关于从blob容器导入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！