从blob容器导入数据库

本文介绍了从blob容器导入数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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

此操作期间发生错误：'< string xmlns =" schemas.microsoft/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..

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

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

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

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

我们按照以下文档开展工作： docs.microsoft/en-us/azure/sql-database/sql-database-long-term-backup-retention-configure docs.microsoft/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: docs.microsoft/en-us/azure/sql-database/sql-database-long-term-backup-retention-configure docs.microsoft/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-2017