Document Center

    Database Backup Service (DBS)

    • Release notes
    • Product Introduction
      • What is DBS?
      • Benefits
      • Scenarios
      • Database engines and features
      • Terms
        • Backup methods
        • 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
      • Overview
      • Preparations
        • Activate DBS
        • AliyunServiceRoleForDBS
        • Add a backup gateway
        • Select the region of a DBS instance
        • Select a backup method
        • Performance tests on backup restoration to MySQL
        • Select backup schedule specifications
        • How to determine the number of DBS instances
        • Backup and recovery performance tests
        • How the backup process works
      • Purchase a backup schedule
      • Configure a backup schedule
      • View backup plans
      • Restore a database
      • Upgrade a backup schedule
      • Use storage plans
    • CDM Technology
      • Overview
      • Limits of the DBS sandbox feature
      • Quick start
      • Create emergency ApsaraDB RDS instances
    • 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
    • Backup
      • Back up one or more databases
      • Manage backup policies
      • Manage backup plans
      • Backup and restoration scenarios
      • Logical backup
        • Back up a MySQL instance
        • Use DBS to back up MongoDB databases
        • Back up MongoDB databases from secondary databases
        • Back up Oracle databases
        • Use DBS to back up a PolarDB MySQL instance
        • Back up a PolarDB-X instance
        • Use DBS to back up a Redis database
        • Use DBS to back up an ApsaraDB RDS for PostgreSQL instance
      • Physical backup
        • Back up a MySQL database
        • Log backup for MySQL
        • Source deduplication
        • Back up 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
      • Multi-level storage pool
        • Overview
        • Configure a multi-level backup policy
        • Geo-redundancy
      • Backup set query
        • Overview
        • Query data in a single backup set
        • Query data in 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
    • Restoration
      • Restore Oracle databases
      • Restore MySQL databases
      • Create a MySQL sandbox instance
      • Restore an Oracle database
      • Restore Oracle standalone databases
      • Prepare for restoring a standalone Oracle database
      • Restore an SQL Server database to ApsaraDB for RDS
      • Restore MongoDB databases
      • Restore files
      • 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
        • Use DBS for remote backup
        • Perform a remote backup on an ApsaraDB RDS for MySQL instance
      • 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
        • Restore the data of a single table
    • FAQs
      • 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
      • How do I adjust the backup speed
    • API Reference
      • API overview
      • Backup schedule
        • 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)
  • 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 in 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