#SQL Server

To protect your SQL Server (including Microsoft SQL Server in Azure VM and Self-managed SQL Server) databases using AvePoint Cloud Backup for IaaS + PaaS, follow these steps:

1. Connect your tenant.

   • If you want to protect your tenant via AvePoint services, your tenant owner or service administrators must first connect the tenant to AvePoint Online Services. See Connect Your Tenants to AvePoint Online Services for details.

2. Configure the app profile.

   • Set up the app profile for the app required to protect the SQL Server databases. See Configure Default AvePoint App Profiles for Microsoft Tenants for details.

3. Enable authentication for your SQL Server.

   • For Microsoft SQL Server in Azure VM, refer to Enable Microsoft Entra ID Authentication.

   • For Self-managed SQL Server, refer to Enable SQL Server Authentication.

4. Create the CAP Gateway.

   • Navigate to Cloud Backup for IaaS + PaaS > Settings > CAP Gateways page to create a CAP Gateway for SQL Server. See Manage CAP Gateways for details.

5. Create the backup scope.

   • Navigate to Cloud Backup for IaaS + PaaS > Backup page and create a backup scope for SQL Server using the CAP Gateway mode. 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 SQL Server for details.

6. Monitor and manage backups.

   • Regularly monitor the backup status and ensure that backups are running as scheduled. See Monitor Your Backup for details.

7. Test restores.

   • Periodically test the restore process to ensure that you can recover data quickly and accurately.