Backing up a database to an azure blob storage

1 Creating a Storage account

1) Click Browse->storage Accounts

2) Fill in the storage account, please remember this name, then create credential need to use.

3) Click Create. Usually wait a little while.

2 Creating container

1) All Resources->blobs

2) on the BLOB service page, click Create a new containers.

3) container URLs need to remember that you need to specify when backing up

3 Creating credential

1) All resource->access Keys

2) Copy any of the two keys.

3) Execute the following statement in the SQL database that you want to back up

Create credential credential1 with identity=' liweistoragetest '

,secret=' ******** '

The value of the secret is replaced with the key obtained in the previous step.

Then you can back it up.

For example

Backup database db1 to URL=' https://liweistoragetest.blob.core.windows.net/ Liweistoragetestcontainer/db1.bak '

with Credential =' Credential1 '

After the backup is complete, we can see the corresponding data in the BLOB

Backing up a database to an azure blob storage