{"id":371,"date":"2016-04-13T15:55:00","date_gmt":"2016-04-13T15:55:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/azuregov\/?p=371"},"modified":"2016-04-13T15:55:00","modified_gmt":"2016-04-13T15:55:00","slug":"how-to-backup-to-sql-server-directly-azure-government-storage-account","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azuregov\/how-to-backup-to-sql-server-directly-azure-government-storage-account\/","title":{"rendered":"How To: Backup to SQL Server directly Azure Government Storage Account"},"content":{"rendered":"

You might run into some problems importing your Azure Government publish settings file into SQL Server. However you can still backup to Azure Government Storage Accounts using the Storage Account keys.<\/p>\n

Step 1: Create a credential<\/strong>\nUSE master\nCREATE CREDENTIAL <name of cred> WITH IDENTITY='<the storage account name>’, SECRET='<one of the storage account keys>’<\/p>\n

To get the name and keys, navigate to your storage account in the Azure Gov Management portal and select \u201cManage Access Keys\u201d. You will see them here.\n\"blog01\"<\/a><\/p>\n

\"blog02\"<\/a>\nStep 2: create the backup using the credential you created<\/strong>\nBACKUP DATABASE <name of db> TO\u00a0 URL = N'<backup endpoint>’\nWITH\u00a0 CREDENTIAL = N'<name of cred>’\n, NOFORMAT, NOINIT,\u00a0 NAME = N'<name of backup>’, NOSKIP, NOREWIND, NOUNLOAD,\u00a0 STATS = 10\nGO<\/p>\n

The backup endpoint should look like this\nhttps:\/\/<storage account name>.blob.core.usgovcloudapi.net\/<container name>\/<file name>.bak<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

You might run into some problems importing your Azure Government publish settings file into SQL Server. However you can still backup to Azure Government Storage Accounts using the Storage Account keys. Step 1: Create a credential USE master CREATE CREDENTIAL <name of cred> WITH IDENTITY='<the storage account name>’, SECRET='<one of the storage account keys>’ To […]<\/p>\n","protected":false},"author":5375,"featured_media":20423,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[30],"tags":[130,531],"class_list":["post-371","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-storage-backup-recovery","tag-backup","tag-storage"],"acf":[],"blog_post_summary":"

You might run into some problems importing your Azure Government publish settings file into SQL Server. However you can still backup to Azure Government Storage Accounts using the Storage Account keys. Step 1: Create a credential USE master CREATE CREDENTIAL <name of cred> WITH IDENTITY='<the storage account name>’, SECRET='<one of the storage account keys>’ To […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/users\/5375"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/comments?post=371"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/371\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/media\/20423"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/media?parent=371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/categories?post=371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/tags?post=371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}