--- title: "createCloudMssqlSlaveInstance" slug: "database-vmssql-createcloudmssqlslaveinstance" updated: 2026-09-17T10:05:51Z published: 2026-09-17T10:05:51Z canonical: "api.ncloud-docs.com/database-vmssql-createcloudmssqlslaveinstance" --- > ## Documentation Index > Fetch the complete documentation index at: https://api.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. ## Request The following describes the request format for the endpoint. The request format is as follows: | Method | URI | | --- | --- | | GET \| POST | /vmssql/v2/createCloudMssqlSlaveInstance | Note This guide is based on the GET method. POST method call tests can be performed through Swagger in the API Gateway service of the NAVER Cloud Platform console. ### Request headers For information about the headers common to all Cloud DB for MSSQL (VPC) APIs, see [Cloud DB for MSSQL (VPC) request headers](/docs/en/database-vmssql#%EC%9A%94%EC%B2%AD%ED%97%A4%EB%8D%94). ### Request query parameters You can use the following query parameters with your request: | Field | Type | Required | Description | | --- | --- | --- | --- | | `regionCode` | String | Optional | Region code of the Cloud DB for MSSQL instance for which you want to create a slave server instance - See [getRegionList](/docs/en/compute-vserver-server-common-getregionlist) - First Region of the `getRegionList` query result (default) | | `cloudMssqlInstanceNo` | String | Required | Cloud DB for MSSQL instance number - See [getCloudMssqlInstanceList](/docs/en/database-vmssql-getcloudmssqlinstancelist) | | `privateDomainPostfix` | String | Required | Private domain postfix of the slave server instance - 001 - 999 - Enter a three-digit number | | `subnetNo` | String | Conditional | Subnet number of the default network interface to be used in the Cloud DB for MSSQL instance - See [getCloudMssqlTargetSubnetList](/docs/en/database-vmssql-getcloudmssqltargetsubnetlist) - Required for multi-zone Cloud DB for MSSQL - For Cloud DB for MSSQL that is not multi-zone, the input of `subnetNo` is not accepted and it is created in the existing `subnetNo` | | `responseFormatType` | String | Optional | Format of the response result - `xml` (default) \| `json` | ### Request example The following is a sample request. ``` curl --location --request GET 'https://ncloud.apigw.ntruss.com/vmssql/v2/createCloudMssqlSlaveInstance ?regionNo=KR &cloudMssqlInstanceNo=2517**** &privateDomainPostfix=002 &subnetNo=139*** &responseFormatType=json' \ --header 'x-ncp-apigw-timestamp: {Timestamp}' \ --header 'x-ncp-iam-access-key: {Access Key}' \ --header 'x-ncp-apigw-signature-v2: {API Gateway Signature}' ``` ## Response The following describes the response format. ### Response body See [CloudMssqlInstanceList](/docs/en/common-vapidatatype-cloudmssqlinstancelist) for the response body. ### Response status codes For information about the HTTP status codes common to all Cloud DB for MSSQL (VPC) APIs, see [Cloud DB for MSSQL (VPC) response status codes](/docs/en/database-vmssql#%EC%9D%91%EB%8B%B5%EC%83%81%ED%83%9C%EC%BD%94%EB%93%9C). ### Response example The following is a sample response. - If `responseFormatType=json` ``` { "createCloudMssqlSlaveInstanceResponse": { "totalRows": 1, "cloudMssqlInstanceList": [ { "cloudMssqlInstanceNo": "2517****", "cloudMssqlServiceName": "mssql002", "cloudMssqlInstanceStatusName": "running", "cloudMssqlInstanceStatus": { "code": "CREAT", "codeName": "CLOUD DATABASE(VPC) Created State" }, "cloudMssqlInstanceOperation": { "code": "NULL", "codeName": "CLOUD DATABASE(VPC) Null OP" }, "cloudMssqlImageProductCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15043553.EE.B100", "isHa": true, "isMultiZone": false, "license": { "code": "SPLA", "codeName": "Service Provider License Agreement" }, "cloudMssqlPort": 1433, "backupFileRetentionPeriod": 1, "backupTime": "02:00", "configGroupNo": "0", "configGroupName": "mssql_2019_default", "engineVersion": "MSSQL 15.0.4355.3 Enterprise Edition", "createDate": "2024-06-25T10:18:57+0900", "dbCollation": "Korean_Wansung_CI_AS", "cloudMssqlServerInstanceList": [ { "cloudMssqlServerInstanceNo": "2517****", "cloudMssqlServerName": "m-2517****-001", "cloudMssqlServerRole": { "code": "M", "codeName": "Principal" }, "cloudMssqlServerInstanceStatusName": "running", "cloudMssqlServerInstanceStatus": { "code": "RUN", "codeName": "CLOUD DATABASE(VPC) Server Running State" }, "cloudMssqlServerInstanceOperation": { "code": "NOOP", "codeName": "CLOUD DATABASE(VPC) Server Null OP" }, "regionCode": "KR", "zoneCode": "KR-1", "vpcNo": "59***", "subnetNo": "140***", "dataStorageSize": 107374182400, "cpuCount": 2, "memorySize": 4294967296, "isPublicSubnet": true, "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002", "privateDomain": "mssql-****.vpc-cdb.ntruss.com", "createDate": "2024-06-25T10:18:57+0900", "uptime": "2024-06-25T10:48:04+0900", "dataStorageType": { "code": "SSD", "codeName": "SSD" }, "usedDataStorageSize": 1073741824 }, { "cloudMssqlServerInstanceNo": "2517****", "cloudMssqlServerName": "m-2517****-002", "cloudMssqlServerRole": { "code": "H", "codeName": "Mirror" }, "cloudMssqlServerInstanceStatusName": "running", "cloudMssqlServerInstanceStatus": { "code": "RUN", "codeName": "CLOUD DATABASE(VPC) Server Running State" }, "cloudMssqlServerInstanceOperation": { "code": "NOOP", "codeName": "CLOUD DATABASE(VPC) Server Null OP" }, "regionCode": "KR", "zoneCode": "KR-1", "vpcNo": "59***", "subnetNo": "140***", "dataStorageSize": 107374182400, "cpuCount": 2, "memorySize": 4294967296, "isPublicSubnet": true, "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002", "privateDomain": "mssql-****.vpc-cdb.ntruss.com", "createDate": "2024-06-25T10:18:57+0900", "uptime": "2024-06-25T11:01:26+0900", "dataStorageType": { "code": "SSD", "codeName": "SSD" }, "usedDataStorageSize": 1073741824 }, { "cloudMssqlServerInstanceNo": "2529****", "cloudMssqlServerName": "m-2517****-005", "cloudMssqlServerRole": { "code": "S", "codeName": "Slave" }, "cloudMssqlServerInstanceStatusName": "running", "cloudMssqlServerInstanceStatus": { "code": "RUN", "codeName": "CLOUD DATABASE(VPC) Server Running State" }, "cloudMssqlServerInstanceOperation": { "code": "NOOP", "codeName": "CLOUD DATABASE(VPC) Server Null OP" }, "regionCode": "KR", "zoneCode": "KR-1", "vpcNo": "59***", "subnetNo": "140***", "dataStorageSize": 107374182400, "cpuCount": 2, "memorySize": 4294967296, "isPublicSubnet": true, "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002", "privateDomain": "mssql-****-r001.vpc-cdb.ntruss.com", "createDate": "2024-07-01T15:50:23+0900", "uptime": "2024-07-01T16:19:57+0900", "dataStorageType": { "code": "SSD", "codeName": "SSD" }, "usedDataStorageSize": 1073741824 }, { "cloudMssqlServerInstanceNo": "2529****", "cloudMssqlServerName": "m-2517****-006", "cloudMssqlServerRole": { "code": "S", "codeName": "Slave" }, "cloudMssqlServerInstanceStatusName": "creating", "cloudMssqlServerInstanceStatus": { "code": "PEND", "codeName": "CLOUD DATABASE(VPC) Server Pending State" }, "cloudMssqlServerInstanceOperation": { "code": "CREAT", "codeName": "CLOUD DATABASE(VPC) Server Create OP" }, "regionCode": "KR", "zoneCode": "KR-1", "vpcNo": "59***", "subnetNo": "140***", "dataStorageSize": 107374182400, "cpuCount": 2, "memorySize": 4294967296, "isPublicSubnet": true, "cloudMssqlProductCode": "SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002", "createDate": "2024-07-01T16:50:01+0900", "uptime": "2024-07-01T17:22:39+0900", "dataStorageType": { "code": "SSD", "codeName": "SSD" } } ], "accessControlGroupNoList": [ "184***" ] } ], "requestId": "ba3feb17-****-****-****-c326f4ca42e1", "returnCode": "0", "returnMessage": "success" } } ``` - If `responseFormatType=xml` (default) ``` ba3feb17-****-****-****-c326f4ca42e1 0 success 1 2517**** mssql002 running CREAT CLOUD DATABASE(VPC) Created State NULL CLOUD DATABASE(VPC) Null OP SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15043553.EE.B100 true false SPLA Service Provider License Agreement 1433 1 02:00 0 mssql_2019_default MSSQL 15.0.4355.3 Enterprise Edition 2024-06-25T10:18:57+0900 Korean_Wansung_CI_AS 2517**** m-2517****-001 M Principal running RUN CLOUD DATABASE(VPC) Server Running State NOOP CLOUD DATABASE(VPC) Server Null OP KR KR-1 59*** 140*** 107374182400 2 4294967296 true SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002 mssql-****.vpc-cdb.ntruss.com 2024-06-25T10:18:57+0900 2024-06-25T10:48:04+0900 SSD SSD 1073741824 2517**** m-2517****-002 H Mirror running RUN CLOUD DATABASE(VPC) Server Running State NOOP CLOUD DATABASE(VPC) Server Null OP KR KR-1 59*** 140*** 107374182400 2 4294967296 true SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002 mssql-****.vpc-cdb.ntruss.com 2024-06-25T10:18:57+0900 2024-06-25T11:01:26+0900 SSD SSD 1073741824 2529**** m-2517****-005 S Slave running RUN CLOUD DATABASE(VPC) Server Running State NOOP CLOUD DATABASE(VPC) Server Null OP KR KR-1 59*** 140*** 107374182400 2 4294967296 true SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002 mssql-****-r001.vpc-cdb.ntruss.com 2024-07-01T15:50:23+0900 2024-07-01T16:19:57+0900 SSD SSD 1073741824 2529**** m-2517****-006 S Slave creating PEND CLOUD DATABASE(VPC) Server Pending State CREAT CLOUD DATABASE(VPC) Server Create OP KR KR-1 59*** 140*** 107374182400 2 4294967296 true SVR.VMSSL.HICPU.C002.M004.NET.HDD.B100.G002 mssql-****-r002.vpc-cdb.ntruss.com 2024-07-01T16:50:01+0900 2024-07-01T17:22:39+0900 SSD SSD 1073741824 184*** ```