---
title: "Get backup set details"
method: GET
path: "/sqlserver/v2/orgs/{orgID}/backupsets/{backupsetID}"
tags: ["SQLServer"]
---

# Get backup set details

`GET /sqlserver/v2/orgs/{orgID}/backupsets/{backupsetID}`

Returns details of the specified backup set.

## Path parameters

- `orgID` integer, required
- `backupsetID` integer, required

## Response `200`

Success

- SQLGetBackupsetDetailsResponse — GetBackupsetDetailsResponse is the response schema for GetBackupsetDetails API
  - `backupsetID` integer — The ID of the backup set.
  - `backupsetName` string — The name of the backup set.
  - `configuredDatabases` SQLConfiguredDatabases[]
    - `createdAt` string — The creation date and time of the database.
    - `databaseName` string — The name of the database.
    - `isReadOnlyMode` boolean — The value is set to TRUE if the database is in Read-Only mode, else it is set to FALSE.
  - `contentRuleID` integer
  - `disableTimeStamp` integer — The date and time when the backup set was disabled.
  - `policyID` integer — The ID of the backup policy associated with the backup set.
  - `storageCsetID` integer — The ID of the storage cset associated with the backup set.
  - `storageID` integer — The ID of the storage associated with the backup set.

## Other responses

- `400` — Bad Request
- `401` — The request did not include an authentication token or the authentication token was expired.
- `403` — Forbidden
- `404` — The requested resource was not found.
- `500` — The request was not processed due to an internal error in Cloud.

---

[API](https://skmtc.dev/druva/apis/authentication.md) · [All operations](https://skmtc.dev/druva/apis/authentication/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/druva/authentication/revisions/2af2bf148b25/schema)