Home > Quick Start for Trial Users > Azure SQL Databases
Export to PDFAzure SQL Databases
To protect your Azure SQL databases using AvePoint Cloud Backup for IaaS + PaaS, follow these steps:
-
Connect your tenant.
- If you want to protect your Microsoft Entra tenant via AvePoint services, your tenant owner or service administrators must first connect the tenant to AvePoint Online Services. See for details.
-
Configure the app profile.
- Set up the app profile for the app required to protect the Azure SQL databases. Use your Microsoft 365 Global Admin Account to consent to the application. See Create an App Profile and Grant Consent for details.
-
Add to subscription and grant role.
-
After creating the app profile in AvePoint Online Services, add the app to each subscription where the Azure SQL databases you want to protect belong. See Add to Subscriptions and Assign the Contributor Role for details.
-
If you want to enable the Azure SQL backup service, add a SQL server admin role for the app you want to use to protect Azure SQL databases. See Grant a SQL Server Admin Role for details.
-
-
Create the backup scope.
-
Navigate to Cloud Backup for IaaS + PaaS > Backup page and create a backup scope for native Azure SQL backup monitoring or Azure SQL backup. Define the protected databases, configure the backup start time, and ensure the data retention policy and backup schedule meet your organization’s needs. See Create a New Backup Scope for Native Azure SQL Backup Monitoring or Create a New Backup Scope for Azure SQL Backup for details.
*Note: With a Trial subscription, you can create one backup scope to protect up to 5 databases for each service.
-
-
Monitor and manage backups.
-
Regularly monitor the backup status and ensure that backups are running as scheduled. See Monitor Your Backup for details.
-
Use the Backup Analysis report to monitor your backup statistics. See for details.
-
-
Test restores.
- Periodically test the restore process to ensure that you can recover data quickly and accurately. See Restore Monitored Databases or Restore Backup Databases for details.