getCloudMssqlLogBackupFileList

The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.

Available in VPC

Get the log backup file list of a Cloud DB for MSSQL instance.

Commands

The command statement is as follows.

ncloud vmssql getCloudMssqlLogBackupFileList [regionCode] [cloudMssqlInstanceNo] [databaseName] [backupSetId] [output]

Parameter

The following describes the parameters.

Parameter	Type	Required	Description	Restrictions
regionCode	String	N	Region code regionCode can be obtained through the getRegionList action Default: Select the first Region of the getRegionList query result	-
cloudMssqlInstanceNo	String	Y	Cloud DB for MSSQL instance number to get backup details for cloudMssqlInstanceNo can be obtained through the getCloudMssqlInstanceList action	-
databaseName	String	Y	DB name Check through getCloudMssqlBackupDetailList	-
backupSetId	String	Y	Backup ID Check through getCloudMssqlBackupDetailList	-
output	String	N	Respond result's format type Options: xml \| json Default: json	-

Response

Response data type

CloudMssqlLogBackupFileList type

CloudMssqlLogBackupFileList extends CommonResponse	Description
private Integer totalRows;	Total number of lists searched
private List<cloudMssqlLogBackupFile> CloudMssqlLogBackupFileList = new ArrayList<>();	Cloud DB for MSSQL log backup file list

cloudMssqlLogBackupFile type

cloudMssqlLogBackupFile	Description
private String fileName;	File Name
private String fullFileName;	Full file name
private Date startTime;	Start date and time
private Date endTime;	End date and time
private Long fileSize;	File size

Examples

It describes call and response examples.

Call examples

The following is a call example.

ncloud vmssql getCloudMssqlLogBackupFileList --regionCode KR --cloudMssqlInstanceNo ***890 --databaseName msdb --backupSetId 12

Response example

The following is a sample response.

When response result format type (output) is JSON

The following is an example when the response result format type (output) is JSON.

{
  "getCloudMssqlLogBackupFileListResponse": {
      "totalRows":1,
      "cloudMssqlLogBackupFileList": [
          {
              "fileName": "msdb_20240807_02****.full",
              "fullFileName": "Z:\\cmssql_backup\\user_idx_276****\\cmssql_10-0-2520_m-3***-001\\msdb_20240807_172525.log",
              "startTime": "2024-08-07T17:25:25+0900",
              "endTime": "2024-08-07T17:25:25+0900",
              "fileSize": 620280
          }
      ],
      "requestId": "93697d3d-****-****-****-953e20c67075",
      "returnCode": "0",
      "returnMessage": "success"
  }
}

When response result format type (responseFormatType) is XML

The following is an example when the response result format type (responseFormatType) is XML.

<?xml version="1.0" encoding="UTF-8"?>
<getCloudMssqlLogBackupFileListResponse>
  <requestId>93697d3d-****-****-****-953e20c67075</requestId>
  <returnCode>0</returnCode>
  <returnMessage>success</returnMessage>
  <totalRows>1</totalRows>
  <cloudMssqlLogBackupFileList>
      <CloudMssqlLogBackupFile>
          <fileName>msdb_20240701_02****.full</fileName>
          <fullFileName>Z:\cmssql_backup\user_idx_276****\cmssql_10-0-2520_m-3***-001\msdb_20240807_172525.log</fullFileName>
          <startTime>2024-08-07T17:25:25+0900</startTime>
          <endTime>2024-08-07T17:25:25+0900</endTime>
          <fileSize>620280</fileSize>
      </CloudMssqlLogBackupFile>
  </cloudMssqlLogBackupFileList>
</getCloudMssqlLogBackupFileListResponse>

Documentation Index