Database Backup (DBS) provides features such as full backup, incremental backup, and data restoration. In special cases, you may need to change the backup source database in a backup schedule to another database so that you can use the backup schedule to back up that database. This topic describes how to change or modify the backup source database in 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.
  • After testing is complete, you want to change the backup source database used in the testing to a production database.
  • The account and password that are configured to connect to the backup source database are improper, and the database account does not have sufficient permissions. You want to change the database account and password of the backup source database.
  • The tables of the backup source database change. You want to change the backup objects.

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules. In the top navigation bar, select a region.
  3. 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.
    • If you want to change the backup source database or its account and password, perform the following steps:
      1. 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.
      2. Modify the information about the backup source database and click Test Connection. If the test is successful, click Next.
      3. Select the objects of the backup source database that you want to back up in the Available section, add them to the Selected section, and then click Save.
      4. If the precheck is successful, click Start Task. The backup configurations are modified.
        Note
        • If an existing incremental backup task is running based on the backup schedule, the status of the incremental backup task changes to Complete 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.
    • If you want to change only the backup objects of the backup source database, perform the following steps:
      1. In the Basic Information section, click Edit Backup Objects.
      2. Select the objects of the backup source database that you want to back up in the Available section, add them to the Selected section, and then click Save.
      3. In the Start Full Data Backup message, click OK or Close.
        • If you click OK, a full backup task starts within one minute to back up the new objects that are specified in the backup schedule.

          To minimize the impact on the backup source database, we recommend that you perform this operation during off-peak hours.

        • If you click Close, the modified configurations are saved, but the system does not immediately perform a full backup. The system performs a full backup based on the latest configurations only when a new full backup task is scheduled the next time.