To copy a database, you can execute SQL statements and specify the source and destination databases by using the sp_rds_copy_database stored procedure. The time depends on the database size.

Prerequisites

The instance version is ApsaraDB RDS SQL Server 2012 or later.

Note For more information, see Copy a database of ApsaraDB RDS SQL Server 2008 R2.

Prerequisites

Before you copy the database, the unused space of the destination instance must be at least 1.3 times the source database.

Procedure

Execute the following statements to copy the database:

USE master
GO
--Query database engine edition
SELECT @@Version
GO
--Create database
CREATE DATABASE testdb
GO
EXEC sp_rds_copy_database 'testdb','testdb_copy'
SELECT *
FROM sys.databases
WHERE name IN ('testdb','testdb_copy')
SELECT 
    family_guid,database_guid,* 
FROM sys.database_recovery_status
WHERE 
DB_NAME(database_id) IN ('testdb','testdb_copy')