Restore an SQL Server database

Billing Rules

The restore feature is free of charge.

Usage notes

• Cloud Backup's backup and restore speeds are based on data from a lab test environment and are for reference only. For more information, see Database backup and restore speeds.

• To restore data to a new SQL Server instance, you must register the instance in the Cloud Backup console in advance, and ensure that its database status is Online.

• To restore data to a specific point in time, you must enable log backup.

• When you restore an SQL Server database, if you select an incremental backup, the full backup is automatically restored. You do not need to restore the full backup separately before restoring the incremental backup.

• To restore an SQL Server database across SQL Server instances, ensure that the source SQL Server version is the same as the destination SQL Server version.

• Before Cloud Backup restores the master database, it automatically restarts SQL Server and switches it to single-user mode. For more information, see Restore the master database.

• When you restore a database in an SQL Server Always On availability group, only availability groups whose seeding mode is set to Manual are supported. If an availability group uses the Automatic seeding mode, switch it to Manual before you restore the database.

Restore scope

• Restorable databases

  You can restore databases that you created and the master, model, and msdb system databases. When you restore a system database, you cannot restore it to a different name.

• Recovery points

  You can restore to any specified point in time, or restore based on a specified backup checkpoint LSN.

  In the Restore Content step, select the database to restore from the Recoverable Database drop-down list, then in the Backup Sets for Restoration area, select the target backup set (differential and database/full types are supported).

Create an SQL Server restore job

To restore a backed-up database, perform the following steps:

1. Log on to the Cloud Backup console.

2. In the left-side navigation pane, choose Backup > Database Backup, select the region where the database instance resides, then click SQL Server. Click the ECS Database Instance or Local Database Instance tab. Find the target SQL Server instance and, in the Actions column on the right, click Restore.

3. In the Create Restore Job panel, follow the configuration wizard to complete the following operations.

   1. Configure the restore content, then click Next.

      Parameter	Description
      Recoverable Database	Select the database to restore from the list.
      Backup Point Type	Specify the backup point type. To restore from a specified point in time, select By Time. To restore from a specified backup file, select Specified Backup. In the Backup Set list, click the target backup file.

   2. Configure the Plan Name for this restore job, start the restore immediately, then click Next.

      Note

      Currently, only immediate restore is supported. You cannot specify a restore time.

   3. Configure the Restore Config, then click Next.

      Parameter	Description
      Retry Time	The interval for reconnecting after the database is disconnected during the restore. Unit: minutes.
      Speed Limit	The amount of data restored per second. Unit: MB/s. A value of 0 indicates no limit. To prevent database performance issues caused by an excessively large restore volume, we recommend that you set a reasonable speed limit.
      Restore As	The name of the database after the restore. Important When Recovery Point Type is set to Specified Backup: System databases: You cannot change the database name, database file path, data file name, or log file name. Non-system databases: You can edit these settings. When Recovery Point Type is set to By Time, regardless of whether the database is a system database or a non-system database, the database name, database file path, data file name, and log file name are not displayed on the Restore Config tab.

   4. Configure the destination instance for the restore, then click Create.

      Use the Specified Account field to select the account that owns the destination resource. By default, the current account is used, and cross-account restore is supported. Then select the target database instance; by default, it is the SQL Server instance used at backup time.

      Note

      You can select the Only Check Offline Instance option to find offline instances. You can restore the data on these offline instances to a new instance on which the new client is installed to implement cross-instance data restoration. For more information, see Database backup FAQ.

   After the restore job is created, the system starts to restore the database. On the Restore Plan tab, you can view the progress of the restore job that you created.

   The restore job then appears in the task list with a status of Complete (100% progress). Expand Detail of Restore to view the connection between the source and destination instances and the configured restore parameters.

FAQ

• What is a backup vault?

• Database Backup FAQ

• How do data expiration and cleanup work for a backup vault?

• How do I view the backup data size and backup vault usage? What are the billing rules?