Database Backup (DBS) provides features such as full backup, incremental backup, and data restoration. This topic describes how to use the physical backup method to back up an SQL Server database.

Prerequisites

  • The version of the database engine is SQL Server 2000, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, or SQL Server 2019.
  • A backup gateway is added. For more information, see Add a backup gateway.
    Note For more information about backup methods, see Backup methods.

Create a backup schedule

For more information about how to create a backup schedule, see Purchase a backup schedule.
Note When you purchase a backup schedule, set Database Type to SQL Server and set Backup Method to Physical Backup.

Configure a backup schedule

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, select a region in the upper-left corner.
    Select a region
  3. On the Backup Schedules page, click Configure Backup Schedule in the Actions column corresponding to the backup schedule that you want to configure.
  4. In the Configure Backup Source and Destination step of the Configure Backup Schedule wizard, configure the backup source and destination, and click Next in the lower-right corner of the page.
    Section Parameter Description
    N/A Schedule Name The name of the backup schedule. DBS generates a backup schedule name. We recommend that you set a descriptive name that makes it easy to identify. Backup schedule names do not have to be unique.
    Backup Source Information Backup Mode The method that is used to back up data. By default, the backup method that you selected when you purchased the backup schedule is used. Physical Backup is used in this example.
    Instance Region The region where the instance that you want to back up is deployed.
    Backup Gateway The backup gateway that you want to install to back up data. For more information, see Add a backup gateway.
    Database Type The database engine of the instance. SQL Server is used in this example.
    Address The endpoint that is used to connect to the database that you want to back up. Default value: localhost.
    Port Number The port number used to connect to the database that you want to back up. Default value: 1433.
    Backup Destination Information Backup Storage Type The storage type of the destination database. Valid values:
    • DBS built-in storage (recommended)
    • OSS for user
    Note In this example, select DBS built-in storage (recommended). If you select OSS for user, you must set the OSS Bucket Name parameter.
    OSS Bucket Name The name of the OSS bucket.

    This parameter is available only when you set the Backup Storage Type parameter to OSS for user.

    Storage Encryption The method used to encrypt the backup data. Valid values:
    Configure a backup schedule for an SQL Server database
  5. In the Edit Backup Objects step, find the database or table that you want to back up in the Available section. Click the right arrow to add the selected database or table to the Selected section. Then, click Next.
    Note If you back up an entire database, the permission data and stored procedures are also backed up.
  6. In the Configure Backup Time step, set the backup frequency and policy, and click Next in the lower-right corner of the page.
    Parameter Description
    Full-scale Backup Frequency The frequency of the backup schedule. Valid values: Periodic Backup and Single Backup.
    Note If you select Periodic Backup, you must set Full Data Backup Recurrence, Full Data Backup Start At, and incremental backup-related parameters.
    Full Data Backup Recurrence The days of the week on which DBS runs the backup schedule.
    Full Data Backup Start At The start time of the backup.
    Note If the time required to complete a full data backup is longer than the backup interval, DBS skips the next backup.
    Real-Time Transaction Log Backup Specifies whether to enable incremental backup.
    Audit backup Specifies whether to enable audit backup.

    This parameter is available only when you set the Real-Time Transaction Log Backup parameter to Enable.

    Transaction Log backup interval The interval at which incremental backup is performed. If you set the interval to 10 minutes, the system performs an incremental backup every 10 minutes.
    Note The interval applies to both audit backups and incremental backups. The minimum interval is 10 minutes.
    Does not automatically delete backed up incremental Specifies whether to automatically delete the archived redo log files that are backed up. Valid values:
    • Enable: The archived redo log files that are backed up are not automatically deleted.
    • Disable: The system automatically deletes the archived redo log files that were backed up seven days ago.
    Note If you want to change the default time period after which the archived redo log files are automatically deleted, submit a ticket. For example, you want to change the default time period from 7 days to 14 days.
    Enable compression Specifies whether to enable compression during backup. Valid values:
    • Enable
    • Disable
  7. In the Edit Lifecycle step, configure the lifecycle for a full data backup in the Configure Full Data Backup Lifecycle section.
    Note If you select Enable for the Real-Time Transaction Log Backup parameter, you must configure the backup time for incremental backup data.
  8. After the configuration is complete, click Precheck in the lower-right corner of the page.
  9. On the Precheck message, wait until "Precheck Passed 100%" is displayed in the progress bar, and then click Start Task.
    The Precheck message
    Note When the state of the backup schedule changes to Running, the backup schedule takes effect.

What to do next