---
title: "Add and manage DB instances"
slug: "backup-db"
updated: 2026-10-08T06:55:20Z
published: 2026-10-08T06:55:20Z
canonical: "guide.ncloud-docs.com/backup-db"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://guide.ncloud-docs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Add and manage DB instances

Available in Classic and VPC

You can add, edit, and delete DB instances.

## Add DB instance

To add DB instances:

              Note

              

- To add DB instances, there must be policies that have not been applied to other DB instances or other works. [Create a new policy](/docs/en/backup-policy#%EC%A0%95%EC%B1%85%EC%83%9D%EC%84%B1) if you haven't created one or if all existing policies are in use.
- You can add a DB instance only when the resource status is in **Created**.

1. In the NAVER Cloud Platform console, navigate to **Menu** > **All Services** > **Storage** > **Backup**.
2. Click the **Resource** menu.
3. From the resource list, click the resource where you want to add a DB instance.
4. Click **[Add DB instance]** for the type of DB instance you want to add.
5. If the Add DB instance popup appears, enter the information as follows on the DB instance type, then click **[Save]**:
  - [MSSQL](/docs/en/backup-db#MSSQL)
  - [MySQL](/docs/en/backup-db#MySQL)
  - [PostgreSQL](/docs/en/backup-db#PostgreSQL)
6. Check the information on the popup, then click **[OK]**.
  - The DB instance displays the status of **Creating**, and after the creation, the status changes to **Created**.

### MSSQL

To add MSSQL DB instances, enter the following information:

              Note

              

The ID and password are only used for adding DB instances.

- **DB instance name**: Enter the server name of SQL Server Manager Studio.
  - The name should start with a letter and be between 3-30 characters, consisting of lowercase letters, numbers, and hyphens (-).
- **Policy**: Select the policy you want to apply for the DB instance.
  - By clicking **[Create policy]**, you can create a new policy.
- **ID**: Enter the server ID to add DB instances.
  - The name should start with a letter and be between 4-16 characters, consisting of lowercase letters, numbers, hyphens (-), and underscores (_).
  - Enter the ID that belongs to Administrator group with the sysadmin permission. Use the Windows authentication mode to access MSSQL servers.
- **Password**: Enter the server password to add DB instances.
- **Data Directory**: Enter the Data route of MSSQL Database Default Location.
- 

              Note

              

- Navigate to **Security** > **Logins** > **Properties** > **Server Roles** on SQL Server Management Studio in order to view whether the sysadmin permission is set. When the **sysadmin** check box is unchecked, click the check box, then click **[OK]**.
- To view **Data Directory**:
  1. Access the SQL server by starting SQL Server Management Studio.
  2. Right-click the server name on **Object Explorer**, then click **Properties**.
  3. When the Server Properties popup appears, click **Database Settings**.
    - Enter the **Data** value of **Database default locations** into **Data Directory**.  

![backup-db_mssql2](https://cdn.document360.io/6998976f-9d95-4df8-b847-d375892b92c2/Images/Documentation/backup-db_mssql2.png?sv=2026-02-06&spr=https&st=2026-10-27T19%3A50%3A23Z&se=2026-10-27T20%3A50%3A23Z&sr=c&sp=r&sig=VgOHkvowbUJy93jzqr4BtymfD%2Bs2vY0MhCH2T1wRGZU%3D)

### MySQL

To add MySQL DB instances, enter the following information:

              Note

              

- To back up a log of MySQL server, activate the binary logging.
- The ID and password are only used for adding DB instances.

- **DB instance name**: Enter the original name that works as the standard for DB instance management.
  - The name should start with a letter and be between 3-30 characters, consisting of lowercase letters, numbers, and hyphens (-).
- **Policy**: Select the policy you want to apply for the DB instance.
  - By clicking **[Create policy]**, you can create a new policy.
- **ID**: Enter the DB account to add DB instances.
  - The name should start with a letter and be between 4-16 characters, consisting of lowercase letters, numbers, hyphens (-), and underscores (_).
  - Enter the account ID with the sys permission.
- **Password**: Enter the password of the DB account to add DB instances.
- **Binary directory**: Enter the path to binary execution file of MySQL.
  - Example: /usr/bin/
- **Log directory**: Enter the path to the binary log file of MySQL.
  - Example: var/lib/mysql
- **Config file**: Enter the path to the file where the MySQL server configuration has been defined.
  - Example: /etc/my.cnf and /etc/mysql/my.cnf
- **Socket file**: Enter the path to the socket file used for the communication between MySQL server and the client when the server OS is Linux.
  - Example: /var/run/mysqld/mysqld.sock
- **Port**: Enter the server access port number when the server OS is Windows.

### PostgreSQL

To add PostgreSQL DB instances, enter the following information:

              Note

              

- To back up the logs of PostgreSQL server, activate the binary logging.
- The ID and password are only used for adding DB instances.

- **DB instance name**: Enter the original name that works as the standard for DB instance management.
  - The name should start with a letter and be between 3-30 characters, consisting of lowercase letters, numbers, and hyphens (-).
- **Policy**: Select the policy you want to apply for the DB instance.
  - By clicking **[Create policy]**, you can create a new policy.
- **ID**: Enter the server ID to add DB instances.
  - The name should start with a letter and be between 4-16 characters, consisting of lowercase letters, numbers, hyphens (-), and underscores (_).
  - When adding PostgreSQL DB instances, enter the postgres account ID with the admin permission.
- **Password**: Enter the server password to add DB instances.
- **Maintenance DB**: Enter postgres.
- **Binary directory**: Enter the path to binary execution file of PostgreSQL.
  - Example: /usr/bin/
- **Library directory**: Enter the path to the library file used by PostgreSQL server.
  - Example: /usr/pgsql-13/lib
- **Archive log directory**: Enter the path to the archive log file created on PostgreSQL.
  - Example: /var/lib/pgsql/13/data/pg_wal
- **Port**: Enter the server access port number.

## Edit DB instance

To edit the information of DB instances:

1. In the NAVER Cloud Platform console, navigate to **Menu** > **All Services** > **Storage** > **Backup**.
2. Navigate to **Backup** > **Resource**.
3. From the resource list, click the resource with the added DB instance where you want to edit the information.
4. Click **[Edit]** of the DB instance where you want to edit the information.
5. Edit the information of the DB instance, then click **[Save]**.

## Delete DB instance

To delete DB instances:

              Caution

              

Once a DB instance is deleted, all the data and records related to the DB instance disappear. As deleted data cannot be recovered, take careful consideration before deleting them.

1. In the NAVER Cloud Platform console, navigate to **Menu** > **All Services** > **Storage** > **Backup**.
2. Navigate to **Resource**.
3. From the resource list, click the resource with the added DB instance you want to delete.
4. Click **[Delete]** of the DB instance you want to delete.
5. Check the DB instance deletion popup. Click the check box, then click **[Delete]**.
  - The DB instance is displayed as **Deleting**, and after the deletion is completed, the information of the DB instance disappears from the agent list.