Viewing Azure SQL Resources
To view the list of available Azure SQL resources, open the Azure page in the Backup section of the main menu and select the Azure SQL tab:
- The Protected Resources section includes backup policies widgets. Each widget provides the name of the backup policy that protects SQL resources, the backup policy priority, state and Azure subscription. Hover over the backup policy name for more details.
- The Unprotected Resources section displays the list of all unprotected SQL resources.
Each resource is represented with a set of properties, such as:
- Name — the name of the Azure SQL resource.
- Group — the name of the group that includes the Azure SQL resource.
- Size/Sub. — the size of the Azure SQL database and the subscription plan of the group that includes the Azure SQL resource.
- Last Backup — the date and time of the most recent backup policy run (if any).
You can perform the following actions for Azure SQL resources:
- Sort the list of displayed backup policies by name, group or time of the last created backup. To do that, click the arrow next to the Name, Group or Last backup column.
- Edit existing backup policies that protect Azure SQL resources. To do this, click the icon in the upper right corner of the policy widget and update information in the Edit Azure SQL Policy wizard. To learn more, see Editing Backup Policy Settings.
- Create new backup policies to protect virtual machines. To do this, click the Create new Policy button in the Unprotected Resources window and complete the new policy wizard. To learn more, see Creating SQL Backup Policy.
- Refresh the page if you want to update the results on the page. To do this, click the Refresh button in the upper right corner of the page and specify the refresh options.