Complete the Databases Guided Setup for Azure SQL Managed Instance

The Databases guided setup guides you through creating a server plan and adding a SQL database server.

Procedure

1. From the navigation pane, go to Guided setup.

   The Welcome page appears.

2. On the Protect tab, click the Databases tile.

   The Configure Database Server page appears.

3. Select Database running in the cloud (PaaS), and then select Microsoft Azure.

4. Click Next. The Select a Database Service page appears.

5. Select Azure SQL Server and Managed SQL.

6. Click Next.

   The Plan page of guided setup appears.

7. If you already have a server plan, select it. Otherwise, create a new plan.

8. Click Next. The Add cloud account page appears.

9. If you already have an existing cloud account, from the Cloud account list, select the account. Otherwise, add a new cloud account.

10. Click Next. The Instance Details page appears.

11. From the Instance name list, select the Azure SQL instance.

12. From the SQL server authentication list, select the credentials for Azure Server admin account.

    By default, this account is the instance server admin account that has access to the instance and database to perform all operations, including backup, restore, and browse operations.

    Steps to add a credential

    1. Click +. The Add credential dialog box appears.

    2. In the Credential name box, enter a name for the credential.

    3. In User account, enter the user name of the Azure Server admin account.

    4. In the Password box, enter the password for theAzure Server admin account.

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

    6. Click Save.

13. To use job results directory configured on the access node for export, move the Use default path for export toggle key to the right.

14. If you want to stage the export on the access node, in the Staging path used for export box, enter the staging path available on the access node.

    Note

    A staging path with Microsoft SQL Server Data-Tier Application Framework (DacFx) allows you to export an Azure SQL database to a BACPAC file larger than 200 GB.

15. Click Next.

    The Backup Content page appears.

16. All the Azure SQL instances will be backed up automatically. Click Next. The Summary page appears.

17. Click Finish.