getCloudMssqlBackupDetailList
    • PDF

    getCloudMssqlBackupDetailList

    • PDF

    기사 요약

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

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

    명령어

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

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

    파라미터

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

    파라미터타입필수 여부설명제약사항
    regionCodeStringN리전 코드
    - regionCode는 getRegionList 액션을 통해서 획득
    - default: getRegionList 조회 결과의 첫 번째 리전을 선택
    cloudMssqlInstanceNoStringY백업 상세 정보를 조회할 Cloud DB for MSSQL 인스턴스 번호
    - cloudMssqlInstanceNo는 getCloudMssqlInstanceList 액션을 통해서 획득
    -
    pageNoIntegerN페이징 된 결과의 페이지 번호
    - 결괏값을 pageNo, pageSize를 이용하여 페이징 처리 가능
    - Min: 0
    pageSizeIntegerN페이징 시 보여줄 각 페이지 사이즈
    - 결괏값을 pageNo, pageSize를 이용하여 페이징 처리 가능
    - pageNo 입력시 반드시 입력
    - Min: 1
    outputStringN응답 결과의 포맷 타입
    - options: xml | json
    - default: json
    -

    응답

    응답 데이터 타입

    • 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일 때

    {
      "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일 때

    <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>
    

    이 문서가 도움이 되었습니까?

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.