Azure restore a SQL Server database from blob

I am trying to restore a SQL Server database in Azure from a database backup file stored in a blob. I have followed this link but got this error

TITLE: Microsoft SQL Server Management Studio

An error occurred while loading data.

ADDITIONAL INFORMATION:

The type of a blob in the container is unrecognized by this version. (Microsoft.SqlServer.StorageClient)

The remote server returned an error: (409) Conflict. (System)

I have also tried this:

CREATE CREDENTIAL mycredential1   

WITH IDENTITY= 'jjt', -- this is the name of the storage account you specified when creating a storage account   

SECRET = 'storage account key'

Then try to use the credential to restore the sql db from the azure blob, but failed on the above step with the following error:

Msg 40514, Level 16, State 1, Line 1

'CREATE CREDENTIAL' is not supported in this version of SQL Server.

What is the correct way?

edited Jan 1 at 17:12

James Z

11.2k71936

asked Jan 1 at 14:18

thotwielder

74942352

What is your SSMS version? Please use the latest SSMS

– Jayendran
Jan 1 at 14:44

This is probably better suited for dba.stackexchange.com

– James Z
Jan 1 at 17:13

@Jayendran i tried 17.9 and 17.9.1

– thotwielder
Jan 2 at 2:46

add a comment |

I am trying to restore a SQL Server database in Azure from a database backup file stored in a blob. I have followed this link but got this error

TITLE: Microsoft SQL Server Management Studio

An error occurred while loading data.

ADDITIONAL INFORMATION:

The type of a blob in the container is unrecognized by this version. (Microsoft.SqlServer.StorageClient)

The remote server returned an error: (409) Conflict. (System)

I have also tried this:

CREATE CREDENTIAL mycredential1   

WITH IDENTITY= 'jjt', -- this is the name of the storage account you specified when creating a storage account   

SECRET = 'storage account key'

Then try to use the credential to restore the sql db from the azure blob, but failed on the above step with the following error:

Msg 40514, Level 16, State 1, Line 1

'CREATE CREDENTIAL' is not supported in this version of SQL Server.

What is the correct way?

edited Jan 1 at 17:12

James Z

11.2k71936

asked Jan 1 at 14:18

thotwielder

74942352

What is your SSMS version? Please use the latest SSMS

– Jayendran
Jan 1 at 14:44

This is probably better suited for dba.stackexchange.com

– James Z
Jan 1 at 17:13

@Jayendran i tried 17.9 and 17.9.1

– thotwielder
Jan 2 at 2:46

add a comment |

I am trying to restore a SQL Server database in Azure from a database backup file stored in a blob. I have followed this link but got this error

TITLE: Microsoft SQL Server Management Studio

An error occurred while loading data.

ADDITIONAL INFORMATION:

The type of a blob in the container is unrecognized by this version. (Microsoft.SqlServer.StorageClient)

The remote server returned an error: (409) Conflict. (System)

I have also tried this:

CREATE CREDENTIAL mycredential1   

WITH IDENTITY= 'jjt', -- this is the name of the storage account you specified when creating a storage account   

SECRET = 'storage account key'

Then try to use the credential to restore the sql db from the azure blob, but failed on the above step with the following error:

Msg 40514, Level 16, State 1, Line 1

'CREATE CREDENTIAL' is not supported in this version of SQL Server.

What is the correct way?

edited Jan 1 at 17:12

James Z

11.2k71936

asked Jan 1 at 14:18

thotwielder

74942352

I am trying to restore a SQL Server database in Azure from a database backup file stored in a blob. I have followed this link but got this error

TITLE: Microsoft SQL Server Management Studio

An error occurred while loading data.

ADDITIONAL INFORMATION:

The type of a blob in the container is unrecognized by this version. (Microsoft.SqlServer.StorageClient)

The remote server returned an error: (409) Conflict. (System)

I have also tried this:

CREATE CREDENTIAL mycredential1   

WITH IDENTITY= 'jjt', -- this is the name of the storage account you specified when creating a storage account   

SECRET = 'storage account key'

Then try to use the credential to restore the sql db from the azure blob, but failed on the above step with the following error:

Msg 40514, Level 16, State 1, Line 1

'CREATE CREDENTIAL' is not supported in this version of SQL Server.

What is the correct way?

azure azure-sql-database

edited Jan 1 at 17:12

James Z

11.2k71936

asked Jan 1 at 14:18

thotwielder

74942352

edited Jan 1 at 17:12

James Z

11.2k71936

asked Jan 1 at 14:18

thotwielder

74942352

edited Jan 1 at 17:12

James Z

11.2k71936

edited Jan 1 at 17:12

James Z

11.2k71936

edited Jan 1 at 17:12

James Z

11.2k71936

asked Jan 1 at 14:18

thotwielder

74942352

asked Jan 1 at 14:18

thotwielder

74942352

asked Jan 1 at 14:18

thotwielder

74942352

What is your SSMS version? Please use the latest SSMS

– Jayendran
Jan 1 at 14:44

This is probably better suited for dba.stackexchange.com

– James Z
Jan 1 at 17:13

@Jayendran i tried 17.9 and 17.9.1

– thotwielder
Jan 2 at 2:46

add a comment |

What is your SSMS version? Please use the latest SSMS

– Jayendran
Jan 1 at 14:44

This is probably better suited for dba.stackexchange.com

– James Z
Jan 1 at 17:13

@Jayendran i tried 17.9 and 17.9.1

– thotwielder
Jan 2 at 2:46

What is your SSMS version? Please use the latest SSMS

– Jayendran
Jan 1 at 14:44

This is probably better suited for dba.stackexchange.com

– James Z
Jan 1 at 17:13

@Jayendran i tried 17.9 and 17.9.1

– thotwielder
Jan 2 at 2:46

add a comment |

1 Answer
1

active

oldest

votes

You cannot use CREATE CREDENTIAL on Azure SQL Database, you need to create a CREATE DATABASE SCOPED CREDENTIAL as shown below:

CREATE DATABASE SCOPED CREDENTIAL UploadInvoices  

WITH IDENTITY = 'SHARED ACCESS SIGNATURE',

SECRET = 'QLYMgmSXMklt%2FI1U6DcVrQixnlU5Sgbtk1qDRakUBGs%3D';

For more information, please read this article.

Additionally, you cannot restore a native SQL Server backup into an Azure SQL Database. The article you are making reference is restoring a bacpac. You can restore a bacpac into an Azure SQL Database.

Please create a bacpac of your SQL Server (on-premises) database using Microsoft SQL Server Management Studio (SSMS), make a right click on the database, choose Tasks, then choose Export Data-tier Application to create the mentioned bacpac. Once the bacpac has been created you can then import it to Azure SQL Database as a new database.

A better method to migrate your database from a SQL Server instance to Azure SQL database is using the latest version of Data Migration Assistant which you can download from here. This tool would perform an assessment of your SQL Server assessment, it will let you know about any adjustments you need to make to make the database compatible to Azure SQL Database. If the database is compatible, the tool will migrate the database to an Azure SQL Database logical server.

edited Jan 2 at 12:13

answered Jan 1 at 17:40

Alberto Morillo

6,9551918

i can import a local bacpac file to Azure sql db via SSMS. But when I try to connect to the storage account to do the import from azure blob i always got the 409 error.

– thotwielder
Jan 2 at 4:02

@thotwielder I updated my answer

– Alberto Morillo
Jan 2 at 12:13

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53996199%2fazure-restore-a-sql-server-database-from-blob%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

You cannot use CREATE CREDENTIAL on Azure SQL Database, you need to create a CREATE DATABASE SCOPED CREDENTIAL as shown below:

CREATE DATABASE SCOPED CREDENTIAL UploadInvoices  

WITH IDENTITY = 'SHARED ACCESS SIGNATURE',

SECRET = 'QLYMgmSXMklt%2FI1U6DcVrQixnlU5Sgbtk1qDRakUBGs%3D';

For more information, please read this article.

edited Jan 2 at 12:13

answered Jan 1 at 17:40

Alberto Morillo

6,9551918

i can import a local bacpac file to Azure sql db via SSMS. But when I try to connect to the storage account to do the import from azure blob i always got the 409 error.

– thotwielder
Jan 2 at 4:02

@thotwielder I updated my answer

– Alberto Morillo
Jan 2 at 12:13

add a comment |

You cannot use CREATE CREDENTIAL on Azure SQL Database, you need to create a CREATE DATABASE SCOPED CREDENTIAL as shown below:

CREATE DATABASE SCOPED CREDENTIAL UploadInvoices  

WITH IDENTITY = 'SHARED ACCESS SIGNATURE',

SECRET = 'QLYMgmSXMklt%2FI1U6DcVrQixnlU5Sgbtk1qDRakUBGs%3D';

For more information, please read this article.

edited Jan 2 at 12:13

answered Jan 1 at 17:40

Alberto Morillo

6,9551918

i can import a local bacpac file to Azure sql db via SSMS. But when I try to connect to the storage account to do the import from azure blob i always got the 409 error.

– thotwielder
Jan 2 at 4:02

@thotwielder I updated my answer

– Alberto Morillo
Jan 2 at 12:13

add a comment |

You cannot use CREATE CREDENTIAL on Azure SQL Database, you need to create a CREATE DATABASE SCOPED CREDENTIAL as shown below:

CREATE DATABASE SCOPED CREDENTIAL UploadInvoices  

WITH IDENTITY = 'SHARED ACCESS SIGNATURE',

SECRET = 'QLYMgmSXMklt%2FI1U6DcVrQixnlU5Sgbtk1qDRakUBGs%3D';

For more information, please read this article.

edited Jan 2 at 12:13

answered Jan 1 at 17:40

Alberto Morillo

6,9551918

You cannot use CREATE CREDENTIAL on Azure SQL Database, you need to create a CREATE DATABASE SCOPED CREDENTIAL as shown below:

CREATE DATABASE SCOPED CREDENTIAL UploadInvoices  

WITH IDENTITY = 'SHARED ACCESS SIGNATURE',

SECRET = 'QLYMgmSXMklt%2FI1U6DcVrQixnlU5Sgbtk1qDRakUBGs%3D';

For more information, please read this article.

edited Jan 2 at 12:13

answered Jan 1 at 17:40

Alberto Morillo

6,9551918

edited Jan 2 at 12:13

answered Jan 1 at 17:40

Alberto Morillo

6,9551918

answered Jan 1 at 17:40

Alberto Morillo

6,9551918

answered Jan 1 at 17:40

Alberto Morillo

6,9551918

i can import a local bacpac file to Azure sql db via SSMS. But when I try to connect to the storage account to do the import from azure blob i always got the 409 error.

– thotwielder
Jan 2 at 4:02

@thotwielder I updated my answer

– Alberto Morillo
Jan 2 at 12:13

add a comment |

i can import a local bacpac file to Azure sql db via SSMS. But when I try to connect to the storage account to do the import from azure blob i always got the 409 error.

– thotwielder
Jan 2 at 4:02

@thotwielder I updated my answer

– Alberto Morillo
Jan 2 at 12:13

i can import a local bacpac file to Azure sql db via SSMS. But when I try to connect to the storage account to do the import from azure blob i always got the 409 error.

– thotwielder
Jan 2 at 4:02

@thotwielder I updated my answer

– Alberto Morillo
Jan 2 at 12:13

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

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

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu