Manage retained backups

MySQL | PostgreSQL | SQL Server

This page describes how to enable, disable, and manage retained backups for your Cloud SQL instances.

Retained backups are backups that are retained after an instance is deleted. These backups include on-demand and automated backups that are created when an instance was live. For more information on how retained backups work, see Retained backups .

You can enable retained backups at any time for an instance by editing the instance . You can also restore a retained backup to a new or existing instance .

Before you begin

To manage retained backups in a Google Cloud project, you need the following permissions:

Task	Required permissions
List backups	`cloudsql.backupRuns.list`
Describe a backup	`cloudsql.backupRuns.get`
Update a backup	`cloudsql.backupRuns.update`
Delete a backup	`cloudsql.backupRuns.delete`

gcloud CLI

To manage retained backups in a Google Cloud project, you need the following permissions:

Action	Command	Required permissions
List backups	`gcloud sql backups list`	`cloudsql.backupRuns.list`
Describe a backup	`gcloud sql backups describe`	`cloudsql.backupRuns.get`
Update a backup	`gcloud sql backups patch`	`cloudsql.backupRuns.update`
Delete a backup	`gcloud sql backups delete`	`cloudsql.backupRuns.delete`

REST

To manage retained backups in a Google Cloud project, you need the following permissions:

Action	Method	Required permissions
List backups	`backups.listBackup`	`cloudsql.backupRuns.list`
Describe a backup	`backups.getBackup`	`cloudsql.backupRuns.get`
Update a backup	`backups.updateBackup`	`cloudsql.backupRuns.update`
Delete a backup	`backups.deleteBackup`	`cloudsql.backupRuns.delete`

Enable retained backups for an instance

You can enable retained backups in the Data Protectionconfiguration options for an instance when you create an instance or when you edit an existing instance .

View a list of all retained backups

You can see a list of all retained backups for your Google Cloud project using Google Cloud console, gcloud CLI , or the Cloud SQL API. Backups will include details such as the name of the backup, the instance it belongs to, the type of backup, and the time the instance was deleted. Since the name of a deleted instance can be reused, we recommend using the instance deletion time field to differentiate which instance a particular backup belongs to. For a live instance, this field is blank.

Console

In the Google Cloud console, go to the Cloud SQL Backups page.

Go to Cloud SQL Backups
Click the name of the deleted instance you want to view backups for.

You will see a list of all retained and final backups, and their details for the deleted instance.

gcloud

To get a list of all backups that are associated with a Google Cloud project, use the gcloud sql backups list command:
```
 gcloud sql backups list
--project= PROJECT_ID 
 
```
Replace the following:
- PROJECT_ID : the ID of your Google Cloud project.
To view details about a specific retained backup, use the gcloud sql backups describe command:
```
 gcloud sql backups describe BACKUP_NAME 
--project= PROJECT_ID 
 
```
Replace the following:
- BACKUP_NAME : the name of your retained backup.
- PROJECT_ID : the ID of your Google Cloud project.

REST v1

Get a list of all retained backs

Use this example to get a list of all retained backups associated with a Google Cloud project. For a complete list of parameters for this call, see the backups.listBackups page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID

HTTP method and URL:

GET https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Note: The following command assumes that you have logged in to the gcloud CLI with your user account by running gcloud init or gcloud auth login , or by using Cloud Shell , which automatically logs you into the gcloud CLI . You can check the currently active account by running gcloud auth list .

Execute the following command:

curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups"

PowerShell (Windows)

Note: The following command assumes that you have logged in to the gcloud CLI with your user account by running gcloud init or gcloud auth login . You can check the currently active account by running gcloud auth list .

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "name": "projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "kind": "sql#backup",
      "state": "SUCCESSFUL",
      "backupInterval": {
            "startTime": "2020-01-21T11:25:33.858Z",
            "endTime": "2020-01-21T11:26:18.663Z",
       }
      "type": "FINAL",
      "instance": " INSTANCE_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "location": "us"
      "description": "This is a final backup.",
      "backupKind": "SNAPSHOT",
      "dataDiskSizeGB": "10",
      "expiryTime": "2020-01-30T11:26:18.663Z",
      "backup_run": "projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
/backupRuns/ BACKUP_RUN_ID 
",
      "satisfies_pzs": false,
      "satisfies_pzi": false
}

View details for a retained backup

Use this example to view the details of a retained backup. For a complete list of parameters for this call, see the backup.getBackup page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID.
BACKUP_ID : the backup ID. You obtain this ID from the output of running the previous call.

HTTP method and URL:

GET https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
"

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "name": "projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "kind": "sql#backup",
      "status": "SUCCESSFUL",
      "backupInterval": {
            "startTime": "2020-01-21T11:25:33.858Z",
            "endTime": "2020-01-21T11:26:18.663Z",
         }
      "type": "FINAL",
      "instance": " INSTANCE_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "location": "us"
      "description": "final backup",
      "backupKind": "SNAPSHOT",
      "dataDiskSizeGB": "10",
      "expiryTime": "2020-01-30T11:26:18.663Z",
      "backup_run": "projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
/backupRuns/ BACKUP_RUN_ID 
",
      "satisfies_pzs": false,
      "satisfies_pzi": false
    }

REST v1beta4

Get a list of all retained backs

Use this example to get a list of all retained backups associated with a Google Cloud project. For a complete list of parameters for this call, see the backups.listBackups page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID

HTTP method and URL:

GET https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups"

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "name": "projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "kind": "sql#backup",
      "state": "SUCCESSFUL",
      "backupInterval": {
            "startTime": "2020-01-21T11:25:33.858Z",
            "endTime": "2020-01-21T11:26:18.663Z",
       }
      "type": "FINAL",
      "instance": " INSTANCE_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "location": "us"
      "description": "This is a final backup.",
      "backupKind": "SNAPSHOT",
      "dataDiskSizeGB": "10",
      "expiryTime": "2020-01-30T11:26:18.663Z",
      "backup_run": "projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
/backupRuns/ BACKUP_RUN_ID 
",
      "satisfies_pzs": false,
      "satisfies_pzi": false
}

View details for a retained backup

Use this example to view the details of a retained backup. For a complete list of parameters for this call, see the backups.getBackup page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID.
BACKUP_ID : the backup ID. You obtain this ID from the output of running the previous call.

HTTP method and URL:

GET https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
"

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "name": "projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "kind": "sql#backup",
      "status": "SUCCESSFUL",
      "backupInterval": {
            "startTime": "2020-01-21T11:25:33.858Z",
            "endTime": "2020-01-21T11:26:18.663Z",
         }
      "type": "FINAL",
      "instance": " INSTANCE_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "location": "us"
      "description": "final backup",
      "backupKind": "SNAPSHOT",
      "dataDiskSizeGB": "10",
      "expiryTime": "2020-01-30T11:26:18.663Z",
      "backup_run": "projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
/backupRuns/ BACKUP_RUN_ID 
",
      "satisfies_pzs": false,
      "satisfies_pzi": false
    }

Update the description of a retained backup

You can update the description of a retained backup at any time to make it easier to identify your backups.

Console

In the Google Cloud console, go to the Cloud SQL Backups page.

Go to Cloud SQL Backups
Click the name of the deleted instance you want to view backups for.

You will see a list of all retained and final backups, and their details for the deleted instance.
For the retained backup you want to update, click more actions, and then select Edit description.
In the Edit Backup Descriptionwindow, update the description for your backup.
Click Update.

gcloud

To update the description of your retained backup, use the gcloud sql backups patch command:

 gcloud sql backups patch BACKUP_NAME 
--description= BACKUP_DESCRIPTION

Replace the following:

BACKUP_NAME : the name of your retained backup.
BACKUP_DESCRIPTION : the new description you want to add to your retained backup.

REST v1

Get a list of all retained backs

Use this example to get a list of all retained backups associated with a Google Cloud project. For a complete list of parameters for this call, see the backups.listBackups page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID

HTTP method and URL:

GET https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups"

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "name": "projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "kind": "sql#backup",
      "state": "SUCCESSFUL",
      "backupInterval": {
            "startTime": "2020-01-21T11:25:33.858Z",
            "endTime": "2020-01-21T11:26:18.663Z",
       }
      "type": "FINAL",
      "instance": " INSTANCE_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "location": "us"
      "description": "This is a final backup.",
      "backupKind": "SNAPSHOT",
      "dataDiskSizeGB": "10",
      "expiryTime": "2020-01-30T11:26:18.663Z",
      "backup_run": "projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
/backupRuns/ BACKUP_RUN_ID 
",
      "satisfies_pzs": false,
      "satisfies_pzi": false
}

Update the description

Use this example to update the description of the retained backup. For a complete list of parameters for this call, see the backups.updateBackup page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID.
BACKUP_ID : the backup ID. You obtain this ID from the output of running the previous call.
DESCRIPTION : the updated description for the final backup.

HTTP method and URL:

PATCH https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
?update_mask=description

Request JSON body:

{
        "backup": {
            "description": DESCRIPTION 
,
         },
}

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Save the request body in a file named request.json , and execute the following command:

curl -X PATCH \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json; charset=utf-8" \
-d @request.json \
"https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
?update_mask=description"

PowerShell (Windows)

Save the request body in a file named request.json , and execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method PATCH `
-Headers $headers `
-ContentType: "application/json; charset=utf-8" `
-InFile request.json `
-Uri "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
?update_mask=description" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "kind": "sql#operation",
      "targetLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "status": "DONE",
      "user": "user@example.com",
      "insertTime": "2024-02-15T00:10:22.078Z",
      "operationType": "UPDATE_BACKUP",
      "name": " OPERATION_ID 
",
      "targetId": " BACKUP_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/operations/ OPERATION_ID 
",
      "targetProject": " PROJECT_ID 
"
}

REST v1beta4

Get a list of all retained backs

Use this example to get a list of all retained backups associated with a Google Cloud project. For a complete list of parameters for this call, see the backups.listBackups page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID

HTTP method and URL:

GET https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups"

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "name": "projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "kind": "sql#backup",
      "state": "SUCCESSFUL",
      "backupInterval": {
            "startTime": "2020-01-21T11:25:33.858Z",
            "endTime": "2020-01-21T11:26:18.663Z",
       }
      "type": "FINAL",
      "instance": " INSTANCE_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "location": "us"
      "description": "This is a final backup.",
      "backupKind": "SNAPSHOT",
      "dataDiskSizeGB": "10",
      "expiryTime": "2020-01-30T11:26:18.663Z",
      "backup_run": "projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
/backupRuns/ BACKUP_RUN_ID 
",
      "satisfies_pzs": false,
      "satisfies_pzi": false
}

Update the description

Use this example to update the description of the retained backup. For a complete list of parameters for this call, see the backups.updateBackup page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID.
BACKUP_ID : the backup ID. You obtain this ID from the output of running the previous call.
DESCRIPTION : the updated description for the final backup.

HTTP method and URL:

PATCH https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
?update_mask=description

Request JSON body:

{
        "backup": {
            "description": DESCRIPTION 
,
         },
}

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Save the request body in a file named request.json , and execute the following command:

curl -X PATCH \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json; charset=utf-8" \
-d @request.json \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
?update_mask=description"

PowerShell (Windows)

Save the request body in a file named request.json , and execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method PATCH `
-Headers $headers `
-ContentType: "application/json; charset=utf-8" `
-InFile request.json `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
?update_mask=description" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "kind": "sql#operation",
      "targetLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "status": "DONE",
      "user": "user@example.com",
      "insertTime": "2024-02-15T00:10:22.078Z",
      "operationType": "UPDATE_BACKUP",
      "name": " OPERATION_ID 
",
      "targetId": " BACKUP_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/operations/ OPERATION_ID 
",
      "targetProject": " PROJECT_ID 
"
}

Delete a retained backup

You can delete a retained backup using the Google Cloud console, gcloud CLI , or the Cloud SQL API.

Console

In the Google Cloud console, go to the Cloud SQL Backups page.

Go to Cloud SQL Backups
Click the name of the deleted instance you want to view backups for.

You will see a list of all retained and final backups, and their details for the deleted instance.
For the retained backup you want to delete, click more actions, and then select Delete.
In the Delete backupwindow, enter the name of deleted instance, and then click Delete.

gcloud

To delete a retained backup, use the gcloud sql backups delete command:

 gcloud sql backups delete BACKUP_NAME

Replace the following:

BACKUP_NAME : the name of your retained backup.

REST v1

Get a list of all retained backs

Use this example to get a list of all retained backups associated with a Google Cloud project. For a complete list of parameters for this call, see the backups.listBackups page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID

HTTP method and URL:

GET https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups"

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "name": "projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "kind": "sql#backup",
      "state": "SUCCESSFUL",
      "backupInterval": {
            "startTime": "2020-01-21T11:25:33.858Z",
            "endTime": "2020-01-21T11:26:18.663Z",
       }
      "type": "FINAL",
      "instance": " INSTANCE_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "location": "us"
      "description": "This is a final backup.",
      "backupKind": "SNAPSHOT",
      "dataDiskSizeGB": "10",
      "expiryTime": "2020-01-30T11:26:18.663Z",
      "backup_run": "projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
/backupRuns/ BACKUP_RUN_ID 
",
      "satisfies_pzs": false,
      "satisfies_pzi": false
}

Delete a retained backup

Use this example to delete a retained backup. For a complete list of parameters for this call, see the backups.deleteBackup page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID.
BACKUP_ID : the backup ID. You obtain this ID from the output of running the previous call.

HTTP method and URL:

DELETE https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

curl -X DELETE \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
"

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method DELETE `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
  "kind": "sql#operation",
  "targetLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
  "status": "PENDING",
  "user": "user@example.com",
  "insertTime": "2020-01-21T22:43:37.981Z",
  "operationType": "DELETE_BACKUP",
  "name": " OPERATION_ID 
",
  "targetId": " BACKUP_ID 
",
  "selfLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/operations/ OPERATION_ID 
",
  "targetProject": " PROJECT_ID 
"
}

REST v1beta4

Get a list of all retained backs

Use this example to get a list of all retained backups associated with a Google Cloud project. For a complete list of parameters for this call, see the backups.listBackups page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID

HTTP method and URL:

GET https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups"

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method GET `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
      "name": "projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "kind": "sql#backup",
      "state": "SUCCESSFUL",
      "backupInterval": {
            "startTime": "2020-01-21T11:25:33.858Z",
            "endTime": "2020-01-21T11:26:18.663Z",
       }
      "type": "FINAL",
      "instance": " INSTANCE_ID 
",
      "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
      "location": "us"
      "description": "This is a final backup.",
      "backupKind": "SNAPSHOT",
      "dataDiskSizeGB": "10",
      "expiryTime": "2020-01-30T11:26:18.663Z",
      "backup_run": "projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
/backupRuns/ BACKUP_RUN_ID 
",
      "satisfies_pzs": false,
      "satisfies_pzi": false
}

Delete a retained backup

Use this example to delete a retained backup. For a complete list of parameters for this call, see the backups.deleteBackup page.

Before using any of the request data, make the following replacements:

PROJECT_ID : the project ID.
BACKUP_ID : the backup ID. You obtain this ID from the output of running the previous call.

HTTP method and URL:

DELETE https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command:

curl -X DELETE \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
"https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
"

PowerShell (Windows)

Execute the following command:

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method DELETE `
-Headers $headers `
-Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
  "kind": "sql#operation",
  "targetLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/backups/ BACKUP_ID 
",
  "status": "PENDING",
  "user": "user@example.com",
  "insertTime": "2020-01-21T22:43:37.981Z",
  "operationType": "DELETE_BACKUP",
  "name": " OPERATION_ID 
",
  "targetId": " BACKUP_ID 
",
  "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/ PROJECT_ID 
/operations/ OPERATION_ID 
",
  "targetProject": " PROJECT_ID 
"
}

Manage retained backups Stay organized with collections Save and categorize content based on your preferences.

Before you begin

gcloud CLI

REST

Enable retained backups for an instance

View a list of all retained backups

Console

gcloud

REST v1

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

REST v1beta4

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

Update the description of a retained backup

Console

gcloud

REST v1

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

REST v1beta4

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

Delete a retained backup

Console

gcloud

REST v1

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

REST v1beta4

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

curl (Linux, macOS, or Cloud Shell)

PowerShell (Windows)

Response

What's next

Manage retained backups