Skip to main content

Restore (physical backup data)

In the event of a misoperation or failure of the database, user can restore the backup data to the database through NineData's backup and restore service.

Prerequisite​

  • A full backup has been completed. For how to back up data, see Performing Physical Backups.
  • The database that needs to be restored has been added to NineData through the connection method of the Gateway. For more information, see Manage Datasources.
  • The data source to be restored is the self-managed SQL Server database.

Precautions​

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

Steps​

  1. Log in to NineData console.

  2. On the left navigation bar, click Backup > Restore.

    tip

    User can also click Backup > Backup Set. On the Full Backup Set tab, find the ID of the backup set that has been backed up, and click Restore in the Actions column on the right.

  3. On the Restore Method tab, configure according to the following table, and click Next.

    Parameters
    		Description
    NameEnter the name of the restore task. For the convenience of subsequent search and management, try to use a meaningful name. Up to 64 characters are supported.
    SourceBackup objects, you can quickly find Backup Task by selecting the Source.
    Backup TaskA backup job, created when backing up a data source, contains all the data needed for restore.
    Restore MethodThe following restore methods are supported:
    • Restore by Time: This method is based on full backup data and logs, and can recover full data and subsequent incremental data. For the specific restore time period, see the console.
    • Backup Set : This method is only based on the full backup data, and supports restore to the point in time when the full backup is completed, excluding incremental data.
    Restore TimeIt can be configured when the Restore Method is Restore by Time , and user can select the point in time to which the data will be recovered. The second-level RPO can be achieved, and the data at any point in time between the start of the backup and the current point in time can be restored.
    Backup SetIt can be configured when the Restore Method is Backup Set. This option does not contain incremental data.
    TargetTo restore the object, select which data source to restore the backup data to.
    GatewayPhysical restores files directly to the target data source, so the target data source needs to have a gateway configured. If already accessed through the gateway when adding the data source, it has been automatically configured here. If not provide access the data source through the gateway, please refer to the following steps: add the host where the data source is located to the gateway. Connect the data source through the gateway. For more information, see Manage Datasources.

  4. On the Restore Objects tab, configure according to the following table, and click Next.

    Parameters
    		Description
    Restore ObjectsConfirm the content to be restored. User can select Backup to restore all data, or select multiple Customized Object and selectively restore.
    Database already exists processing strategy
    • Overwrite the existing database (WITH REPLACE) : If there is a library with the same name in the target library, it will be directly overwritten with the database in the backup file.
    • Error and Exit : If there is a library with the same name in the target library, an error will be reported in the pre-check.

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

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

    tip
    • If the pre-check fails, user need to click the Details in the Actions column to the right of the target check item to correct the failure, and then perform the pre-check again.

  • Warnings can be repaired or ignored according to specific circumstances.

  • If no need to start the task immediately, user can click Save Task to return to the list and save the current restore task to the restore task list to avoid reconfiguration later.

    :::

  1. On the Launch tab, a message is displayed indicating that Launch Successfully. Click View Details to view the execution status of the restore tasks; click Back to List to return to Restore list.
Last updated on