Document Center

    Database Backup Service (DBS)

    • Product Introduction
      • What is DBS?
      • Benefits
      • Scenarios
      • Database engines and features
      • Terms
        • Backup methods
        • Data size
        • Built-in storage and OSS
    • Pricing
      • Billing methods and billing items
      • Overdue payments and expiration
    • Quick Start
      • Overview
      • Preparations
        • Authorize RAM roles
        • 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 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 strategy
      • Manage backup plans
      • Backup and restoration overview
      • Logical backup
        • Back up a MySQL instance
        • Use DBS to back up a MongoDB database
        • Use DBS to back up an Oracle instance
        • 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
        • Use DBS to back up an Oracle RAC database
        • Back up a file
        • Back up an SQL Server database
      • 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
        • Query and analyze audit data of an SQL Server database in backup sets
      • Back up to local storage
        • Overview
        • Manually download a backup set
        • Configure automatic download of backup sets
        • View download progress
    • Restoration
      • Create a MySQL sandbox instance
      • Restore an Oracle database
      • Restore an Oracle standalone instance
      • Restore an SQL Server database to ApsaraDB for RDS
    • 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
      • Database 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
      • List of operations by function
      • Backup schedule
        • Create a backup plan
        • Configure the backup schedule
        • Renew a backup plan
        • Upgrade a backup plan
        • View a backup plan
        • Enable incremental backup
        • Start a backup schedule
        • Disable incremental backup
        • Pause a backup plan
        • Modify a backup object
        • Release a pay-as-you-go backup schedule
        • Modify the lifecycle of stored data
        • 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 recovery task list
      • Backup Gateway
        • View the backup gateway list
      • Others
        • 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
      • Backup set query
        • View the data query service (DLA)
        • Disable the data query service (DLA)
    • 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: Query and analyze audit data of an SQL Server database in backup sets

    How helpful was this page?

    What might be the problems?

      More suggestions?

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