getCloudMssqlBackupDetailList

VPC 환경에서 이용 가능합니다.

사용 가능한 Cloud DB for MSSQL 백업 상세 정보 목록을 조회합니다.

명령어

명령어 구문은 다음과 같습니다.

ncloud vmssql getCloudMssqlBackupDetailList [regionCode] [cloudMssqlInstanceNo] [pageNo] [pageSize] [output]

파라미터

파라미터에 대한 설명은 다음과 같습니다.

응답

응답 데이터 타입

• CloudMssqlBackupDetailList 타입

  CloudMssqlBackupDetailList extends CommonResponse	설명
  private Integer totalRows;	조회된 목록의 총 개수
  private List<CloudMssqlBackupDetail> cloudMssqlBackupDetailList = new ArrayList<>();	Cloud DB for MSSQL 백업 상세 목록

• CloudMssqlBackupDetail 타입

  CloudMssqlBackupDetail	설명
  private Integer backupSetId;	백업 ID
  private String databaseName;	DB 이름
  private String fileName;	파일 이름
  private String fullFileName;	full 파일 이름
  private Long fullBackupSize;	FullBackup 데이터 사이즈
  private Long logBackupCount;	연관된 Log Backup 수
  private Long logBackupSize;	연관된 Log Backup 데이터 사이즈
  private Date startTime;	백업 시작 일시
  private Date endTime;	백업 종료 일시

예시

호출과 응답 예시를 설명합니다.

호출 예시

호출 예시는 다음과 같습니다.

ncloud vmssql getCloudMssqlBackupDetailList --regionCode KR --cloudMssqlInstanceNo ***890

응답 예시

응답 예시는 다음과 같습니다.

응답 결과 포맷 타입(output)이 json인 경우

응답 결과 포맷 타입(output)이 json인 경우는 다음과 같습니다.

{
  "getCloudMssqlBackupDetailListResponse": {
    "requestId": "f3bda8a3-978a-42d3-b52f-123b096e0f45",
    "returnCode": 0,
    "returnMessage": "success",
    "totalRows": 4,
    "cloudMssqlBackupDetailList": [
      {
        "backupSetId": 12,
        "databaseName": "master",
        "fileName": "sample.txt",
        "fullFileName": "D:\\sample.txt",        
        "fullBackupSize": 780145,
        "logBackupCount": 0,
        "logBackupSize": 0,
        "startTime": "2021-07-12T09:13:57+0900",
        "endTime": "2021-07-12T09:13:57+0900"
      },
      {
        "backupSetId": 13,
        "databaseName": "msdb",
        "fileName": "sample1.txt",
        "fullFileName": "D:\\sample1.txt",        
        "fullBackupSize": 2590649,
        "logBackupCount": 0,
        "logBackupSize": 0,
        "startTime": "2021-07-12T09:13:51+0900",
        "endTime": "2021-07-12T09:13:51+0900"
      },
      {
        "backupSetId": 14,
        "databaseName": "master",
        "fileName": "sample2.txt",
        "fullFileName": "D:\\sample2.txt",        
        "fullBackupSize": 780204,
        "logBackupCount": 0,
        "logBackupSize": 0,
        "startTime": "2021-07-11T09:14:18+0900",
        "endTime": "2021-07-11T09:14:18+0900"
      },
      {
        "backupSetId": 15,
        "databaseName": "msdb",
        "fileName": "sample3.txt",
        "fullFileName": "D:\\sample3.txt",        
        "fullBackupSize": 2589526,
        "logBackupCount": 0,
        "logBackupSize": 0,
        "startTime": "2021-07-11T09:14:12+0900",
        "endTime": "2021-07-11T09:14:13+0900"
      }
    ]
  }
}

응답 결과 포맷 타입(responseFormatType)이 xml인 경우

응답 결과 포맷 타입(responseFormatType)이 xml인 경우는 다음과 같습니다.

<getCloudMssqlBackupDetailListResponse>
    <requestId>f3bda8a3-978a-42d3-b52f-123b096e0f45</requestId>
    <returnCode>0</returnCode>
    <returnMessage>success</returnMessage>
    <totalRows>4</totalRows>
    <cloudMssqlBackupDetailList>
        <CloudMssqlBackupDetail>
            <backupSetId>12</backupSetId>
            <databaseName>master</databaseName>
            <fileName>sample.txt</fileName>
            <fullFileName>D:\\sample.txt</fullFileName>
            <fullBackupSize>780145</fullBackupSize>
            <logBackupCount>0</logBackupCount>
            <logBackupSize>0</logBackupSize>
            <startTime>2021-07-12T09:13:57+0900</startTime>
            <endTime>2021-07-12T09:13:57+0900</endTime>
        </CloudMssqlBackupDetail>
        <CloudMssqlBackupDetail>
            <backupSetId>13</backupSetId>
            <databaseName>msdb</databaseName>
            <fileName>sample1.txt</fileName>
            <fullFileName>D:\\sample1.txt</fullFileName>
            <fullBackupSize>2590649</fullBackupSize>
            <logBackupCount>0</logBackupCount>
            <logBackupSize>0</logBackupSize>
            <startTime>2021-07-12T09:13:51+0900</startTime>
            <endTime>2021-07-12T09:13:51+0900</endTime>
        </CloudMssqlBackupDetail>
        <CloudMssqlBackupDetail>
            <backupSetId>14</backupSetId>
            <databaseName>master</databaseName>
            <fileName>sample2.txt</fileName>
            <fullFileName>D:\\sample2.txt</fullFileName>
            <fullBackupSize>780204</fullBackupSize>
            <logBackupCount>0</logBackupCount>
            <logBackupSize>0</logBackupSize>
            <startTime>2021-07-11T09:14:18+0900</startTime>
            <endTime>2021-07-11T09:14:18+0900</endTime>
        </CloudMssqlBackupDetail>
        <CloudMssqlBackupDetail>
            <backupSetId>15</backupSetId>
            <databaseName>msdb</databaseName>
            <fileName>sample3.txt</fileName>
            <fullFileName>D:\\sample3.txt</fullFileName>
            <fullBackupSize>2589526</fullBackupSize>
            <logBackupCount>0</logBackupCount>
            <logBackupSize>0</logBackupSize>
            <startTime>2021-07-11T09:14:12+0900</startTime>
            <endTime>2021-07-11T09:14:13+0900</endTime>
        </CloudMssqlBackupDetail>
    </cloudMssqlBackupDetailList>
</getCloudMssqlBackupDetailListResponse>