All Products
Search
Document Center

ApsaraDB RDS:CopyDatabaseBetweenInstances

Last Updated:Nov 07, 2024

Replicates databases between RDS SQL Server instances.

Operation description

Supported database engines

RDS SQL Server

References

Note : Before you call this operation, read the following documentation and make sure that you fully understand the prerequisites and impacts of this operation.

Replicate databases between ApsaraDB RDS for SQL Server instances

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Authorization information

The following table shows the authorization information corresponding to the API. The authorization information can be used in the Action policy element to grant a RAM user or RAM role the permissions to call this API operation. Description:

  • Operation: the value that you can use in the Action element to specify the operation on a resource.
  • Access level: the access level of each operation. The levels are read, write, and list.
  • Resource type: the type of the resource on which you can authorize the RAM user or the RAM role to perform the operation. Take note of the following items:
    • The required resource types are displayed in bold characters.
    • If the permissions cannot be granted at the resource level, All Resources is used in the Resource type column of the operation.
  • Condition Key: the condition key that is defined by the cloud service.
  • Associated operation: other operations that the RAM user or the RAM role must have permissions to perform to complete the operation. To complete the operation, the RAM user or the RAM role must have the permissions to perform the associated operations.
OperationAccess levelResource typeCondition keyAssociated operation
rds:CopyDatabaseBetweenInstancescreate
  • DBInstance
    acs:rds:{#regionId}:{#accountId}:dbinstance/{#dbinstanceId}
    none
none

Request parameters

ParameterTypeRequiredDescriptionExample
DBInstanceIdstringYes

The source instance ID. You can call the DescribeDBInstances operation to query the instance ID.

rm-uf6wjk5xxxxxxx
TargetDBInstanceIdstringYes

The destination instance ID. You can call the DescribeDBInstances operation to query the instance ID.

rm-ut5ajk3xxxxxxx
DbNamesstringYes

The names of the databases that you want to copy. Format: Source database name 1,Source database name 2.

{"test1":"newtest1","test2":"newtest2"}
BackupIdstringNo

The ID of the backup set based on which you want to restore databases of the source instance. When you replicate databases by backup set, you can call the DescribeBackups operation to obtain the ID of the backup set.

Note You must specify one of the BackupId and RestoreTime parameters.
106523874****
RestoreTimestringNo

The point in time when the system replicates databases. You can select a point in time within the backup retention period. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time must be in UTC.

Note You must specify one of the BackupId and RestoreTime parameters.
2011-06-11T16:00:00Z
SyncUserPrivilegestringNo

Specifies whether to copy users and permissions.

  • YES: copies users and permissions. If the destination instance has a user whose name is the same as a user in the source instance, the permissions of the user in the source instance will also be granted to the user in the destination instance after you copy user permissions.
  • NO: does not copy users and permissions.

Default value: NO.

NO

Response parameters

ParameterTypeDescriptionExample
object

The response parameters.

RequestIdstring

The ID of the request.

803D11AF-C370-465B-AB46-CB3A642DC303

Examples

Sample success responses

JSONformat

{
  "RequestId": "803D11AF-C370-465B-AB46-CB3A642DC303"
}

Error codes

HTTP status codeError codeError messageDescription
400%sDB Operation Failed:%s.-
400InvalidBackupSetIDInvalid backup set id.The backup set does not exist. You can call the DescribeBackups operation to query existing backup sets.
400DBCountLimitExceededDb count limit exceeded.The number of databases is exceeded.
400BackupRestoreNotSupported.BasicHABasic instances cannot be restored to high availability instances, and high availability instances cannot be restored to basic instances.You cannot restore data from an RDS instance in the Basic Edition to an RDS instance in the High-availability Edition and vice versa.
400BackupRestoreNotSupported.HADedicatedAlwaysOnHigh availability instances cannot be restored to dedicated cluster instances or AlwaysOn instances.The operation failed. The data of an RDS instance that runs the RDS High-availability Edition cannot be restored to an RDS instance that is deployed in a dedicated cluster or runs the RDS Enterprise Edition.
400BackupRestoreNotSupported.ShareDedicatedAlwaysOnShared instances cannot be restored to dedicated cluster instances, AlwaysOn instances, or high availability instances.-
400OperationDenied.RestoreTimeThe instance with snapshot backup enabled can only be restored to the instance with snapshot backup enabled.You can only restore to snapshot backup-enabled instances for instances that have enabled snapshot backup.
400OperationDenied.SnapshotBackupSetSnapshot backup set can only be restored to the instance with snapshot backup enabled.You can only restore to snapshot backup-enabled instances for instances that have enabled snapshot backup and whose backup set type is snapshot.
400CanNotCopyDBHasTDEEnabledThe source database has enabled the TDE feature. You cannot copy it to another instance.TDE is enabled for the source RDS instance. Therefore, the data of the source RDS instance cannot be replicated to a different RDS instance.
400InvalidBackupDBNames.NotFoundThe specified BackupDBNames is not found.The operation failed. The instance name is not specified.
400InvalidBackupDBNames.MalformedThe specified backup database is not valid.The operation failed. The database name is invalid.
400InvalidDBName.FormatSpecified DB name is not valid.The database name is invalid. Specify a valid name. The name can be up to 16 characters in length and can contain lowercase letters, digits, and underscores (_). The name must start with a lowercase letter and end with a lowercase letter or a digit.
400InvalidDBInstanceName.NotFoundInvalid DBInstanceId NotFound.The instance ID cannot be found.
400EngineNotSupportedThe engine does not support the operation.The operation is not supported for the database engine that is run on the RDS instance.
400InvalidTargetDBInstanceName.FormatSpecified Target DB instance name is not valid.The name of the destination instance is invalid.
400MasterDBInstanceState.NotSupportThe Master instance state does not support this operation.The operation failed. The RDS instance is not in a ready state.
400TargetInstanceEngineNotSupportedThe specified Engine cannot be supported the operation.The engine does not support the operation.
400InvalidInstancesRegion.MalformedThe instance region is not the same as the target instance region.The destination instance resides in a different region from the source instance.
400InvalidStartTime.FormatThe specified parameter "StartTime" is not valid.The start time is invalid. Specify the time in the GMT standard in the YYYY-MM-DDThh:mmZ format. For example, you can set the start time to 2012-06-11T15:00Z in the DescribeDBInstancePerformance operation and set the start time to 2011-06-11T16:00Z in the DescribeErrorLogs operation.
400InvalidEndTime.FormatThe specified parameter "EndTime" is not valid.The operation failed. The end time is invalid. Specify the time in the GMT standard in the YYYY-MM-DDThh:mmZ format. Example: 2012-06-11T15:00Z.
400InvalidParameterCombinationThe end time must be greater than the start timeThe end time must be later than the start time.
400InvalidBackupSetLocation.FormatSpecified backup set location is not valid.-
400InvalidCrossRegionTransCross region instance trans is not supported-
400ErrorParametersConflictParameter BackupsetID and restoretime can only exist one.-
400InvalidDBName.NotFoundSpecified DB name does not exist.The database name cannot be found. Enter a valid database name.
400InvalidDBName.DuplicateSpecified DB name already exists in the This instance.A database with the same name has been created on the RDS instance. Specify a different name.
400ReadDBInstanceNotSupportThe operation is not permitted due to type of the instance.-
400InvalidRecoveryDbInstance.StorageSizeThe disk space of the new instance cannot be less than that of the current instanceThe operation failed. The available storage space of the new RDS instance must be greater than or equal to the total size of data stored in the original RDS instance.
400InvalidRecoveryDBNames.FormatThe specified parameter DBNames is not valid.The instance name is invalid. Check the instance name.
400InvalidBackupIdOrRestoreTime.NotFoundThe specified parameter BackupId or RestoreTime is not valid.The operation failed. The values of the BackupId and RestoreTime parameters are invalid.
400Forbidden.RegionNotFoundThe provided RegionId does not exist in our record.The operation failed. The region ID cannot be found.
400ImageNotFoundThe specified Image is disabled or is deleted.-
400InvalidZone.NotSupportedForStorageTypeThe specified zone is closed or invalid for Specified DBInstanceStorageType.-
400InvalidEngineOrEngineVersionThe specified params engine or engineVersion should not be null.-
400InvalidGeneralGroupNameOrGdnInstanceNameThe specified params generalGroupName or gdnInstanceName should not be null.-
400InvalidVSwitchId.NotFoundSpecified virtual switch is not found in specified VPC.No vSwitch is available in the VPC.
400CDDC.TargetHostIDNotAvailableThe target host ID is not available.The host is unavailable. Specify a different host.
400CDDC.AvailableHostsNotEnoughInZoneNot enough available hosts are in the target zone.-
400ReadOnlyInstanceNotSupportSpecified ReadOnly Instance not support this operation.Read-only instances do not support the operation.
400InvalidShareDbInstanceClassNotSupportThe current instance classType is not support operation.This operation is not supported for the specified instance type.
400InvalidQuantity.NotSupportedThe specified instance quantity is not supported.The number of RDS instances exceeds the upper limit. Check the number of RDS instances.
400IncorrectMasterDBInstanceStateMaster instance state does not support this operation.-
400InvalidDBInstance.ReadDBInstanceExceededCurrent DB Instance exceeding the allowed amount of read instance.The number of read-only instances exceeds the upper limit. Adjust the number of read-only instances. A primary ApsaraDB RDS for MySQL instance with more than 64 GB memory supports a maximum of 10 read-only instances. An ApsaraDB RDS for MySQL with less than 64 GB memory supports a maximum of five read-only instances.
400InvalidEngineVersion.MalformedSpecified engine version is not valid.The database engine version is invalid. Check the database engine version and try again.
400InvalidEssdStorageSizeThe cloud ESSD storage size is invalid.The storage size of cloud disks is invalid. Check the storage size.
400IncorrectInstanceNetworkTypeThe specified parameter InstanceNetworkType is not valid.-
400AtLeastTwoVSwitchParamExistsThe specified params(Vswitchs) at least two.At least two Vswitchs parameters must be specified. Each Vswitchs parameter specifies a vSwitch in a zone.
400InvalidIzNo.NotSupportedSpecified VPC zone is not supported.The VPC cannot be found in the zone. Specify a different VPC and try again.
400InvalidBackupSetSpecified database does not exists in the backup set.-
400InvalidRestoreTimeSpecifiedUnable to restore to the specified time, because the database is in cold storage at this time. Please choose a valid restore point.Unable to restore to the specified time, because the database is in cold storage at this time. Please choose a valid restore point.
400InvalidRestoreDBUnable to restore, because the database is in cold storage now. Please skip this database.Unable to restore, because the database is in cold storage now. Please skip this database.
400Order.ComboInstanceNotAllowOperateA package instance is not allowed to operate independently.A package instance is not allowed to operate independently.
400Price.PricingPlanResultNotFoundPricing plan price result not found.Pricing plan price result not found.
400Order.NoRealNameAuthenticationYou have not passed the real-name authentication and do not meet the purchase conditions. Please log in to the user center for real-name authentication.You have not passed the real-name authentication and do not meet the purchase conditions. Please log in to the cost and cost for real-name authentication.
400InsufficientAvailableQuotaYour account quota limit is less than 0, please recharge before trying to purchase.Your account available limit is less than 0, please recharge before trying to purchase.
400CommodityServiceCalling.ExceptionFailed to call commodity service.Failed to call commodity service return.
400RegionDissolvedEOMDear customer, Alibaba Cloud plans to optimize and adjust the current region. Cloud services in this region will cease operations. You are currently unable to operate new purchase orders. Thank you for your understanding and support.Hello, Alibaba Cloud plans to optimize and adjust the current region. Cloud services in this region will stop operating. In order to ensure your business continuity and smooth transition of data migration, you are currently unable to operate new purchase orders. Thank you for your understanding and support.
400Commodity.InvalidComponentThe module you purchased is not legal, please buy it again.The module you purchased is not legal, please buy it again.
400RegionEndTimeDissolvedIndiaCloud services in the India (Mumbai) region will be discontinued. Set the validity date to July 15, 2024 or earlier than July 15, 2024.Hello customer, this area has been abolished.
400RegionEndTimeDissolvedAustraliaCloud services in the Australia (Sydney) region will be discontinued. Set the validity date to September 30, 2024 or earlier than September 30, 2024.Cloud services in the Australia (Sydney) region will be discontinued. Set the validity date to September 30, 2024 or earlier than September 30, 2024.
400Price.CommoditySysCommodity system call exception.Commodity system call exception.
400Pay.InsufficientBalanceInsufficient available balance.Insufficient available balance.
400Order.PeriodInvalidThere is a problem with the period you selected, please choose again.There is a problem with the period you selected, please choose again.
400pay.noCreditCardAccount not bound to credit card.-
400Order.InstHasUnpaidOrderThere is an unpaid order for the service you have purchased. Please pay or void it before placing the order.There is an unpaid order for the service you have purchased. Please pay or void it before placing the order.
400noAvailablePaymentMethodNo payment method is specified for your account. We recommend that you add a payment method.-
400BasicInfoUncompletedYour information is incomplete. Complete your information before the operation.Your basic information is not complete, please complete your basic information before operation.
400Risk.RiskControlRejectionYour account is abnormal, please contact customer service for details.Your account is abnormal, please contact customer service for details.
400BasicInfoUncompletedYour information is incomplete, Complete your information before the operation.-
400Api.NotSupportSpecified api is not supported.The current interface does not support.
400ContainForbiddenLabelErrorThere is a label that prohibits placing orders. Please contact your distributor for assistance.You cannot place the order because a tag indicates that order placement is prohibited. Contact your distributor.
400InvalidDBInstanceId.NotFoundThe DBInstanceId provided does not exist in records.The DBInstanceId provided does not exist.
400InvalidInstanceLevel.DiskTypeSpecified instance level not support request disk typeThe current instance type does not support the specified storage type.
400InvalidParamSepcified wal level Parameter is invalid. There are still logical slots in instance, so it can not be set as replica.The specified wal_level parameter is invalid. There is still a copy slot in the instance, so it cannot be set to replica.
400KmsApiErrorUser secret key invalid.The user key is invalid.
400System.SaleValidateFailedSales expression validation system error.A system error occurs when the sales expression is verified.
400Abs.InvalidAccount.NotFoundaccount is not found.The account does not exist.
400SqlExecuteFailedOrTimeoutsql command execution failed or timed out:%s.SQL command execution failed or timed out
400ColdData.EngineVersionNotSupportThe current instance engine version not support coldDataEnabled.The current instance engine version not support coldDataEnabled.
400ColdData.MinorVersionNotSupportThe current instance minor version not support coldDataEnabled.The current instance minor version not support coldDataEnabled.
400IncorrectTargetClasscodeThe current instance type does not support this operation.This operation is not supported by the instance type.
400InvalidConnectionString.DuplicateSpecified connection string already exists in the RDS.The link address name is duplicate. Please reset the connection string.
400RequiredParam.NotFoundRequired input param is not found.-
400Parameters.InvalidParameter error, please check the parameters.Parameter error, please check the parameters.
400BackupPolicyNotSupportCold Data won't open with CrossBackup or Flash Backup, please check Backup Policy.Cold Data won't open with CrossBackup or Flash Backup, please check Backup Policy.
400InvalideStatus.FormatThe instance status does not support this operation.-
400InvalidReleasedKeepPolicy.FormatSpecified Released Keep Policy is not valid.Specified Released Keep Policy is not valid.
400InvalidDBInstanceEngineType.Formatthe DB instance engine type does not support this operation.This operation is not supported for the database engine of the instance.
400Pay.NoCreditCardNo credit cards.No credit cards.
400VpcNetworkTypeNotSupportThe vpc network type instance does not support this operation.The vpc network type instance does not support this operation.
400MirrorInsExistsSpecified DB instance mirror ins already existed.Specified DB instance mirror ins already existed.
400UnsupportedClassCodeThe specified DB instance class stops selling.The specified DB instance class stops selling.
400OrdTCommodityQueryErrorFailed to query for product.Failed to query product.
403StorageLimitExceededExceeding the allowed Storage of DB instance.The disk usage exceeds the upper limit. Free your disk space.
403InvalidTempInstance.NotSupportThe temp db Instance is not support.The instance is locked.
403IncorrectDBInstanceStateThe current database instance state does not support the operation.The operation failed. The RDS instance is not running.
403IncorrectDBInstanceTypeCurrent DB instance engine and type does not support operations.The operation failed. The operation is not supported for the database engine of the RDS instance.
403Forbidden.SnapshotRecoverySnapshot backup does not support partial restoreThe operation failed. Snapshot backup files cannot be used to restore only a specific part of data.
403OperationDenied.ResourceSpecified DB instance class or storage is not available in all Availability Zones.Insufficient resources. Try again with a different instance type or storage size.
403ReadonlyDBInstanceStorageExceededYou can not create the order with the db instance because The masterInstance storage value exceeding the readonlyInstance storage value.The primary instance storage value exceeds the read-only instance storage value. You cannot use the database instance to create an order.
403MasterDBInstanceClassNotSupportYou can not create the readonly instance with the master instance class does not support.The operation failed. The current primary instance class does not support creating read-only instances.
403ReadonlyDBInstanceClassNotSupportYou can not create the readonly instance with the instance class does not support.The operation failed. The current instance class does not support creating read-only instances.
403ReadonlyDBInstanceClassLowerThanMasterInstanceThe readonly instance db instance class are lower than master instance db instance class.The read-only instance has lower specifications than the primary instance.
403InvalidSwitchType.MalformedThe specified parameter InvalidSwitchType is not valid.The value of the InvalidSwitchType parameter is invalid.
403UnsupportedCopyDbHighAvailabilityToBasicReplicate Database from RDS Category:HighAvailability to RDS Category:Basic is not supported.-
403InvalidInstanceVersionSource instance version is greater than the target instance version.-
403UnsupportedCopyDbShareToHighAvailabilityReplicate Database from RDS Category:Share to RDS Category:HighAvailability is not supported.-
403UnsupportedCopyDbAlwaysOnToBasicReplicate Database from RDS Category:AlwaysOn to RDS Category:Basic is not supported.-
403UnsupportedCopyDbBasicToShareReplicate Database from RDS Category:Basic to RDS Category:Share is not supported.-
403UnsupportedCopyDbAlwaysOnToHighAvailabilityReplicate Database from RDS Category:AlwaysOn to RDS Category:HighAvailability is not supported.-
403UnsupportedCopyDbShareToBasicReplicate Database from RDS Category:Share to RDS Category:Basic is not supported.-
403UnsupportedCopyDbHighAvailabilityToShareReplicate Database from RDS Category:HighAvailability to RDS Category:Share is not supported.-
403UnsupportedCopyDbShareToAlwaysOnReplicate Database from RDS Category:Share to RDS Category:AlwaysOn is not supported.-
403UnsupportedCopyDbAlwaysOnToShareReplicate Database from RDS Category:AlwaysOn to RDS Category:Share is not supported.-
403InvalidParamTableMeta.RestoreTimeThe specified restore time cannot be covered by the existing backup chain. Please try specifying a different restore time.-
403CurrentRecoveryModelNotSupportThisActionCurrent recovery model not supported this action.The current recovery model does not support.
403OrderStatus.UnPaidThe specified db instance has unpaid order.The instance has an unpaid order. Please pay first and try again.
403InvalidReduceDiskSizeThe storage capacity after the scale-down must be larger than the used amount.The scale-in target capacity cannot be less than the current storage space usage
403CloudSSDNotSupportCloud ssd does not support this operation, please upgrade to essd.-
403InvalidUserOperatorPermissionThe user permission does not support this operation.The user is not authorized to perform this operation.
403InvalidVswitchIdSpecified conn vswitch id is not valid.-
403IncorrectMinorVersionCurrent engine minor version does not support operations.This operation is not supported for the current minor engine version.
403OperationDenied.ZoneResourceThere is no available zone for inventory.There is no available zone for inventory.
403NotInFlowControllerSorry,no permission.Sorry,no permission.
403InvalidKmsKeyKms key is disabled.-
403InvalidInstanceLevel.MalformedCurrent DB instance level does not support this operation.The specified database instance type does not support this operation.
404InvalidDBInstance.NotFoundThe specified instance does not exist or is not supported.The RDS instance cannot be found. Check the ID or name of the RDS instance.
404InvalidInstanceStorageType.NotFoundThe specified DBInstanceStorageType is not found.You must specify the InstanceStorageType parameter.
404InvalidRegion.NotFoundSpecified Region does not exist in the RDSThe region ID is invalid.
404IncorrectVswitchIdThe specified parameter VSwitchId is not valid.The vSwitch ID is invalid.
404InsufficientResourceCapacityCurrent cluster resources are insufficient. Try again later.Current cluster resources are insufficient. Try again later.
404InvalidParamInvalid params to call rds open api, BakDBNames is not empty.The BakDBNames parameter that is used to call the ApsaraDB RDS API is invalid. You must specify a value for the parameter.
404InvalidClusterKmsThe current instance does not authorized to access the Key Management Service.The instance does not have permissions to access Key Management Service (KMS).
404Request.NotFoundThe requested resource is not available.The requested resources are unavailable.
404HostInfo.NotFoundThe specified host info is not found.-
408NetworkOrSqlTimeoutErrorFailed to create login due to potential SQL Server overload or other issues that may cause the login creation fail. Please retry later.The operation failed due to potential SQL Server overload or other issues that could cause the operation to fail. Please try again later.
500ExternalFailureThe request processing has failed due to external service failure.The request processing has failed due to external service failure.
500RequestMetaDataFailedThe service request failed. Please try again later or contact service personnel.The service request failed. Please try again later or contact service personnel.
500InvokeProxyFailureThe request processing has failed due to service failure of rds api.The request failed to be processed due to an RDS API failure.

For a list of error codes, visit the Service error codes.

Change history

Change timeSummary of changesOperation
2024-07-16The Error code has changedView Change Details
2024-05-28The Error code has changedView Change Details
2024-04-02The Error code has changedView Change Details
2023-11-06The Error code has changedView Change Details
2023-09-08The Error code has changedView Change Details
2023-03-24The Error code has changedView Change Details
2022-10-28The Error code has changedView Change Details
2022-07-19The Error code has changedView Change Details