Skip to main content

Perform Physical Backup

NineData physical backup backs up database files for self-managed SQL Server data sources. Use it to create full backups or data-plus-log backups through a gateway connection.

Prerequisites​

  • 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 Gateway connection method. For more information, see Add Data Source.

    tip

    The gateway must be deployed on the host where the self-managed instance to be backed up is located.

Procedure​

  1. Log in to the NineData Console.

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

  3. On the Backup page, click Create Backup.

  4. On the Sources & Target tab, configure the parameters in the table, and click Next.

    Parameters
    		Description
    NameEnter a name for the backup task. Use a meaningful name so you can find and manage the task later. The name can contain up to 64 characters.
    DatasourceSelect the data source to back up. If the data source was added recently, click Refresh to load the latest data source list.
    Backup method (SQL Server only)Select Physical Backup.
    • Logical Backup: Backs up database objects such as tables and indexes. Logical backup supports full backup, incremental backup, schema backup, and other backup types.
    • Physical Backup: Backs up the database files.
    GatewayPhysical backup reads files directly from the data source, so a gateway must be configured. If the data source was added through a gateway, this parameter is configured automatically. 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 more information, see Add Data Source.
    Backup typeSelect one of the supported backup types:
    • Data + Log: Backs up full data and incremental data.
    • Data: Backs up full data only. NineData supports SQL Server Copy-Only backup. To enable it, select the Copy-Only checkbox. For more information, see Microsoft documentation.
    Storage targetSelect the storage location for backup data based on the data source location. NineData provides multiple cloud vendors and regions, including Alibaba Cloud, Tencent Cloud, Huawei Cloud, and AWS. For supported regions, see the console.

  5. On the Objects & Periodic page, configure the parameters in the table, and click Save and Precheck.

    Parameters
    		Description
    Backup ObjectsSelect the objects to back up.
    • All databases and objects: Back up all databases and objects in the data source.
    • Custom Objects: Manually select the databases and objects to back up.
    Backup strategy
    • Time Zone: Select the time zone for the backup schedule. The default is Beijing time.
    • Frequency: Select how often the backup runs. You can choose any time range from Monday to Sunday, 00:00 to 23:59. If Every day is selected, the backup runs once per day.
    • Preservation Time: Select how long backup files and log files are retained before they are automatically deleted. Options include 7 days, 30 days, 60 days, 90 days, half a year, 1 year, and 2 years. The default is 7 days.

  6. On the Pre-Check page, NineData automatically checks the task configuration. If all checks pass, click Launch.

    tip

    If a check fails, review and fix the failed item, and then configure the backup task again as needed.

  7. After the Launch Successfully message appears on the Launch tab, NineData starts the backup based on the configured schedule. To run a backup immediately, click Backup now.

    tip

    You can also start an immediate backup in either of these ways:

  • In the navigation pane, click Backup > Backup. On the Backup page, click Backup in the Actions column for the target task.

  • In the navigation pane, click Backup > Backup. On the Backup page, click the target task ID, and then click Backup on the Details page.

    :::

  1. In the navigation pane, click Backup > Backup, and then click the target Task ID to view the backup task details.

Result​

The physical backup task is created and runs based on the configured schedule. You can monitor task status from the backup task details page or run an immediate backup when needed.