Skip to main content

Restore physical backup data

If a database operation fails or data is lost, use NineData Backup and Restore to restore physical backup data to a self-managed SQL Server database.

Before you begin​

  • A full backup has been completed. For details, see Perform physical backup.
  • The restore target database has been added to NineData through the Gateway connection method. For details, see Add data sources.
  • The restore target is a self-managed SQL Server database.

Restrictions​

The restore target version must be greater than or equal to the version of the data source in the backup data. For example, SQL Server 2019 backup data cannot be restored to SQL Server 2017.

Procedure​

  1. Sign in to the NineData Console.

  2. In the navigation pane, click Backup > Restore.

    tip

    Alternatively, open Backup > Backup Set, go to the Full Backup Set tab, find the target backup set ID, and click Restore in the Actions column.

  3. On the Restore Method tab, configure the parameters in the table, and click Next.

    Parameters
    		Description
    NameEnter a name for the restore task. Use a meaningful name to make the task easier to find and manage later. The name can contain up to 64 characters.
    SourceSelect the source of the backup objects. This helps you quickly locate the target Backup Task.
    Backup TaskSelect the backup task that contains the data required for restore.
    Restore MethodSelect one of the supported restore methods:
    • Restore by Time: Restores data based on full backup data and logs. This method can restore full data and subsequent incremental data. For the available restore time range, see the console.
    • Backup Set: Restores data from full backup data only. This method restores data to the point in time when the full backup completed, and does not include incremental data.
    Restore TimeConfigure this parameter when Restore Method is Restore by Time. Select the point in time to restore to. When second-level RPO is available, restore data to any point in time from the backup start time to the current time.
    Backup SetConfigure this parameter when Restore Method is Backup Set. This restore option does not include incremental data.
    TargetSelect the target data source to restore backup data to.
    GatewayPhysical restore writes files directly to the target data source, so the target data source must have a gateway configured. If the data source was added through a gateway, this parameter is already configured. If the data source was not added through a gateway, first add the host where the data source is located to Gateway, and then connect the data source through the gateway. For details, see Add data sources.

  4. On the Restore Objects tab, configure the parameters in the table, and click Next.

    Parameters
    		Description
    Restore ObjectsConfirm the content to restore. Select Backup to restore all data, or select one or more Customized Object entries to restore selected objects.
    Database already exists processing strategy
    • Overwrite the existing database (WITH REPLACE): If a database with the same name exists in the target, overwrite it with the database from the backup file.
    • Error and Exit: If a database with the same name exists in the target, report an error during pre-check.

  5. On the Mapping tab, configure the database name to use after restore to the target data source, and click Save and Pre-Check.

  6. On the Pre-Check tab, wait for NineData to complete the pre-check. After the pre-check passes, click Launch.

    tip

    • If the pre-check fails, click Details in the Actions column for the failed check item, review and fix the issue, and run the pre-check again.

    • For warnings, review the message and decide whether to fix the item or continue.

    • To save the task without starting it immediately, click Save Task. NineData saves the restore task to the Restore task list for later use, without requiring the same configuration again.

  7. On the Launch tab, wait for the Launch Successfully message. Click View Details to open the restore task execution details, or click Back to List to return to the Restore list.

Result​

The restore task starts with the selected physical backup data, restore target, object scope, mapping, and database conflict strategy. Monitor progress from the restore task details page.