Method: instances.pointInTimeRestore

Point in time restore for an instance managed by Google Cloud Backup and Disaster Recovery.

HTTP request

POST https://sqladmin.googleapis.com/sql/v1beta4/{parent=projects/*}:pointInTimeRestore

The URL uses gRPC Transcoding syntax.

Path parameters

Parameters
parent

string

Required. The parent resource where you created this instance. Format: projects/{project}

Request body

The request body contains an instance of PointInTimeRestoreContext.

Response body

If successful, the response body contains an instance of Operation.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/cloud-platform
  • https://www.googleapis.com/auth/sqlservice.admin

For more information, see the Authentication Overview.

PointInTimeRestoreContext

Context to perform a point-in-time restore of an instance managed by Backup and Disaster Recovery (DR) Service.

JSON representation 
{
  "pointInTime": string,
  "datasource": string,
  "targetInstance": string,
  "privateNetwork": string,
  "allocatedIpRange": string,
  "preferredZone": string,
  "preferredSecondaryZone": string
}
Fields
pointInTime

string (Timestamp format)

Required. The date and time to which you want to restore the instance.

Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z", "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30".
datasource

string

The Backup and Disaster Recovery (DR) Service Datasource URI. Format: projects/{project}/locations/{region}/backupVaults/{backupvault}/dataSources/{datasource}.
targetInstance

string

Target instance name.
privateNetwork

string

Optional. The resource link for the VPC network from which the Cloud SQL instance is accessible for private IP. For example, /projects/myProject/global/networks/default.
allocatedIpRange

string

Optional. The name of the allocated IP range for the internal IP Cloud SQL instance. For example: "google-managed-services-default". If you set this, then Cloud SQL creates the IP address for the cloned instance in the allocated range. This range must comply with RFC 1035 standards. Specifically, the name must be 1-63 characters long and match the regular expression a-z?. Reserved for future use.
preferredZone

string

Optional. Point-in-time recovery of an instance to the specified zone. If no zone is specified, then clone to the same primary zone as the source instance.
preferredSecondaryZone

string

Optional. Point-in-time recovery of a regional instance in the specified zones. If not specified, clone to the same secondary zone as the source instance. This value cannot be the same as the preferredZone field.