This topic describes how to restore the data of an ApsaraDB RDS for SQL Server instance.

Background information

You can use one of the following methods to restore the data of your RDS instance:

Restore the data to an existing instance

You can restore the data of your RDS instance to the original RDS instance or to a different existing RDS instance. During this process, you can restore some or all of the databases that are created on your RDS instance. In addition, you can restore the data from a data backup file or to a specific point in time.

Note This method is supported for RDS instances that run SQL Server 2008 R2 with standard or enhanced SSDs (ESSDs), SQL Server 2012, SQL Server 2016, SQL Server 2017, or SQL Server 2019.
  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Backup and Restoration.
  3. Click Restore.
  4. In the Select Restore Method dialog box, select Restore to Existing Instance and click OK.
  5. Configure the following parameters and click OK.
    Parameter Description
    Restore Method
    • By Time: allows you to restore the data to a point in time within the specified log retention period. For information about how to view or change the log backup retention period, see Back up an ApsaraDB RDS for SQL Server instance.
    • By Backup Set: allows you to restore the data from a full or incremental data backup file.
    Restore Time This parameter appears only when you set the Restore Method parameter to By Time. Select the point in time to which you want to restore the data.
    Backup Set This parameter appears only when you set the Restore Method parameter to By Backup Set. Select the data backup file from which you want to restore the data.
    More Backup Sets This parameter displays the latest 1,000 data backup files. If you cannot find the required data backup file from the Backup Set drop-down list, you can select this check box. Then, ApsaraDB RDS displays more data backup files for you to search.
    Destination Instance Name Select the destination RDS instance to which you want to restore the data.

    By default, ApsaraDB RDS displays all the RDS instances that are created within your Alibaba Cloud account and reside in the selected region. These displayed RDS instances include the original RDS instance whose data you want to restore.

    Note
    • If you use a snapshot backup file, you can restore the data only to an RDS instance on which the snapshot backup feature is enabled. For more information, see Enable snapshot backups for an ApsaraDB RDS for SQL Server instance.
    • The destination RDS instance can run a higher SQL Server version than the original RDS instance.
    • If the original RDS instance belongs to the shared instance family, you cannot restore the data of the instance to a general-purpose or dedicated RDS instance. Similarly, if the original RDS instance belongs to the general-purpose or dedicated instance family, you cannot restore the data of the instance to a shared RDS instance.
    • If ApsaraDB RDS displays a large number of RDS instances, you can enter a keyword in the Destination Instance Name field to search for the required destination RDS instance.
    Databases to Restore
    1. Select the databases that you want to restore. By default, ApsaraDB RDS displays and selects all the databases that are created on the original RDS instance.
      • If you want to restore all the data of the original RDS instance, select all the databases.
      • If you want to restore one or more databases, select only the required databases.
    2. Specify the names that you want to use for the selected databases on the destination RDS instance. By default, the original names of the selected databases are retained.
      Note The names of the selected databases on the original RDS instance cannot be the same as those of the existing databases on the destination RDS instance.
    Note
    • If a selected database on the original RDS instance has the same name as an existing database on the destination RDS instance, you must specify New Database Name for the selected database.
    • The value of New Database Name can contain only lowercase letters, digits, underscores (_), and hyphens (-).

Restore data to a new RDS instance

You can restore the data of your RDS instance to a new RDS instance. This process was previously known as instance cloning. During this process, you can specify to restore the data from a data backup file or to a specific point in time. If you restore the data from a data backup file, you can restore some or all of the databases whose data is included in the file.

You must pay for the new RDS instance. The required fee is the same as the amount you pay when you purchase the RDS instance. If you no longer require the original RDS instance after the restoration, we recommend that you immediately release or unsubscribe from the instance. For more information, see Release or unsubscribe from an ApsaraDB RDS for SQL Server instance.

Note This method is supported for RDS instances that run SQL Server 2008 R2 with standard or ESSDs, SQL Server 2012, SQL Server 2016, SQL Server 2017, or SQL Server 2019.
  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Backup and Restoration.
  3. Click Restore.
  4. In the dialog box that appears, select Restore to New Instance and click OK.
  5. On the Restore Database (Previously Clone Instance) page, configure the following parameters.
    Parameter Description
    Billing Method
    • Subscription: A subscription instance is an instance for which you pay an upfront fee. For long-term use, the subscription billing method is more cost-effective than the pay-as-you-go billing method. You are offered lower prices for longer subscription periods.
    • Pay-As-You-Go: A pay-as-you-go instance is charged per hour based on your actual resource usage. For short-term use, we recommend that you select the pay-as-you-go billing method. If you no longer need a pay-as-you-go instance, you can release the instance to reduce costs.
    Restore Mode
    • By Time: allows you to restore data to a point in time within the specified log retention period. For more information about how to view or change the log backup retention period, see Back up an ApsaraDB RDS for SQL Server instance.
    • By Backup Set: allows you to restore the data from a data backup file.
    Note
    • The By Time option is available only after the log backup feature is enabled.
    • You can restore some or all of the databases that are created on the original RDS instance.
    Database Specify whether to restore some or all of the databases that are created on the original RDS instance. If you select Part, you must manually enter the names of the databases that you want to restore. In addition, you must separate the database names with commas (,).
    Note If you have enabled the snapshot backup feature for the original RDS instance, you can select only All Instances but not Part. For more information, see Enable snapshot backups for an ApsaraDB RDS for SQL Server instance.
    Edition
    • Basic: The database system consists of only a primary RDS instance. Computing is separated from storage to increase cost-effectiveness.
    • High-availability: The database system consists of a primary RDS instance and a secondary RDS instance. These instances work in the high-availability architecture.
    • Cluster: The database system consists of a primary RDS instance, a secondary RDS instance, and up to seven read-only RDS instances. The read capability of the database system improves with the number of read-only RDS instances.
    Note The available RDS editions vary based on the region and database engine version that you select. For more information, see Overview of ApsaraDB RDS editions.
    Zone of Primary Node
    Instance Type
    • General-purpose (Entry-level): specifies the general-purpose instance family. A general-purpose instance exclusively occupies the allocated memory and I/O resources. However, it shares CPU and storage resources with the other general-purpose instances that are deployed on the same server.
    • Dedicated (Enterprise-level): specifies the dedicated instance family or the dedicated host instance family. A dedicated instance exclusively occupies the allocated CPU, memory, storage, and I/O resources. The dedicated host instance family is the highest configuration of the dedicated instance family. A dedicated host instance exclusively occupies all the CPU, memory, storage, and I/O resources of the server on which the instance is deployed.
    • Dedicated: A dedicated cluster exclusively occupies all the resources on a VM or physical host. The permissions to manage hosts in a dedicated cluster can be authorized to you. This allows you to create multiple database instances on a host. For more information, see Add hosts.
    Note Each instance type supports a specific number of CPU cores, memory capacity, maximum number of connections, and maximum IOPS. For more information, see Primary instance types.
    Capacity The storage capacity that is provided for the RDS instance to store data files, system files, binary log files, and transaction files. You can adjust the storage capacity in increments of 5 GB.
    Note Dedicated instances are allocated exclusive resources. Therefore, the storage capacity of a dedicated instance that is equipped with local SSDs varies based on the instance type. For more information, see Primary ApsaraDB RDS instance types.
  6. Click Next: Instance Configuration.
  7. Configure the following parameters.
    Parameter Description
    Network Type
    Resource Group The resource group to which the new RDS instance belongs.
  8. Click Next: Confirm Order.
  9. 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 new RDS instance uses the subscription billing method.

Restore the data to the original RDS instance by using a temporary RDS instance

This method is supported for RDS instances that run SQL Server 2008 R2 with local SSDs. For more information, see Restore the data of an ApsaraDB RDS for SQL Server instance by using a temporary RDS instance.

Related operations

Operation Description
Restore databases Restores the data of an ApsaraDB RDS instance.