---
title: "createCloudMssqlSlaveInstance"
slug: "cli-vmssql-createcloudmssqlslaveinstance"
updated: 2026-09-17T10:08:42Z
published: 2026-09-17T10:08:42Z
canonical: "cli.ncloud-docs.com/cli-vmssql-createcloudmssqlslaveinstance"
---

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

# createCloudMssqlSlaveInstance

Available in VPC

Add a slave server instance to a Cloud DB for MSSQL instance.

## Syntax

The `createCloudMssqlSlaveInstance` syntax is as follows:

```
./ncloud vmssql createCloudMssqlSlaveInstance \
    --cloudMssqlInstanceNo <instance-no> \
    --privateDomainPostfix <private-domain-postfix> \
    [--subnetNo <subnet-no>] \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]
```

## Options

This section describes the options available when running `createCloudMssqlSlaveInstance`.

### Required options

The following options are required for `createCloudMssqlSlaveInstance`.

| Options | Type | Required | Description |
| --- | --- | --- | --- |
| `--cloudMssqlInstanceNo` | String | Required | Cloud DB for MSSQL instance number - See [getCloudMssqlInstanceList](/docs/en/cli-vmssql-getcloudmssqlinstancelist). |
| `--privateDomainPostfix` | String | Required | Private domain postfix of the slave server instance - Enter a three-digit number in the range of `001`-`999`. |
| `--subnetNo` | String | Conditional | Subnet number of the default network interface to be used in the Cloud DB for MSSQL instance - Required for multi-zone Cloud DB for MSSQL. - If not multi-zone, the input of `subnetNo` is not accepted and it is created in the existing subnet. - See [getCloudMssqlTargetSubnetList](/docs/en/cli-vmssql-getcloudmssqltargetsubnetlist). |

### Common options

For information about the options common to all `vmssql` subcommands, see [Cloud DB for MSSQL (VPC) options](/docs/en/cli-vmssql#%EC%98%B5%EC%85%98).

## Examples

If the request to add a slave server instance is successful, the server configuration of the Cloud DB for MSSQL instance and the creation status of the added slave server are returned.

### Command

The command example is as follows:

```
./ncloud vmssql createCloudMssqlSlaveInstance \
    --cloudMssqlInstanceNo 25280088 \
    --privateDomainPostfix 003 \
    --regionCode KR \
    --output json
```

### Output

The output example is as follows:

```
{
  "createCloudMssqlSlaveInstanceResponse": {
    "totalRows": 1,
    "cloudMssqlInstanceList": [
      {
        "cloudMssqlInstanceNo": "25280088",
        "cloudMssqlServiceName": "test-mssql-01",
        "cloudMssqlInstanceStatusName": "running",
        "cloudMssqlInstanceStatus": {
          "code": "CREAT",
          "codeName": "CLOUD DATABASE (VPC) Created status"
        },
        "cloudMssqlInstanceOperation": {
          "code": "NULL",
          "codeName": "CLOUD DATABASE(VPC) Null OP"
        },
        "generationCode": "G2",
        "cloudMssqlImageProductCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15044401.SE.B100",
        "isHa": true,
        "isMultiZone": false,
        "license": {
          "code": "SPLA",
          "codeName": "License code - CLOUD DATABASE (VPC)"
        },
        "cloudMssqlPort": 1433,
        "backupFileRetentionPeriod": 1,
        "backupTime": "09:00",
        "configGroupNo": "0",
        "configGroupName": "mssql_2019_default",
        "engineVersion": "MSSQL 15.0.4440.1 Standard Edition",
        "createDate": "2026-06-09T19:47:07+0900",
        "dbCollation": "Korean_Wansung_CI_AS",
        "cloudMssqlServerInstanceList": [
          {
            "cloudMssqlServerInstanceNo": "25280089",
            "cloudMssqlServerName": "m-25280088-001",
            "cloudMssqlServerRole": {
              "code": "M",
              "codeName": "Principal"
            },
            "cloudMssqlServerInstanceStatusName": "running",
            "cloudMssqlServerInstanceStatus": {
              "code": "RUN",
              "codeName": "CLOUD DATABASE (VPC) server Running status"
            },
            "cloudMssqlServerInstanceOperation": {
              "code": "NOOP",
              "codeName": "CLOUD DATABASE (VPC) server null OP"
            },
            "regionCode": "KR",
            "zoneCode": "KR-1",
            "vpcNo": "12345678",
            "subnetNo": "23456789",
            "dataStorageSize": 107374182400,
            "cpuCount": 2,
            "memorySize": 4294967296,
            "isPublicSubnet": false,
            "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002",
            "privateDomain": "mssql-1a2b3c.vpc-cdb.ntruss.com",
            "createDate": "2026-06-09T19:47:07+0900",
            "uptime": "2026-06-09T20:16:13+0900",
            "dataStorageType": {
              "code": "SSD",
              "codeName": "SSD"
            },
            "usedDataStorageSize": 1073741824
          },
          {
            "cloudMssqlServerInstanceNo": "25280090",
            "cloudMssqlServerName": "m-25280088-002",
            "cloudMssqlServerRole": {
              "code": "H",
              "codeName": "Mirror"
            },
            "cloudMssqlServerInstanceStatusName": "running",
            "cloudMssqlServerInstanceStatus": {
              "code": "RUN",
              "codeName": "CLOUD DATABASE (VPC) server Running status"
            },
            "cloudMssqlServerInstanceOperation": {
              "code": "NOOP",
              "codeName": "CLOUD DATABASE (VPC) server null OP"
            },
            "regionCode": "KR",
            "zoneCode": "KR-1",
            "vpcNo": "12345678",
            "subnetNo": "23456789",
            "dataStorageSize": 107374182400,
            "cpuCount": 2,
            "memorySize": 4294967296,
            "isPublicSubnet": false,
            "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002",
            "privateDomain": "mssql-1a2b3c.vpc-cdb.ntruss.com",
            "createDate": "2026-06-09T19:47:07+0900",
            "uptime": "2026-06-09T20:26:04+0900",
            "dataStorageType": {
              "code": "SSD",
              "codeName": "SSD"
            }
          },
          {
            "cloudMssqlServerName": "m-25280088-003",
            "cloudMssqlServerRole": {
              "code": "S",
              "codeName": "Slave"
            },
            "cloudMssqlServerInstanceStatusName": "creating",
            "cloudMssqlServerInstanceStatus": {
              "code": "PEND",
              "codeName": "CLOUD DATABASE (VPC) server Pending status"
            },
            "cloudMssqlServerInstanceOperation": {
              "code": "CREAT",
              "codeName": "CLOUD DATABASE (VPC) server Create OP"
            },
            "regionCode": "KR",
            "zoneCode": "KR-1",
            "vpcNo": "12345678",
            "subnetNo": "23456789",
            "dataStorageSize": 107374182400,
            "cpuCount": 2,
            "memorySize": 4294967296,
            "isPublicSubnet": false,
            "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002",
            "createDate": "2026-06-09T20:29:20+0900",
            "dataStorageType": {
              "code": "SSD",
              "codeName": "SSD"
            }
          }
        ],
        "accessControlGroupNoList": [
          "67890123"
        ]
      }
    ],
    "requestId": "d4e5f6a7-b8c9-0123-defa-456789012345",
    "returnCode": "0",
    "returnMessage": "success"
  }
}
```