On Premises Flat file backup restore on managed Azure SQL DatabaseSQL Server database backup to Windows Azure...

Is it possible to counterspell the revised Artificer?

Four buttons on a table

How to create an associative array from two arrays?

Make me a metasequence

Which sins are beyond punishment?

Are paired adjectives bad style?

What is the difference between a forward slip and a side slip?

Can I become debt free or should I file for bankruptcy? How do I manage my debt and finances?

Difference between 'stomach' and 'uterus'

A bug in Excel? Conditional formatting for marking duplicates also highlights unique value

How can atoms be electrically neutral when there is a difference in the positions of the charges?

How do you say "powers of ten"?

For a 1-action spell, do I need to take a turn to ready the spell before I can cast it, or can I cast it immediately?

Are small insurances worth it

Wrap all numerics in JSON with quotes

Why did the Cray-1 have 8 parity bits per word?

Reason why dimensional travelling would be restricted

How do you say “my friend is throwing a party, do you wanna come?” in german

How can I create a Table like this in Latex?

Change only a specific Parameter on a function

Strange artifacts on car LCD. Scratches?

Calculating Hyperbolic Sin faster than using a standard power series

Would the melodic leap of the opening phrase of Mozart's K545 be considered dissonant?

What are SHA-rounds?



On Premises Flat file backup restore on managed Azure SQL Database


SQL Server database backup to Windows Azure Recovery ServiceDetermining Azure SQL Database requirementsAzure Backup VM - Can't restoreSQL Server Managed Backup to Azure coexistence with IaaS BackupBackup SQL Azure database from the Cloud to on-premises (DPM?)Install SQL Server 2017 on Windows 10 Azure VMAzure File Share BackupAzure ARM Template - multiple Microsoft.Compute/virtualMachines/extensions for VMAzure SQL database upgradeAutoscaling Azure SQL Database













0















I am getting error while importing database backup of my on premises instance to Azure SQL. Below is the error message.



{ "id": "/subscriptions/7890e344-be6a-46e3-b94c-70a01769770c/resourceGroups/NetworkWatcherRG/providers/Microsoft.Resources/deployments/Microsoft.SQLDatabase.newDatabaseImportExistingServer_3efecd86d4/operations/AABB0BE759149C1D", "operationId": "AABB0BE759149C1D", "properties": { "provisioningOperation": "Create", "provisioningState": "Failed", "timestamp": "2019-03-06T12:44:52.2861384Z", "duration": "PT5.3159454S", "trackingId": "b8516f52-ba9f-4eb8-9362-b4db5c3cdb00", "serviceRequestId": "80767727-cea3-4c4c-bdee-c379cf41c48e", "statusCode": "BadRequest", "statusMessage": { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "details": [ { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "severity": "16" } ], "innererror": [] }, "targetResource": { "id": "/subscriptions/7890e344-be6a-46e3-b94c-70a01769770c/resourceGroups/NetworkWatcherRG/providers/Microsoft.Sql/servers/testserverind/databases/testdb1/extensions/Import", "resourceType": "Microsoft.Sql/servers/databases/extensions", "resourceName": "testserverind/testdb1/Import" }, "request": { "content": { "properties": { "storageKeyType": "SharedAccessKey", "storageKey": "?sp=r&se=2019-03-07T12:42:19Z&sv=2018-03-28&sig=WerQXXHfoE%2FrkChnq3yYRc2ZFyUUSCjDKRvb6KZKDQo%3D&sr=b", "storageUri": "https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak", "authenticationType": "SQL", "administratorLogin": "deepakbha", "administratorLoginPassword": "India@12345", "operationMode": "Import" } } }, "response": { "content": { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "details": [ { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "severity": "16" } ], "innererror": [] } } }}









share







New contributor




Deepak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    I am getting error while importing database backup of my on premises instance to Azure SQL. Below is the error message.



    { "id": "/subscriptions/7890e344-be6a-46e3-b94c-70a01769770c/resourceGroups/NetworkWatcherRG/providers/Microsoft.Resources/deployments/Microsoft.SQLDatabase.newDatabaseImportExistingServer_3efecd86d4/operations/AABB0BE759149C1D", "operationId": "AABB0BE759149C1D", "properties": { "provisioningOperation": "Create", "provisioningState": "Failed", "timestamp": "2019-03-06T12:44:52.2861384Z", "duration": "PT5.3159454S", "trackingId": "b8516f52-ba9f-4eb8-9362-b4db5c3cdb00", "serviceRequestId": "80767727-cea3-4c4c-bdee-c379cf41c48e", "statusCode": "BadRequest", "statusMessage": { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "details": [ { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "severity": "16" } ], "innererror": [] }, "targetResource": { "id": "/subscriptions/7890e344-be6a-46e3-b94c-70a01769770c/resourceGroups/NetworkWatcherRG/providers/Microsoft.Sql/servers/testserverind/databases/testdb1/extensions/Import", "resourceType": "Microsoft.Sql/servers/databases/extensions", "resourceName": "testserverind/testdb1/Import" }, "request": { "content": { "properties": { "storageKeyType": "SharedAccessKey", "storageKey": "?sp=r&se=2019-03-07T12:42:19Z&sv=2018-03-28&sig=WerQXXHfoE%2FrkChnq3yYRc2ZFyUUSCjDKRvb6KZKDQo%3D&sr=b", "storageUri": "https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak", "authenticationType": "SQL", "administratorLogin": "deepakbha", "administratorLoginPassword": "India@12345", "operationMode": "Import" } } }, "response": { "content": { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "details": [ { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "severity": "16" } ], "innererror": [] } } }}









    share







    New contributor




    Deepak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I am getting error while importing database backup of my on premises instance to Azure SQL. Below is the error message.



      { "id": "/subscriptions/7890e344-be6a-46e3-b94c-70a01769770c/resourceGroups/NetworkWatcherRG/providers/Microsoft.Resources/deployments/Microsoft.SQLDatabase.newDatabaseImportExistingServer_3efecd86d4/operations/AABB0BE759149C1D", "operationId": "AABB0BE759149C1D", "properties": { "provisioningOperation": "Create", "provisioningState": "Failed", "timestamp": "2019-03-06T12:44:52.2861384Z", "duration": "PT5.3159454S", "trackingId": "b8516f52-ba9f-4eb8-9362-b4db5c3cdb00", "serviceRequestId": "80767727-cea3-4c4c-bdee-c379cf41c48e", "statusCode": "BadRequest", "statusMessage": { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "details": [ { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "severity": "16" } ], "innererror": [] }, "targetResource": { "id": "/subscriptions/7890e344-be6a-46e3-b94c-70a01769770c/resourceGroups/NetworkWatcherRG/providers/Microsoft.Sql/servers/testserverind/databases/testdb1/extensions/Import", "resourceType": "Microsoft.Sql/servers/databases/extensions", "resourceName": "testserverind/testdb1/Import" }, "request": { "content": { "properties": { "storageKeyType": "SharedAccessKey", "storageKey": "?sp=r&se=2019-03-07T12:42:19Z&sv=2018-03-28&sig=WerQXXHfoE%2FrkChnq3yYRc2ZFyUUSCjDKRvb6KZKDQo%3D&sr=b", "storageUri": "https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak", "authenticationType": "SQL", "administratorLogin": "deepakbha", "administratorLoginPassword": "India@12345", "operationMode": "Import" } } }, "response": { "content": { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "details": [ { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "severity": "16" } ], "innererror": [] } } }}









      share







      New contributor




      Deepak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I am getting error while importing database backup of my on premises instance to Azure SQL. Below is the error message.



      { "id": "/subscriptions/7890e344-be6a-46e3-b94c-70a01769770c/resourceGroups/NetworkWatcherRG/providers/Microsoft.Resources/deployments/Microsoft.SQLDatabase.newDatabaseImportExistingServer_3efecd86d4/operations/AABB0BE759149C1D", "operationId": "AABB0BE759149C1D", "properties": { "provisioningOperation": "Create", "provisioningState": "Failed", "timestamp": "2019-03-06T12:44:52.2861384Z", "duration": "PT5.3159454S", "trackingId": "b8516f52-ba9f-4eb8-9362-b4db5c3cdb00", "serviceRequestId": "80767727-cea3-4c4c-bdee-c379cf41c48e", "statusCode": "BadRequest", "statusMessage": { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "details": [ { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "severity": "16" } ], "innererror": [] }, "targetResource": { "id": "/subscriptions/7890e344-be6a-46e3-b94c-70a01769770c/resourceGroups/NetworkWatcherRG/providers/Microsoft.Sql/servers/testserverind/databases/testdb1/extensions/Import", "resourceType": "Microsoft.Sql/servers/databases/extensions", "resourceName": "testserverind/testdb1/Import" }, "request": { "content": { "properties": { "storageKeyType": "SharedAccessKey", "storageKey": "?sp=r&se=2019-03-07T12:42:19Z&sv=2018-03-28&sig=WerQXXHfoE%2FrkChnq3yYRc2ZFyUUSCjDKRvb6KZKDQo%3D&sr=b", "storageUri": "https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak", "authenticationType": "SQL", "administratorLogin": "deepakbha", "administratorLoginPassword": "India@12345", "operationMode": "Import" } } }, "response": { "content": { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "details": [ { "code": "0", "message": "There was an error that occurred during this operation : 'http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://sqldatabasebackup0101.blob.core.windows.net/azuresqldbbkp/testdb.bak'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:Blob type of the blob reference doesn't match blob type of the blob.; Inner exception System.InvalidOperationException:Blob type of the blob reference doesn't match blob type of the blob.; '", "target": null, "severity": "16" } ], "innererror": [] } } }}







      azure





      share







      New contributor




      Deepak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      Deepak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      Deepak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 3 mins ago









      DeepakDeepak

      1




      1




      New contributor




      Deepak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Deepak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Deepak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "2"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Deepak is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f957029%2fon-premises-flat-file-backup-restore-on-managed-azure-sql-database%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Deepak is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Deepak is a new contributor. Be nice, and check out our Code of Conduct.













          Deepak is a new contributor. Be nice, and check out our Code of Conduct.












          Deepak is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Server Fault!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f957029%2fon-premises-flat-file-backup-restore-on-managed-azure-sql-database%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          As a Security Precaution, the user account has been locked The Next CEO of Stack OverflowMS...

          Список ссавців Італії Природоохоронні статуси | Список |...

          Українські прізвища Зміст Історичні відомості |...