---
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}`

## Request

- Base URL: `//apis.druva.com/phoenix` (relative, and the document’s source URL is not known)
- URL: `//apis.druva.com/phoenix/sqlserver/v2/orgs/{orgID}/backupsets/{backupsetID}`
- Auth: API key in header `Authorization`

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/enterprise-workloads.md) - [All operations](https://skmtc.dev/druva/apis/enterprise-workloads/llms.txt) - [OpenAPI document](https://skmtc.dev/druva/apis/enterprise-workloads/revisions/18fc75e8229e?raw)