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
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
New contributor
add a comment |
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
New contributor
add a comment |
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
New contributor
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
azure
New contributor
New contributor
New contributor
asked 3 mins ago
DeepakDeepak
1
1
New contributor
New contributor
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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.
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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