All Products
Search

This Product

    Cloud Backup:Restore a SQL Server database

    Document Center

    Cloud Backup:Restore a SQL Server database

    Last Updated:Sep 15, 2026

    After you back up an SQL Server database to a backup vault using Cloud Backup, you can restore the database to the source SQL Server instance or to another registered SQL Server instance.

    Prerequisites

    • You have backed up the SQL Server database in the Cloud Backup console. For more information, see Back up an SQL Server database.

    • The destination SQL Server instance must be Online. A restore job fails if the destination instance is in an abnormal state. For more information, see Database Backup FAQ.

    Billing

    The restore feature is free of charge.

    Usage notes

    • The backup and restore speeds for Cloud Backup are based on data from a lab 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 and ensure that its status is Online.

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

    • When restoring from an incremental backup, Cloud Backup automatically restores the corresponding full backup. You do not need to restore the full backup separately.

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

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

    Restore scope

    • Restorable databases

      You can restore user-created databases and the master, model, and msdb system databases. When you restore a system database, you cannot change its name.

    • Recovery points

      You can restore a database to a specific point in time or to a specific Log Sequence Number (LSN).

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

    Create an SQL Server restore job

    To restore a database:

    1. Log on to the Cloud Backup console.

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

    3. In the Create Restore Job panel, complete the following steps.

      1. Configure the restore content and then click Next.

        Parameter

        Description

        Recoverable Database

        Select the database to restore from the list.

        Backup Point Type

        Select a recovery point type.

        • By Time: Restores the database to a specific point in time.

        • Specified Backup: Restores the database from a specific backup. In the Backup Set list, click the target backup.

      2. Enter a Plan Name for the restore job and click Next.

        Note

        Only immediate restore is supported.

      3. Configure the Restore Config parameters, and then click Next.

        Parameter

        Description

        Retry Time

        The interval in minutes to wait before retrying a connection that drops during the restore.

        Speed Limit

        The maximum restore speed in MB/s. A value of 0 indicates no limit.

        To prevent performance issues caused by high restore throughput, set a reasonable speed limit.

        Restore As

        The name of the restored database.

        Important

        • If recovery point type is set to Specified Backup:

          • For a system database, you cannot change the database name, data file path, data file name, or log file name.

          • For a non-system database, you can edit these settings.

        • If recovery point type is set to By Time, the database name, data file path, data file name, and log file name are not displayed on the Restore Config tab for either system or non-system databases.

      4. Select the target instance for the restore and click Create.

        Select the target database instance. By default, the source SQL Server instance is selected. You can also restore the database to another registered SQL Server instance.

        Note

        You can select the Only Check Offline Instance checkbox to find offline instances. This allows you to restore data from an offline instance to a new instance where a new client is installed, which enables cross-instance data recovery. For more information, see Database backup FAQ.

      The restore job starts automatically after creation. You can monitor its progress on the Restore Plan tab.

      After the restore job is created, it appears in the task list with a status of Completed (100% progress). Expand Restore Details to view the connection between the source and target instances and the configured restore parameters.

    FAQ