REST Resource: backupRuns

Resource: BackupRun

A BackupRun resource.

JSON representation
{"kind": string,"status": enum (SqlBackupRunStatus),"enqueuedTime": string,"id": string,"startTime": string,"endTime": string,"error": {object (OperationError)},"type": enum (SqlBackupRunType),"description": string,"windowStartTime": string,"instance": string,"selfLink": string,"location": string,"diskEncryptionConfiguration": {object (DiskEncryptionConfiguration)},"diskEncryptionStatus": {object (DiskEncryptionStatus)},"backupKind": enum (SqlBackupKind),"timeZone": string,"maxChargeableBytes": string}
Fields
kind

string

This is always sql#backupRun.

status

enum (SqlBackupRunStatus)

The status of this run.

enqueuedTime

string (Timestamp format)

The time the run was enqueued in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

id

string (int64 format)

The identifier for this backup run. Unique only for a specific Cloud SQL instance.

startTime

string (Timestamp format)

The time the backup operation actually started in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

endTime

string (Timestamp format)

The time the backup operation completed in UTC timezone in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

error

object (OperationError)

Information about why the backup operation failed. This is only present if the run has the FAILED status.

type

enum (SqlBackupRunType)

The type of this run; can be either "AUTOMATED" or "ON_DEMAND" or "FINAL". This field defaults to "ON_DEMAND" and is ignored, when specified for insert requests.

description

string

The description of this run, only applicable to on-demand backups.

windowStartTime

string (Timestamp format)

The start time of the backup window during which this the backup was attempted in RFC 3339 format, for example 2012-11-15T16:19:00.094Z.

A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: "2014-10-02T15:01:23Z" and "2014-10-02T15:01:23.045123456Z".

instance

string

Name of the database instance.

location

string

Location of the backups.

diskEncryptionConfiguration

object (DiskEncryptionConfiguration)

Encryption configuration specific to a backup.

diskEncryptionStatus

object (DiskEncryptionStatus)

Encryption status specific to a backup.

backupKind

enum (SqlBackupKind)

Specifies the kind of backup, PHYSICAL or DEFAULT_SNAPSHOT.

timeZone

string

Backup time zone to prevent restores to an instance with a different time zone. Now relevant only for SQL Server.

maxChargeableBytes

string (int64 format)

Output only. The maximum chargeable bytes for the backup.

SqlBackupRunStatus

The status of a backup run.

Enums
SQL_BACKUP_RUN_STATUS_UNSPECIFIEDThe status of the run is unknown.
ENQUEUEDThe backup operation was enqueued.
OVERDUEThe backup is overdue across a given backup window. Indicates a problem. Example: Long-running operation in progress during the whole window.
RUNNINGThe backup is in progress.
FAILEDThe backup failed.
SUCCESSFULThe backup was successful.
SKIPPEDThe backup was skipped (without problems) for a given backup window. Example: Instance was idle.
DELETION_PENDINGThe backup is about to be deleted.
DELETION_FAILEDThe backup deletion failed.
DELETEDThe backup has been deleted.

SqlBackupRunType

Type of backup (i.e. automated, on demand, etc).

Enums
SQL_BACKUP_RUN_TYPE_UNSPECIFIEDThis is an unknown BackupRun type.
AUTOMATEDThe backup schedule automatically triggers a backup.
ON_DEMANDThe user manually triggers a backup.

SqlBackupKind

Defines the supported backup kinds.

Enums
SQL_BACKUP_KIND_UNSPECIFIEDThis is an unknown BackupKind.
SNAPSHOTThe snapshot based backups
PHYSICALPhysical backups

Methods

delete

Deletes the backup taken by a backup run.

get

Retrieves a resource containing information about a backup run.

insert

Creates a new backup run on demand.

list

Lists all backup runs associated with the project or a given instance and configuration in the reverse chronological order of the backup initiation time.