Use DescribeLogBackupFiles to query log backup files for SQL Server - ApsaraDB RDS - Alibaba Cloud - ApsaraDB RDS

Operation description

Supported database engines

SQL Server

Note You can call the DescribeBinlogFiles operation to query the log files of instances that run different database engines.

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Debug

Authorization information

The following table shows the authorization information corresponding to the API. The authorization information can be used in the Action policy element to grant a RAM user or RAM role the permissions to call this API operation. Description:

Operation: the value that you can use in the Action element to specify the operation on a resource.
Access level: the access level of each operation. The levels are read, write, and list.
Resource type: the type of the resource on which you can authorize the RAM user or the RAM role to perform the operation. Take note of the following items:
- For mandatory resource types, indicate with a prefix of * .
- If the permissions cannot be granted at the resource level, All Resources is used in the Resource type column of the operation.
Condition Key: the condition key that is defined by the cloud service.
Associated operation: other operations that the RAM user or the RAM role must have permissions to perform to complete the operation. To complete the operation, the RAM user or the RAM role must have the permissions to perform the associated operations.

Operation	Access level	Resource type	Condition key	Associated operation
rds:DescribeLogBackupFiles	get	*DBInstance `acs:rds:{#regionId}:{#accountId}:dbinstance/{#dbinstanceId}`	rds:ResourceTag	none

Request parameters

Parameter	Type	Required	Description	Example
DBInstanceId	string	Yes	The instance ID. You can call the DescribeDBInstances operation to query the instance ID.	rm-uf6wjk5xxxxxxx
StartTime	string	Yes	The beginning of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mmZ format. The time must be in UTC.	2018-10-01T08:40Z
EndTime	string	Yes	The end of the time range to query. The end time must be later than the start time. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mmZ format. The time must be in UTC.	2018-10-31T08:40Z
PageSize	integer	No	The number of entries to return on each page. Valid values: 30 to 1000. Default value: 30.	30
PageNumber	integer	No	The page number. Valid values: any non-zero positive integer. Default value: 1.	1

Response parameters

Parameter	Type	Description	Example
	object	The response parameters.
TotalFileSize	long	The total size of log files. Unit: bytes.	2300
PageNumber	integer	The page number of the page returned.	1
RequestId	string	The request ID.	F8EC669C-FC85-43D7-AF06-C3641626B37E
PageRecordCount	integer	The number of log files on the current page.	100
TotalRecordCount	integer	The total number of log files.	17
Items	array<object>	The details of log files.
BinLogFile	object
LogBeginTime	string	The start time of the log file. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mmZ format. The time is displayed in UTC.	2018-10-31T08:40Z
IntranetDownloadLink	string	The URL that is used to download the log file over an internal network. If the log file cannot be downloaded, an empty string is returned. This URL is valid for one hour.	http://rdsbak-hz-v3.oss-cn-hangzhou.aliyuncs.com/xxxxx
LinkExpiredTime	string	The expiration time of the URL. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.	2019-03-01T15:04:13Z
DownloadLink	string	The HTTP-based download URL of the log file. If the log file cannot be downloaded, an empty string is returned.	http://rdsbak-hz-v3.oss-cn-hangzhou.aliyuncs.com/xxxxx
LogEndTime	string	The end time of the log file. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mmZ format. The time is displayed in UTC.	2018-10-31T08:40Z
FileSize	long	The size of the log file. Unit: bytes.	788480

Examples

Sample success responses

JSONformat

{
  "TotalFileSize": 2300,
  "PageNumber": 1,
  "RequestId": "F8EC669C-FC85-43D7-AF06-C3641626B37E",
  "PageRecordCount": 100,
  "TotalRecordCount": 17,
  "Items": {
    "BinLogFile": [
      {
        "LogBeginTime": "2018-10-31T08:40Z",
        "IntranetDownloadLink": "http://rdsbak-hz-v3.oss-cn-hangzhou.aliyuncs.com/xxxxx",
        "LinkExpiredTime": "2019-03-01T15:04:13Z",
        "DownloadLink": "http://rdsbak-hz-v3.oss-cn-hangzhou.aliyuncs.com/xxxxx",
        "LogEndTime": "2018-10-31T08:40Z",
        "FileSize": 788480
      }
    ]
  }
}

Error codes

HTTP status code	Error code	Error message	Description
400	ParameterLeastAssociate	Must input at least one optional parameter.	The point in time or the data backup file cannot be left unspecified. Specify a point in time or a data backup file and try again.
400	InvalidParameters.Format	Specified parameter is not valid.	-
400	ParameterAbsence	Necessary parameter is absence.	You must pass in the required parameter.
403	IncorrectDBInstanceEngine	Current DB Instance engine does not support this operation.	The operation failed. The operation is not supported for the database engine that is run on the RDS instance.
403	IncorrectDBInstanceCharacterType	Current DB Instance character_type does not support this operation.	This operation is not supported for the character type of the current instance.
403	IncorrectDBInstanceState	Current DB instance state does not support this operation.	-
403	IncorrectDBInstanceLockMode	Current DB instance lock mode does not support this operation.	The operation failed. The RDS instance is locked.
404	InvalidDBInstance.NotFound	Specified instance does not exist or not support.	The RDS instance cannot be found, is deleted, or does not support the operation.

For a list of error codes, visit the Service error codes.

Change history

Change time	Summary of changes	Operation
2024-11-20	API Description Update. The Error code has changed	View Change Details