All Products
Search

This Product

    Data Management:Physically back up and restore a cross-cloud or self-managed SQL Server database

    Document Center

    Data Management:Physically back up and restore a cross-cloud or self-managed SQL Server database

    Last Updated:Mar 30, 2026

    Data Disaster Recovery supports full backup, incremental backup, and point-in-time restore for self-managed SQL Server databases. This topic describes how to configure a physical backup schedule and restore data from backup.

    Prerequisites

    Before you begin, ensure that you have:

    • A supported SQL Server version: 2019, 2017, 2016, 2014, 2012, 2008R2, 2005, or 2000

    • A self-managed database running on the Windows operating system — either on-premises or on a cloud server (cloud-managed databases are not supported)

    • A backup gateway installed. See Install a backup gateway

    • A backup schedule purchased with Data Source Type set to SQL Server and Backup Method set to Physical Backup. To create one, see Create a backup schedule

    Usage notes

    Do not configure more than one backup schedule for the same SQL Server database. Otherwise, exceptions may occur during restoration.

    Configure a backup schedule

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

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

      If you use the DMS console in simple mode, move the pointer over the 2023-01-28_15-57-17.png icon in the upper-left corner and choose All Features > Security and Specifications (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

    3. On the Backup Schedules page, find the backup schedule you want to configure and click Configure Backup Schedule in the Actions column.

    4. In the Configure Backup Source and Destination step, configure the parameters listed below, and then click Next.

      Backup source information

      Parameter Description
      Schedule Name A name for the backup schedule. Data Disaster Recovery generates a name automatically. Use a descriptive name to identify the schedule easily. Names do not need to be unique.
      Backup Mode The backup method. Defaults to the method selected when you purchased the schedule. This example uses physical backup.
      Instance Region The region where the database resides. The backup gateway must be in the same region.
      Backup Gateway The backup gateway to use. See Install a backup gateway.
      Database Type The database type. Default value: SQL Server.
      Address The endpoint of the database to back up. Default value: localhost.
      Port Number The port of the database to back up. Default value: 1433.
      Compliance warranty regarding cross-border data transfers Read and agree to the compliance commitment.

      Backup destination information

      Parameter Description
      Backup Storage Type Where to store backup data. DBS Storage (recommended): Data is stored in Data Disaster Recovery — no Object Storage Service (OSS) bucket required. You are charged based on storage volume. See Storage fees. OSS For User: Backup data is stored in an OSS bucket that you create in advance. Only the Standard storage class is supported. You must also configure the OSS Bucket Name parameter. If your data volume is large, consider purchasing subscription storage plans, which are more cost-effective than pay-as-you-go pricing.
      Storage Encryption How to encrypt stored data. Encrypted (recommended): AES-256 encryption with OSS server-side encryption. When you upload an object, OSS encrypts it automatically and decrypts it on download. See Server-side encryption. Non-encrypted: Data is stored without encryption.

      image

    5. In the Edit Backup Objects step, select the database or table to back up in the Available section, click the right arrow to move it to the Selected section, and then click Next.

      If the Available section is empty, the backup gateway account lacks the required permissions. See the Troubleshooting section. Backing up an entire database includes permission data and stored procedures.

    6. In the Configure Backup Time step, configure the parameters below, and then click Next.

      Parameter Description
      Full-scale Backup Frequency The backup schedule type. Periodic Backup: Runs on a recurring schedule — configure Full Data Backup Recurrence, Start At, and incremental backup parameters. Single Backup: Runs once.
      Full Data Backup Recurrence The days of the week on which Data Disaster Recovery runs the full backup.
      Start At The start time for the full backup. If a previous full backup is still running at the next scheduled start time, Data Disaster Recovery skips that run.
      Incremental Backup Whether to enable incremental backup. When enabled, Data Disaster Recovery performs incremental backups at the interval specified in Incremental Backup Interval.
      Incremental Backup Interval How often incremental backups run. For example, a 10-minute interval triggers an incremental backup every 10 minutes.
      Does not automatically delete backed up incremental Whether to retain archived redo log files after backup. Enable: Archived redo log files are not automatically deleted. Disable: Archived redo log files backed up seven days ago are deleted automatically. To change the default retention period, contact technical support. For example, you can contact technical support to change the retention period to 14 days.
      Enable compression Whether to compress data during backup. Enable (recommended): Compresses backup data to reduce storage usage. Disable: Data is not compressed.

    7. In the Edit Lifecycle step, configure the lifecycle for full backup data in the Configure Full Data Backup Lifecycle section. If you enabled incremental backup in the previous step, also configure the lifecycle for incremental backup data. For lifecycle rule details, see How do I manage the lifecycle rules of backup sets?

    8. Click Precheck in the lower-right corner.

    9. When the Precheck Passed message appears, click Start Task.

      SQL server预检查

    Restore backup data

    Data Disaster Recovery supports point-in-time restore: specify any timestamp within the available time range to restore the database to that exact state. The available time range is displayed automatically based on your backup sets.

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

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

      If you use the DMS console in simple mode, move the pointer over the 2023-01-28_15-57-17.png icon in the upper-left corner and choose All Features > Security and Specifications (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

    3. On the Backup Schedules page, find the backup schedule and click Manage in the Actions column.

    4. On the Configure Task page, click Restore Database in the upper-right corner.

    5. In the Set Time Restored To step, configure the parameters below, and then click Next.

      Parameter Description
      Task Name A name for the restore task. Data Disaster Recovery generates a name automatically. Names do not need to be unique.
      Time Range Available to Restore The time range available for restoration, displayed by Data Disaster Recovery based on existing backup sets.
      Restore To The point in time to restore the database to. Must fall within the Time Range Available to Restore.
      Instance Region The region where the destination database resides — also the region where the backup gateway is installed.
      Backup Gateway The backup gateway for the destination. See Install a backup gateway.
      Database Type The destination database type. Default value: SQL Server.
      Address The endpoint of the destination database. Default value: localhost.
      Port Number The port of the destination database. Default value: 1433.
      Compliance warranty regarding cross-border data transfers Read and agree to the compliance commitment by selecting the check box.

      image.png

    6. In the Available section, select the destination database, click the right arrow to move it to the Selected section, and then click Precheck.

    To monitor progress, click Restore Tasks in the left-side navigation pane.

    Restore duration depends on backup schedule specifications and database size. Higher-specification schedules restore data faster. See Performance tests on logical backup and physical backup.

    Troubleshooting

    The Available section is empty when I configure a backup schedule, even though the backup gateway is installed.

    The backup gateway account lacks the required permissions. Assign the sysadmin role to the NT AUTHORITY\SYSTEM account by running the following SQL statement:

    ALTER SERVER ROLE [sysadmin] ADD MEMBER [NT AUTHORITY\SYSTEM]
GO