Complete the Databases Guided Setup for Azure SQL Managed Instance

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

Procedure

From the navigation pane, go to Guided setup.

The Welcome page appears.
On the Protect tab, click the Databases tile.

The Configure Database Server page appears.
Select Database running in the cloud (PaaS), and then select Microsoft Azure.
Click Next. The Select a Database Service page appears.
Select Azure SQL Server and Managed SQL.
Click Next.

The Plan page of guided setup appears.
If you already have a backup plan, select it. Otherwise, create a new backup plan.
Click Next. The Add cloud account page appears.
If you already have an existing cloud account, from the Cloud account list, select the account. Otherwise, add a new cloud account.
Click Next. The Instance Details page appears.
From the Instance name list, select the Azure SQL instance.
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.
In the Specify storage connection string box, enter the string to access data within the Azure storage account.

Tip

To get the connection string for your storage account, in the Azure portal, go to the storage account, and then go to Security + networking > Access keys.
Click Next.

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