Configuring SQL Server Backups Using Local (On-Premises) and Cloud Storage

To back up SQL Server databases running on-premises, configure backups for SQL Server using local and cloud storage copies with a backup gateway.

Procedure

1. From the navigation pane, go to Protect > Databases.

   The Overview page appears.

2. Click Add server.

   The Configure Database Server page appears.

3. Select SQL server.

4. Click Next.

   The Select Your Database Environment page appears.

5. Select Database running on-premises.

6. From the Infrastructure list, select the type of database infrastructure.

   An active trial or an active subscription is required.

7. Click Next.

   The How do you want to deploy your backup? page appears.

8. Select Backup via gateway (Recommended).

9. Click Next.

   The Backup Gateway page appears.

10. Select an existing backup gateway or create a new backup gateway.

11. Click Next.

    The Local Storage page appears.

12. Determine if you want to back up to cloud storage only or to local storage:

    • To back up to cloud storage only, move the Back up to cloud storage only toggle to the right.

    • To back up to local storage, select a location from the Storage location list.

      Steps to add a local storage

      1. Click +.
         The Add local storage dialog box appears.

      2. In the Name box, enter a name for the local storage.

      3. Click Add.
         The Add backup location dialog box appears.

      4. In the Backup location box, enter the path on the MediaAgent where the backup data is stored.

      5. Click Add.

      6. Click Save.

13. Click Next.

    The Cloud Storage page appears.

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

15. To use only an on-premises storage, move the Only use on-premises storage toggle key to the right.

16. Decide whether to store a secondary copy of the backup data for long-term retention. To use an existing storage, from the Storage location list, select a storage.

    For information about creating a new storage, see Creating a Cloud Storage for SQL Server Backups With a Backup Gateway Configuration.

17. Click Next.

    The Plan page appears.

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

19. Click Next.

    The Install Package page appears.

20. To perform a push installation, select Push installation, and then select one or more database servers from the list at the bottom of the page, or add a new database server.

21. To add a new database server, click +, then complete the following in the Add database server page:

    1. In the Host name box, enter the host name.

    2. For OS type, select the operating system.

    3. If you select Windows operating system, from the Credential list, select a saved credential.

    4. If you select Unix operating system, do the following:

       1. From the Credential list, select a saved credential.

       2. In the UNIX group box, enter the name of the Unix group.

       3. In the SSH port number box, verify the port number.

       4. If you want to use SSH instead of user credentials, move the Use SSH key toggle to the right, and then in the SSH key path box, enter the file path.

       5. To use an SSH key file passphrase, move the Use SSH key file passphrase toggle key to the right, and the in the Passphrase box, enter the passphrase for the SSH key.

    5. Click Save.

22. 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. From the Server name drop-down list, select the name of the server.

23. Click Next.

    The Credentials page appears.

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

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

26. 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.

27. Click Next.

    The Backup Content page appears.

28. All SQL server instances running on the server will be auto discovered.

29. Click Next.

    The Summary page appears.

30. Review the summary.

31. Click Finish.