Skip to main content

Backup data (physical backup)

NineData data backup service physical backup supports full backup and incremental backup operations for data sources.

Prerequisite​

  • The data source is a self-managed SQL Server database with versions 2022, 2019, 2017, 2016, 2014, 2012, and 2008R2.

  • The self-managed instance has been added to NineData through the connection method of the gateway. For more information, see Manage Datasources.

    tip

    The gateway must be deployed on the host where the self-mangaged instance needs to be physically backed up.

Steps​

  1. Log in to the NineData console.

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

  3. On the Backup page, click Create Backup in the upper right corner.

  4. On the Sources & Target tab, configure according to the table below and click Next.

    Parameters
    		Description
    NameEnter the name of the backup task. For the convenience of subsequent search and management, please try to use a meaningful name. Up to 64 characters are supported.
    DatasourceSelect the data source to back up. For a newly added data source, please click Refresh on the right to get the latest list of data sources.
    Backup method (only for SQL Server)Choose Physical Backup.
    • Logical Backup : A backup method that uses database objects (such as tables, indexes, etc.) as backup objects. Support full backup, incremental backup, structure backup and other backup types.
    • Physical Backup : A backup method that takes the files in the database as the backup object.
    GatewayPhysical backup will directly back up the files in the data source, so a gateway needs to be configured. If already accessed through the gateway when adding the data source, it has been automatically configured here. If do 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.
    Backup typeThe following backup types are supported:
    • Data + Log : The backup data will contain full and incremental data.
    • Data : The backup data contains only the full amount of data. NineData supports the Copy-Only function of SQL Server, you can enable it by checking the checkbox in front of Copy-Only. For more information about this feature, see Microsoft's official documentation.
    Storage targetSelect the storage location of the backup data, according to the location of the data source. NineData provides multiple cloud vendors and multiple regions, and supports Alibaba Cloud , Tencent Cloud , Huawei Cloud , and AWS. For the supported regions, see the console.

  5. On the Objects & Periodic page, configure according to the following table, and click Save and Precheck.

    Parameters
    		Description
    Backup ObjectsThe content that needs to be backed up can be selected and customized.
    • All databases and objects : Backup all databases and objects in this data source.
    • Custom Objects : Manually select the databases and objects to be backed up.
    Backup strategy
    • Time Zone : Select the desired time zone, the system will start the backup according to the time point in the time zone, the default is Beijing time zone.
    • Frequency : Choose how often to back up, any time period from Monday to Sunday, 00:00 to 23:59. if Every day is checked, back up will perform once a day.
    • Preservation Time : The preservation time of backup files (including backup files and log files), which will be automatically deleted after expiration. The options are 7 days, 30 days, 60 days, 90 days, half a year, 1 year, 2 years, and the default is 7 days.

  6. On the Pre-Check page, the system will automatically perform a system check, and the check result will be displayed on the page. If all checks are successful, click Launch.

    tip

    If the check fails, user needs to manually correct the failed items, and then reconfigure the backup task accordingly.

  7. After the Launch tab prompts that Launch Successfully, the data backup service will automatically start the backup according to the backup cycle. User can also click Backup now to make a backup immediately.

    tip

    User can also back up data immediately in the following two ways:

    • On the left navigation bar, click Backup > Backup, and on the Backup page, click Backup in the Actions column on the right side of the task to launch the backup.
    • On the left navigation bar, click Backup > Backup, and click the target Task ID on the Backup page, and click Backup in the upper right corner of the Details page.

  8. On the left navigation bar, click Backup > Backup, and click the target Task ID on the Backup page to view the detailed status of the backup task.

Last updated on