How To: Backup a Database Using DAC Service

To backup a database using DAC service:

  1. Select the DAC Service item in the Backup Destination section of the SQL Azure page.
  2. In the Storage name field, specify the name of the storage created in the storage account.
  3. In the Access key field, specify the primary or secondary access key that can be obtained in the storage account properties.
  4. In the dropdown list, select the Storage item if you're using the primary access key or the Shared item if you're using the secondary access key.
  5. In the Container field, specify the name of the container created in the storage.
  6. In the File name field, specify the name of the backup file.

     

To obtain the storage name:

  1. Log in to https://windows.azure.com/.
  2. Navigate to Hosted Services, Storage Accounts & CDN -> Storage Accounts tab.
  3. Select a storage drive.
  4. Copy the value of the Blob URL field.

To obtain the access key:

  1. Log in to https://windows.azure.com/.
  2. Navigate to Hosted Services, Storage Accounts & CDN -> Storage Accounts tab.
  3. Select a storage drive.
  4. In the Primary/Secondary access key field click the View button. The View Storage Access Keys window opens.
  5. In View Storage Access Keys window, copy the value of the Primary/Secondary access key field.

See Also