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.

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.
  • The instance version is ApsaraDB RDS SQL Server 2012 or later.

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')