Configuring Backups for SQL Server Databases in Microsoft Azure

You can configure backups for SQL Server databases on Azure Compute. The configuration wizard guides you through the configuration process, which includes creating any new entities that are needed, such as a plan, an object storage client, and a content group.

Procedure

1. From the navigation pane, go to Protect > Databases.
   The Overview page appears.

2. In the upper-right area of the page, click Add server.
   The Select Database Type page appears.

3. Select SQL server.
   The Select Your Database Environment page appears.

4. Select Database running in the cloud VM.

5. From the Select vendor list, select Microsoft Azure.
   An active trial or an active subscription is required.

6. Click Next.
   The Backup Method overview page appears.

7. Review the information.

8. Click Next.
   The Region page appears.

9. From the region list, select the region where the cloud storage is located.

10. Click Next.
    The Cloud Storage page appears.

11. Review the supported combinations of primary and secondary storage.

12. For the primary copy of the backup data, select existing cloud storage or create new cloud storage.

13. Decide whether to store a secondary copy of the backup data for long-term retention.

    For information about creating a primary copy or a secondary copy, see Creating a Cloud Storage for SQL Server Backups on Azure.

14. Click Next.
    The Plan page appears.

15. Select an existing plan or create a new plan.

16. Click Next.

    The Install Package page appears.

17. To perform an interactive installation, complete the following:

    1. Select Interactive installation.

    2. Download the SQL Server package, and then install it on the server you want to back up.

    3. Copy the authcode, and then use it to authenticate the SQL Server package on the server.

    4. In the Server name drop-down list, select the name of the server.

18. Click Next.

    The Credentials page appears.

19. To use a local system account for impersonation, move the Use local system account toggle key to the right.

20. To use a saved credential, select the existing credential.

21. To create a new credential, do the following:

    1. Click +.

       The Add Credential dialog box appears.

    2. In the Credential name box, enter a unique name to access the credential.

    3. In the User account box, enter the user account that access to the SQL server.

    4. In the Password box, enter the password for the user account.

    5. In the Description box, enter a brief description for the credential.

    6. Click Save.

    Note

    • If you are installing the SQL Server on a Windows server, select the Windows account for SQL impersonation. A new credential is added as Windows account.

    • If you are installing the SQL Server on a Linux server, select the SQL account for SQL impersonation. A new credential is added as SQL account.

    • If a credential is not selected, the local system account will be used for impersonation. If a credential is selected, credentials for impersonation should be common between all selected servers. Once the installation is complete, credential will be available for modification at the server level.

    • If you have servers that are running on Windows and Linux, a common credential must not be used. Instead, leave the credential blank and set the impersonation on servers manually after the installation completed.

22. Click Next.
    The Backup Content page appears.

23. Review the list of instances that will be protected.

24. Click Next.

25. Review the summary.

26. Click Finish.