All Products
Search

This Product

    Database Backup:Modify the backup source

    Document Center

    Database Backup:Modify the backup source

    Last Updated:Jun 05, 2024

    If the backup source of a backup schedule does not meet your requirements, you can modify the backup source. This topic describes how to modify the backup source of a backup schedule.

    Scenarios

    • The original backup source database is migrated to another environment or is no longer in use. You want to change the backup source database to another database to ensure smooth backups and business stability.

    • After testing is complete, you change the backup source database used in the testing to a production database. You want to set the database in the production environment as the backup source to ensure the integrity and availability of the backup of the production data.

    • The account and password that are configured to connect to the backup source database are invalid, or the database account does not have sufficient permissions. You want to change the database account and password of the backup source database or grant permissions to the database account.

    • The tables of the backup source database change. For example, a database object is added, deleted, or modified. You want to reconfigure the backup objects.

    Prerequisites

    • The backup schedule uses the logical backup method.

    • The database account of the backup source has the permissions to back up and restore data. For more information, see Account permissions.

    Procedure

    1. Log on to the Database Backup (DBS) console. In the left-side navigation pane, click Backup Schedules.

    2. On the Backup Schedules page, find the backup schedule that you want to manage and click Manage in the Actions column. The Configure Task page appears.

    3. In the Basic Information section, click Edit Backup Source. For more information about how to configure different backup source databases, see Backup and restoration overview.

      image

    4. Configure the information about the new backup source. After the backup source passes the connection test, click Next.

      image

    5. Configure the database objects to be backed up and click Save.

      • To add a new source database, select the database in the Available section and click the image icon.

      • To delete a selected database, select the database in the Selected section and click the image icon.

      image

    6. After the precheck is passed, click Start Task. The new backup source is configured.

      Note

      • If an existing incremental backup task is running based on the backup schedule, the incremental backup task is ended after you click Start Task. The system schedules and starts a new incremental backup task by using the new account and password.

      • If no full backup task is running based on the backup schedule, the system immediately starts a full backup task after you click Start Task. To minimize the impact on the backup source database, we recommend that you modify the backup configurations during off-peak hours.

      • If an existing full backup task is running based on the backup schedule, the configurations of the backup task are not updated after you click Start Task. The system performs a full backup based on the latest configurations only when a new full backup task is scheduled or started the next time.

    Related API operations

    For information about how to modify the backup source or objects by calling API operations, see ModifyBackupSourceEndpoint or ModifyBackupObjects.