#Manage the Backup Scopes for SQL Server

The SQL Server (including Microsoft SQL Server in Azure VM and Self-managed SQL Server) offers protection for your databases in virtual machines using CAP Gateway mode.

In the SQL Server service, Self-managed SQL Server refers to SQL Servers that you install, configure, maintain, and operate yourself, whether they are deployed in the cloud or on premises.

• Self-managed SQL Server on cloud - The SQL Servers running on virtual machines in cloud platforms such as Azure, AWS, or GCP. While the cloud provider manages the underlying infrastructure, you are responsible for managing the SQL Servers yourself.

• Self-Managed SQL Server on premises - The SQL Servers installed and operated on local virtual machines in your on-premises environment.

You can perform the following actions for backup scopes:

• To create a new backup scope for SQL Server, refer to Create a New Backup Scope for SQL Server .

• For the existing backup scopes, you can perform the following actions:

  • Edit - To edit a backup scope, you can select a backup scope and click Edit button on the command bar, or you can click the Edit button when you are viewing the backup scope details. For details on the backup scope settings, refer to Create a New Backup Scope for SQL Server .

  • Delete - To delete a backup scope, you can select a backup scope and click Delete button on the command bar, or you can click the Delete option from the More actions list when you are viewing the details of a backup scope. You can also select multiple backup scopes to delete. When deleting backup scopes, you can select how to handle your backup data: keep the data and follow the configured retention policy, keep the data for 30 days before deletion, or delete the backup data immediately

  • Run backup now - If you want to start a backup immediately, you can select a backup scope and click Run backup now, or you can click the Run backup now from the More actions list when you are viewing the details of a backup scope.