Document Center

    Database Backup Service (DBS)

    • Release notes
    • Product Introduction
      • What is DBS?
      • Benefits
      • Scenarios
      • Database engines and features
      • Terms
        • Logical backup, physical backup, and snapshot-based backup
        • Data size
        • Built-in storage and OSS
    • Pricing
      • Billing overview
      • Backup fees
      • Storage fees
      • Network traffic fees
      • DBS sandbox fees
      • Overdue payments and expiration
    • Quick Start
      • Flowchart
      • Purchase a backup schedule
      • Configure a backup schedule
      • Restore a database
      • Use storage plans
      • Specification requirements
        • Select a backup method
        • Select backup schedule specifications
        • Performance tests on backup and restoration
    • User Guide
      • Backup Schedules
        • Supported data sources
        • Add a data source
        • Add multiple data sources at a time
        • Configure automatic access to a data source
        • Configure the account and password for a data source
      • Storage Pool
        • What is a storage pool?
        • Add and remove storage pools
        • Multi-level storage pool
          • Overview
          • Configure a multi-level backup policy
          • Geo-redundancy
      • Backup
        • Back up one or more databases
        • Manage backup policy templates
        • Modify the backup policy of a backup schedule
        • Backup and restore scenarios
        • Logical backup
          • Back up a MySQL instance
          • Back up an Oracle database
          • Use DBS to back up MongoDB databases
          • Back up MongoDB databases from secondary databases
          • Back up a PolarDB for MySQL instance
          • Back up a PolarDB-X instance
          • Back up a Redis instance
          • Use DBS to back up an ApsaraDB RDS for PostgreSQL instance
        • Physical backup
          • Add a backup gateway
          • Add a backup gateway of the bastion host architecture
          • Back up a MySQL database
          • Log backup for MySQL
          • Source deduplication
          • Back up an Oracle database
          • Create a true incremental-forever backup for an Oracle database
          • Prepare for physical backup of an Oracle database
          • Query the locations of files in an Oracle RAC environment
          • Back up a file
          • Back up an SQL Server database
          • Back up an ApsaraDB for Redis instance
      • Manage a backup
        • View backup plans
        • Manage backup plans
        • Backup set query
          • Overview
          • Query data in a single backup set
          • Query data from multiple backup sets at a time
          • Query data in backup sets that are generated based on ApsaraDB for RDS databases
          • Back up and analyze the audit data of an SQL Server database
        • Back up to local storage
          • Overview
          • Manually download a backup set
          • Configure automatic download of backup sets
          • View download progress
        • Upgrade a backup schedule
      • Copy data management
        • Overview
        • Limits of the DBS sandbox feature
        • Create a sandbox instance for emergency recovery
        • Quick start
        • Access sandbox instances
          • Use DMS to access sandbox instances
          • Use ECS to access sandbox instances
        • FAQ
      • Restoration
        • Restore MySQL databases
          • Restore a MySQL database from a logical backup
          • Restore a MySQL database from a physical backup
          • Create a MySQL sandbox instance
        • Restore Oracle databases
          • Restore an Oracle database from a physical backup
          • Restore the logical backup of an Oracle database
          • Restore Oracle standalone databases
          • Prepare for restoring a standalone Oracle database
        • Restore an SQL Server database to ApsaraDB for RDS
        • Restore a PolarDB for MySQL database
        • Restore MongoDB databases
        • Restore a Redis database
        • Restore files
        • Restore data by database or table
        • Disaster recovery drills
    • Best Practices
      • Backup security
        • Authorize RAM roles for data backup or restoration across Alibaba Cloud accounts
        • Back up and restore data across Alibaba Cloud accounts
        • Back up and restore a database across accounts by using a public endpoint and IP address whitelist
        • Automatically archive backup sets to backup servers
        • Retain minimal backup sets
      • Disaster recovery and security
        • Use DBS to back up and restore ECS-hosted user-created databases to meet disaster recovery and security requirements
      • Remote backup
        • Geo-redundancy
        • Perform a remote backup on an ApsaraDB RDS for MySQL instance
        • Use DBS for remote backup
      • Back up to Alibaba Cloud
        • Back up a user-created database in an on-premises data center connected to Alibaba Cloud through Express Connect to OSS or DBS
        • Back up a user-created database in an on-premises data center connected to Alibaba Cloud through VPN Gateway or Smart Access Gateway to OSS or DBS
        • Back up a user-created Redis database and restore the backup data to an ApsaraDB for Redis database
        • Restore SQL Server backup data to the cloud
        • Use Database Gateway to back up on-premises databases or private databases on a third-party cloud to Alibaba Cloud
      • Quick restoration
        • Quick start
    • FAQs
      • How do I activate DBS?
      • Account permissions
      • How do I guarantee consistency of restored data
      • How do I manage lifecycle rules of backup sets?
      • What is backup data volume
      • How do I view the backup data volume
      • How do I change the backup source
      • Why is the running time of DBS backup SQL statements different from that displayed in the ApsaraDB for RDS console
      • Why errors occur during prechecks
      • How to find backup files in OSS
      • What is the difference between DBS and the backup capability of ApsaraDB for RDS
      • How do I back up a read-only ApsaraDB for RDS instance
      • How do I restore a database backup to another database instance by using DBS
      • How to set the binlog_format variable to facilitate database recovery
      • Impact of backups on databases
      • How do I change the maximum backup speed?
    • API Reference
      • List of operations by function
      • Backup schedule
        • Create and start a backup plan
        • Create a backup plan
        • Configure the backup schedule
        • Renew a backup plan
        • Upgrade a backup plan
        • View a backup plan
        • Start a backup schedule
        • Pause a backup plan
        • Enable incremental backup
        • Disable incremental backup
        • Release a pay-as-you-go backup schedule
        • Modify the lifecycle of stored data
        • Modify a backup object
        • Modify the database backup source
        • Modify the name of a backup plan
        • Modify the backup time
        • View recovery time range details
        • View the billing information of a backup schedule
      • Back up node code
        • View incremental backup tasks
        • View the list of full backup jobs
      • Restore tasks
        • Create a restoration task
        • Start a recovery task
        • View the list of recovery tasks
      • Backup Gateway
        • View the backup gateway list
      • Others
        • InitializeDbsServiceLinkedRole
        • View the CIDR blocks of DBS nodes
        • View the node standardization error codes
        • View the pre-check progress list
        • Create a task to obtain the database list through the backup gateway
        • Obtain the database list through the backup Gateway
        • Supported regions
      • Download backup sets
        • view the download list of backup sets
        • Set the download rule for backup sets
        • Create a full backup set download task
        • Create an incremental backup set download task
    • SDK Reference
      • SDK overview
      • Create an AccessKey
      • Use DBS SDK for Java based on Maven dependencies
 
All Products
Search
  • Document Center
  • Database Backup Service (DBS)
  • User Guide
  • Manage a backup
  • Backup set query
  • Query data in backup sets that are generated based on ApsaraDB for RDS databases

This Product

  • This Product
  • All Products

    Query data in backup sets that are generated based on ApsaraDB for RDS databases

    Document Center

    Query data in backup sets that are generated based on ApsaraDB for RDS databases

    Last Updated: Nov 27, 2020

    Database Backup (DBS) allows you to query data in backup sets that are generated based on ApsaraDB for RDS databases. For more information, see Query data from the remote backup files of an ApsaraDB RDS for MySQL instance.

    How it works

    Previous: Query data from multiple backup sets at a time Next: Back up and analyze the audit data of an SQL Server database

    How helpful was this page?

    What might be the problems?

      More suggestions?

      Thank you! We've received your feedback.
      Free Trial Free Trial