---
title: "GET /#Action=RestoreDBInstanceToPointInTime"
method: GET
path: "/#Action=RestoreDBInstanceToPointInTime"
---

# GET /#Action=RestoreDBInstanceToPointInTime

`GET /#Action=RestoreDBInstanceToPointInTime`

Restores a DB instance to an arbitrary point in time. You can restore to any point in time before the time identified by the LatestRestorableTime property. You can restore to a point up to the number of days specified by the BackupRetentionPeriod property.

The target database is created with most of the original configuration, but in a system-selected Availability Zone, with the default security group, the default subnet group, and the default DB parameter group. By default, the new DB instance is created as a single-AZ deployment except when the instance is a SQL Server instance that has an option group that is associated with mirroring; in this case, the instance becomes a mirrored deployment and not a single-AZ deployment.

This command doesn't apply to Aurora MySQL and Aurora PostgreSQL. For Aurora, use `RestoreDBClusterToPointInTime`.

## Query parameters

- `SourceDBInstanceIdentifier` string
- `TargetDBInstanceIdentifier` string, required
- `RestoreTime` string, date-time
- `UseLatestRestorableTime` boolean
- `DBInstanceClass` string
- `Port` integer
- `AvailabilityZone` string
- `DBSubnetGroupName` string
- `MultiAZ` boolean
- `PubliclyAccessible` boolean
- `AutoMinorVersionUpgrade` boolean
- `LicenseModel` string
- `DBName` string
- `Engine` string
- `Iops` integer
- `OptionGroupName` string
- `CopyTagsToSnapshot` boolean
- `Tags` object[] — A list of tags. For more information, see <a href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Tagging.html">Tagging Amazon RDS Resources</a> in the <i>Amazon RDS User Guide.</i>
  - `Key` string — A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with <code>aws:</code> or <code>rds:</code>. The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\\p{L}\\p{Z}\\p{N}_.:/=+\\-@]*)$").
  - `Value` string — A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with <code>aws:</code> or <code>rds:</code>. The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\\p{L}\\p{Z}\\p{N}_.:/=+\\-@]*)$").
- `StorageType` string
- `TdeCredentialArn` string
- `TdeCredentialPassword` string
- `VpcSecurityGroupIds` string[]
- `Domain` string
- `DomainIAMRoleName` string
- `EnableIAMDatabaseAuthentication` boolean
- `EnableCloudwatchLogsExports` String[]
- `ProcessorFeatures` object[]
  - `Name` string — The name of the processor feature. Valid names are <code>coreCount</code> and <code>threadsPerCore</code>.
  - `Value` string — The value of a processor feature name.
- `UseDefaultProcessorFeatures` boolean
- `DBParameterGroupName` string
- `DeletionProtection` boolean
- `SourceDbiResourceId` string
- `MaxAllocatedStorage` integer
- `SourceDBInstanceAutomatedBackupsArn` string
- `EnableCustomerOwnedIp` boolean
- `CustomIamInstanceProfile` string
- `BackupTarget` string
- `NetworkType` string
- `StorageThroughput` integer
- `AllocatedStorage` integer
- `Action` 'RestoreDBInstanceToPointInTime', required
- `Version` '2014-10-31', required

## Response `200`

Success

## Other responses

- `480` — DBInstanceAlreadyExistsFault
- `481` — DBInstanceNotFoundFault
- `482` — InstanceQuotaExceededFault
- `483` — InsufficientDBInstanceCapacityFault
- `484` — InvalidDBInstanceStateFault
- `485` — PointInTimeRestoreNotEnabledFault
- `486` — StorageQuotaExceededFault
- `487` — InvalidVPCNetworkStateFault
- `488` — InvalidRestoreFault
- `489` — DBSubnetGroupNotFoundFault
- `490` — DBSubnetGroupDoesNotCoverEnoughAZs
- `491` — InvalidSubnet
- `492` — ProvisionedIopsNotAvailableInAZFault
- `493` — OptionGroupNotFoundFault
- `494` — StorageTypeNotSupportedFault
- `495` — AuthorizationNotFoundFault
- `496` — KMSKeyNotAccessibleFault
- `497` — DBSecurityGroupNotFoundFault
- `498` — DomainNotFoundFault
- `499` — BackupPolicyNotFoundFault
- `500` — DBParameterGroupNotFoundFault
- `501` — DBInstanceAutomatedBackupNotFoundFault
- `502` — NetworkTypeNotSupported

---

[API](https://skmtc.net/aws/apis/rds.md) · [All operations](https://skmtc.net/aws/apis/rds/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/aws/rds/revisions/e6b3ad7df19b/schema)