---
title: "List all backupsets"
method: GET
path: "/sqlserver/v1/orgs/{OrgID}/reports/backupsets"
tags: ["SQLServer"]
---

# List all backupsets

`GET /sqlserver/v1/orgs/{OrgID}/reports/backupsets`

## Request

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

Returns all backup sets for SQL Servers.

## Path parameters

- `OrgID` integer, required

## Query parameters

- `resourceName` string
- `resourceType` string
- `backupEnable` boolean
- `pageToken` string

## Response `200`

Success

- SQLGetBackupsetsResponse: GetBackupsetsResponse is response schema for GetBackupsets
  - `backupsets` SQLBackupsetInfo[]
    - `backupContent` SQLBackupContentStruct
      - `configuredDatabases` string[]: The list of the configured databases. This parameter will be skipped if the value is NULL.
      - `excludeDBPattern` string[]: The list of DB Pattern according to which databases are excluded from the backup. This parameter will be skipped if the value is NULL.
      - `includeAllDBs` boolean: Whether to include all databases or not.
      - `includeAllInstances` boolean: Whether to include all instances or not.
      - `includeDBList` string[]: The list of databases included in the backup. This parameter will be skipped if the value is NULL.
      - `includeDBPattern` string[]: The list of DB Patterns according to which the databases are included for backup. This parameter will be skipped if the value is NULL.
      - `includeInstanceList` string[]: The list of instances included from the backup operation.
    - `backupEnabled` boolean: Backupset enabled/disabled
    - `backupPolicyID` integer: The ID of your backup policy.
    - `backupPolicyName` string: The name of the backup policy attached to the backup set.
    - `backupsetID` integer: The ID of your backup set.
    - `backupsetName` string: The name of the backup set.
    - `dataLock` boolean: The status indicating if Data Lock is enabled for the backup set.
    - `lastBackupDetails` SQLLastBackupDetailsStruct: LastBackupDetailsStruct is response schema for GetBackupsets
      - `jobID` integer: The unique identification number associated with the job.
      - `status` string: The status of the job
    - `organizationID` integer: The ID of your organization.
    - `ltrEnabled` boolean: The status of the backup set whether enabled for long term retention. For example, True denotes that the backup set is enabled for LTR.
    - `organizationName` string: The name of the organization.
    - `resourceName` string: The name of the SQL Server.
    - `resourceType` string: The type of the SQL Server, such as a standalone instance (SA) or an availability group (AG).
    - `storageName` string: The name of the storage.
    - `warmTierDuration` integer: Lists the duration in days for which the snapshot will reside in the warm tier of the AWS storage.
  - `nextPageToken` string: The page token value for the next set of API results. The value of this parameter is NULL for the last set of results.

## Other responses

- `400`: Bad Request
- `404`: The requested resource was not found.
- `500`: The request was not processed due to an internal error in the 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)