Restore backup (limited rollout)
curl --request POST \
--url https://api.example.com/api/v1/databases/{id}/backups/{filename}import requests
url = "https://api.example.com/api/v1/databases/{id}/backups/{filename}"
response = requests.post(url)
print(response.text)const options = {method: 'POST'};
fetch('https://api.example.com/api/v1/databases/{id}/backups/{filename}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.example.com/api/v1/databases/{id}/backups/{filename}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.example.com/api/v1/databases/{id}/backups/{filename}"
req, _ := http.NewRequest("POST", url, nil)
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.example.com/api/v1/databases/{id}/backups/{filename}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.example.com/api/v1/databases/{id}/backups/{filename}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
response = http.request(request)
puts response.read_bodyLimited rollout
Restore backup (limited rollout)
Exact-target restore contract for operator-approved rollouts; not generally available.
POST
/
api
/
v1
/
databases
/
{id}
/
backups
/
{filename}
Restore backup (limited rollout)
curl --request POST \
--url https://api.example.com/api/v1/databases/{id}/backups/{filename}import requests
url = "https://api.example.com/api/v1/databases/{id}/backups/{filename}"
response = requests.post(url)
print(response.text)const options = {method: 'POST'};
fetch('https://api.example.com/api/v1/databases/{id}/backups/{filename}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.example.com/api/v1/databases/{id}/backups/{filename}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.example.com/api/v1/databases/{id}/backups/{filename}"
req, _ := http.NewRequest("POST", url, nil)
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.example.com/api/v1/databases/{id}/backups/{filename}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.example.com/api/v1/databases/{id}/backups/{filename}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
response = http.request(request)
puts response.read_bodyQueues a staged restore from an existing backup. DBHost validates the artifact,
creates and verifies a pre-restore backup, restores into an isolated database,
then performs an operation-bound swap. The previous database is retained in
isolation for 24 hours for operator-controlled rollback.
Poll
Limited availability: this is not a normal customer or published CLI workflow.
Every restore requires an approved per-database rollout binding,
managed-registry/OID match, operation ID and agent capability. Other databases
receive
FEATURE_NOT_AVAILABLE.Path parameters
| Parameter | Type | Description |
|---|---|---|
id | uuid | Database ID |
filename | string | Backup filename (format: YYYYMMDD_HHMMSS.sql.gz) |
Example
curl -X POST \
-H "Authorization: Bearer dbh_your_api_key_here" \
https://dbhost.app/api/v1/databases/550e8400-e29b-41d4-a716-446655440000/backups/20260326_222551.sql.gz
Response
202 Accepted
{
"message": "Staged restore accepted.",
"operation": {
"id": "op_01J...",
"type": "restore",
"status": "queued",
"stage": "pre_restore_backup",
"progress": 0
}
}
GET /api/v1/operations/{id} for validation, staging, swap, health-check,
rollback, and completion status.
Errors
| Status | Code | Description |
|---|---|---|
| 400 | INVALID_BACKUP_FILENAME | Filename doesn’t match the expected YYYYMMDD_HHMMSS.sql.gz format |
| 401 | UNAUTHORIZED | Missing or invalid API key |
| 403 | FORBIDDEN | The caller can view backups but cannot manage them |
| 404 | DATABASE_NOT_FOUND | Database doesn’t exist, isn’t owned by this user, or isn’t in scope for this key |
| 404 | FEATURE_NOT_AVAILABLE | The database has no exact staged-restore rollout binding |
| 404 | BACKUP_NOT_FOUND | Backup file not found |
| 409 | OPERATION_CONFLICT | Another destructive operation is active for the database |
| 503 | AGENT_CAPABILITY_UNAVAILABLE | The staged-restore agent capability is unavailable |
| 500 | AGENT_ERROR | The VPS agent failed to restore the backup |
⌘I