Data Management:Modify a backup source

Use cases

• Database migration: The original source database has moved to a new environment or is decommissioned. Update the backup source to point to the new database and maintain backup continuity.

• Promotion to production: Testing is complete and you want to back up the production database instead. The new source must match the production environment so that backup data integrity is preserved.

• Invalid credentials or insufficient permissions: The database account or password has changed, or the account lacks the required backup and restore permissions. Update the credentials or reconfigure the account permissions.

• Schema changes: Tables or database objects have been added, removed, or renamed. Reconfigure the backup objects to reflect the current schema.

Prerequisites

Before you begin, make sure that:

• The backup schedule uses the logical backup method.

• The database account of the backup source has permissions to back up and restore data.

Update the backup source

1. Log on to the DMS console V5.0.

2. In the top navigation bar, choose Security and Specifications (DBS) > Disaster Recovery for Data (DBS) > Backup Plan.

   Note

   In simple mode, hover over the icon in the upper-left corner and choose All Features > Security and Specifications (DBS) > Disaster Recovery for Data (DBS) > Backup Plan.

3. On the Backup Schedules page, find the target backup schedule and click Manage in the Actions column. The Configure Task page opens.

4. In the Basic Information section, click Edit Backup Source. For configuration details specific to your database type, see Configure a backup schedule and restore data.

   

5. Configure the new backup source. After the connection test passes, click Next.

   

6. Select the database objects to back up and click Save.

   • To add a database, select it in the Available section and click .

   • To remove a database, select it in the Selected section and click .

   

7. After the precheck passes, click Start Task. The new backup source is active once Start Task completes.

   Note

   • Incremental backup running: The current incremental backup task is terminated. The system schedules a new incremental backup task using the updated credentials.

   • No full backup running: A full backup starts immediately. To minimize impact on the source database, apply this change during off-peak hours.

   • Full backup running: The running full backup is not updated. The new configuration takes effect only when the next full backup task starts.

API reference

To modify the backup source or backup objects programmatically, use the following API operations:

• ModifyBackupSourceEndpoint — update the backup source connection

• ModifyBackupObjects — update the backup objects