Restore SQL Server database(s) to an alternate location

post

https://apis.druva.com/phoenix/sqlserver/v2/orgs/{orgID}/jobs/restores/alternate

Performs a full restore of SQL Server database(s) to an alternate instance or availability group.

Path Params

orgID

int32

required

Specify the ID of your organization under which the SQL Server is registered. Get the ID of an organization using the 'List all organizations' API.

Body Params

Body parameters

backupsetID

int32

required

Specify the ID of the backup set that you want to restore. Get the ID using the 'List backup sets' API.

customDBName

string

Specify the name for the restored database. If you skip this field, the database name created will be rst_<origitnal_database_name>.

databases

array of strings

required

JSONStringList is data type to be used in model definition for data that is string:interface map in memory but stored as JSON string in DB

databases*

fileRestorePath

object

required

pitEpoch

int64

Specify the point in time till which restore has to be triggered in the Unix Epoch format, such as 31536000.

sharedNetworkLocation

string

This field is required for restoring databases to an Availability Group. Specify the path of the shared network location where the availability group is located.

snapshotName

string

required

Specify the name of the snapshot. Get the name of the snapshot using the 'List all snapshots' API.

targetResourceName

string

required

Specify the name of the target resource. The target resource is either availability group or an instance.

targetResourceType

string

required

Specify the target resource type. Enter 'ag' for an availability group or 'sa' for a standalone instance.

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.

Language

Credentials

Header

Response

Click Try It! to start a request and see the response here! Or choose an example:

application/json

200Success