All Products
Search
Document Center

ApsaraDB RDS:Restore the data of an ApsaraDB RDS for SQL Server instance across regions

Last Updated:Sep 15, 2023

This topic describes how to restore the data of an ApsaraDB RDS for SQL Server instance from a cross-region backup file to a new RDS instance. The new RDS instance must reside in the same region as the cross-region backup file.

Prerequisites

Your RDS instance is backed up across regions. For more information, see Use the cross-region backup feature.

Note

Procedure

  1. Log on to the ApsaraDB RDS console. In the left-side navigation pane, click Backups. In the top navigation bar, select the region in which your RDS instance resides.

  2. On the Backup Instances tab of the Cross-region Backup tab, find the RDS instance and click the ID of the instance.

  3. On the page that appears, find the backup set that you want to use and click Restore in the Actions column.

    Note

    You can restore data of the RDS instance by using full or incremental backup sets. You cannot restore data of the RDS instance by using log backup sets.

  4. In the message that appears, click OK.

    Note

    You can restore data only to a new instance. You cannot restore data to an existing instance.

  5. On the Restore Database page, configure the following parameters.

    Parameter

    Description

    Billing Method

    • Subscription: A subscription RDS instance is an instance for which you pay an upfront fee. For long-term usage, the subscription billing method is more cost-effective than the pay-as-you-go billing method. You are charged lower prices for longer subscription periods.

    • Pay-As-You-Go: A pay-as-you-go RDS instance is billed per hour based on your actual resource usage. We recommend that you select the pay-as-you-go billing method for short-term use. If you no longer need your pay-as-you-go RDS instance, you can release it to reduce costs.

    Restore Method

    • By Backup Set: allows you to restore the data of your RDS instance from a data backup file.

    • By Time: allows you to restore the data of your RDS instance to a specific point in time. The point in time must be within the specified log backup retention period.

    By Backup Set

    The data backup file from which you want to restore the data of your RDS instance. This parameter appears only when you set the Restore Method parameter to By Backup Set.

    By Time

    The point in time to which you want to restore the data of your RDS instance. This parameter appears only when you set the Restore Method parameter to By Time.

    Region

    The region to which the new RDS instance belongs.

    Zone

    A zone is an independent physical location within a region. The Zone of Primary Node parameter specifies the zone to which the primary RDS instance belongs. The Zone of Secondary Node parameter specifies the zone to which the secondary RDS instance belongs.

    You can select the Single-zone Deployment or Multi-zone Development method.
    • Single-zone Deployment: If you select this deployment method, the values of the Zone of Primary Node and Zone of Secondary Node parameters are the same.
    • Multi-zone Development: We recommend that you select this deployment method to ensure zone-level disaster recovery. If you select this deployment method, the value of the Zone of Primary Node parameter differs from the value of the Zone of Secondary Node parameter. You must manually configure the Zone of Primary Node and Zone of Secondary Node parameters.
    Note
    • After the RDS instance is created, you can view information about the new RDS instance and its secondary RDS instance on the Service Availability page.
    • If you select RDS Basic Edition, the database system consists of only one primary RDS instance and supports only the single-zone deployment method.

    Instance Type

    The instance type of the new RDS instance. Each instance type supports a specific number of CPU cores, memory capacity, maximum number of connections, and maximum IOPS. For more information, see Primary ApsaraDB RDS instance types.

    Capacity

    The maximum storage capacity that is provisioned to store data files, system files, binary log files, and transaction files in the instance.

    Note

    The settings of some parameters cannot be modified. These parameters include Database Engine, Version, and Edition. The same settings of these parameters must be specified for both your RDS instance and the new RDS instance.

  6. Click Next: Instance Configuration to configure the network type and resource group of the RDS instance.

    Parameter

    Description

    Network Type

    • Classic Network: the traditional type of network.

    • VPC: the recommended type of network. A virtual private cloud (VPC) is an isolated virtual network that provides higher security and higher performance than the classic network. If you select the VPC network type, you must also specify the VPC and vSwitch of Primary Node parameters.

    Note

    The network type of the RDS instance must be the same as the network type of the ECS instance that you want to connect. If the RDS instance and the ECS instance both reside in VPCs, these instances must reside in the same VPC. If the RDS instance and the ECS instance reside in different VPCs, these instances cannot communicate over an internal network.

    Resource Group

    You can use resource groups to categorize the resources of your Alibaba Cloud account. Resource groups help you simplify the management of resources and permissions in your Alibaba Cloud account. You can select an existing resource group or create a resource group. If you do not need to group resources, select Default Resource Group.

  7. Click Next: Confirm Order.
  8. Confirm the settings in the Parameters section, configure the Purchase Plan and Duration parameters, read and select Terms of Service, click Pay Now, and then complete the payment. You must configure the Duration parameter only when the RDS instance uses the subscription billing method.
    Note If you select the subscription billing method for the new RDS instance, we recommend that you select Auto-Renew Enabled. This way, you do not need to manually renew the new RDS instance on a regular basis. This also helps prevent interruptions on your workloads on the new RDS instance if a payment becomes overdue.
  9. Optional. Log on to the new RDS instance and verify the data. For more information, see Connect to an ApsaraDB RDS for SQL Server instance.

References

After you create an RDS instance, you must configure IP address whitelists or security groups and create accounts. For more information, see Configure an IP address whitelist and Create an account. If you want to connect to the RDS instance over the Internet, you must also apply for a public endpoint. For more information, see Apply for or release a public endpoint. After you complete these operations, you can connect to the RDS instance. For more information, see Connect to an ApsaraDB RDS for PostgreSQL instance.

Related operations

Operation

Description

CheckCreateDdrDBInstance

Checks whether an instance has a cross-region backup set that can be used to restore data across regions.

CreateDdrInstance

Restores the data of an instance to a new instance.

ModifyInstanceCrossBackupPolicy

Modifies the cross-region backup settings of an instance.

DescribeInstanceCrossBackupPolicy

Queries the cross-region backup settings of an instance.

DescribeCrossRegionBackups

Queries the cross-region data backup files of an instance.

DescribeCrossRegionLogBackupFiles

Queries the cross-region log backup files of an instance.

DescribeAvailableCrossRegion

Queries the available destination regions to which the cross-region backup files from a specific source region can be replicated.

DescribeAvailableRecoveryTime

Queries the restorable time range that is supported by a specified cross-region backup file.

DescribeCrossRegionBackupDBInstance

Queries the instances for which the cross-region backup feature is enabled in a region and the cross-region backup settings of the instances.