Relational Database ServiceRelational Database Service

Compute
Elastic Cloud Server
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
Domain Name Service
VPC Endpoint
Cloud Connect
Enterprise Switch
Security & Compliance
Anti-DDoS
Web Application Firewall
Host Security Service
Data Encryption Workshop
Database Security Service
Advanced Anti-DDoS
Data Security Center
Container Guard Service
Situation Awareness
Managed Threat Detection
Compass
Cloud Certificate Manager
Anti-DDoS Service
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GaussDB NoSQL
GaussDB(for MySQL)
Distributed Database Middleware
GaussDB(for openGauss)
Developer Services
ServiceStage
Distributed Cache Service
Simple Message Notification
Application Performance Management
Application Operations Management
Blockchain
API Gateway
Cloud Performance Test Service
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
DevCloud
ProjectMan
CodeHub
CloudRelease
CloudPipeline
CloudBuild
CloudDeploy
Cloud Communications
Message & SMS
Cloud Ecosystem
Marketplace
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP License Service
Support Plans
Customer Operation Capabilities
Partner Support Plans
Professional Services
enterprise-collaboration
Meeting
IoT
IoT
Intelligent EdgeFabric
DeveloperTools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Updated at: Apr 02, 2022 GMT+08:00

Downloading a Backup File

Scenarios

This section describes how to download a manual backup, an unsynchronized backup, or an automated backup to a local device and restore data from the backup file.

You can download full backup files of Microsoft SQL Server DB instances.

Constraints

  • Unsynchronized backups are generated only for DB instances running Microsoft SQL Server 2017 Enterprise Edition. If a primary DB instance fails, the standby DB instance is promoted to the new primary instance. During the failover process, a small amount of data may not be synchronized and a differential backup is created for user-created databases on the original primary DB instance. For more information, see How Are Unsynchronized Backups Generated for RDS SQL Server DB Instances?
  • If the size of the backup data is greater than 400 MB, you are advised to use OBS Browser+ to download the backup data.
  • When you use OBS Browser+ to download backup data, there is no charge for the generated outbound traffic.

Method 1: Using OBS Browser+

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Database > Relational Database Service. The RDS console is displayed.
  4. On the Backup Management page, locate the target backup to be downloaded and click Download in the Operation column.

    Alternatively, click the target DB instance. In the navigation pane on the left, choose Backups & Restorations. On the displayed page, locate the target backup to be downloaded and click Download in the Operation column.

  5. In the displayed dialog box, select Use OBS Browser+ for Download Method and click OK.

    Figure 1 Using OBS Browser+
    Figure 2 Download guide
    1. Download OBS Browser+ following the step 1 provided in Figure 2.
    2. Decompress and install OBS Browser+.
    3. Log in to OBS Browser+.

      For details about how to log in to OBS Browser+, see Logging In to OBS Browser+ in the Object Storage Service Tools Guide.

    4. Disable certificate verification on OBS Browser+.

      For details on how to configure OBS Browser+, see Configuring the System in the Object Storage Service Tools Guide.

      The OBS bucket name displayed in the Download Backup File pane on the RDS console does not support certificate verification. OBS Browser+ certificate verification needs to be disabled before the external bucket can be added, then it must be enabled again after the backup is downloaded.

    5. Add an external bucket.

      In the Add Bucket dialog box of OBS Browser+, select Add external bucket and enter the bucket name provided in step 2 of Figure 2.

    6. Download the backup file.

      On the OBS Browser+ page, click the bucket that you added. In the search box on the right of OBS Browser+, enter the backup file name provided in step 3 of Figure 2. In the search result, locate the target backup and download it.

      Microsoft SQL Server allows you to download backup files of a specific database.

    7. After the backup is downloaded, enable OBS Browser+ certificate verification.

  6. Follow the instructions provided in Restoring from Backup Files to a Self-Built SQL Server Database to restore data locally as required.

Method 2: Using Download URL

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Database > Relational Database Service. The RDS console is displayed.
  4. On the Backup Management page, locate the target backup to be downloaded and click Download in the Operation column.

    Alternatively, click the target DB instance. In the navigation pane on the left, choose Backups & Restorations. On the displayed page, locate the target backup to be downloaded and click Download in the Operation column.

  5. In the displayed dialog box, select a method to download backup data.

    Figure 3 Selecting a download method

    In the displayed dialog box, select Use Download URL for Download Method, click to copy the URL, and click OK.

    For Microsoft SQL Server DB instances, the URLs of all the backup files are displayed. You can download the backup files of a specific database.

    • You can use other download tools to download backup files.
    • You can also run the following command to download backup files:

      wget -O FILE_NAME --no-check-certificate "DOWNLOAD_URL"

      Variables in the commands are as follows:

      FILE_NAME: indicates the new backup file name after the download is successful. The original backup file name may be too long and exceed the maximum characters allowed by the client file system. You are advised to use the -O argument with wget to rename the backup file.

      DOWNLOAD_URL: indicates the path of the backup file to be downloaded. If the path contains special characters, escape is required.

  6. Follow the instructions provided in Restoring from Backup Files to a Self-Built SQL Server Database to restore data locally as required.

Did you find this page helpful?

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel