If you want to create a database that is the same as an existing database, you can replicate the existing database. This topic describes how to replicate a database of an ApsaraDB RDS instance that runs SQL Server 2008 R2 in the ApsaraDB RDS console.

Prerequisites

The RDS instance runs SQL Server 2008 R2.

Note If the RDS instance runs SQL Server 2012 or later, you can replicate its databases only by executing SQL statements. For more information, see Replicate a database of an ApsaraDB RDS instance that runs SQL Server 2012 or later.

Precautions

  • Only one database can be replicated at a time.
  • The names of the new database and the existing database must be different.

Procedure

  1. Log on to the ApsaraDB RDS console.
  2. Find the primary RDS instance and click its ID.
  3. In the left-side navigation pane, click Databases.
  4. Click Copy Database.
  5. In the dialog box that appears, configure parameters for the new database.
    Parameter Description
    Enter a Database Name Enter a name for the new database. The name can be up to 64 characters in length and can contain lowercase letters, digits, underscores (_), and hyphens (-). It must start with a letter and end with a letter or a digit.
    Select the Database to Copy Select the database that you want to replicate.
    Do You Want to Keep the Account Information from the Source Database Specify whether to retain the account and account permissions of the existing database in the new database. By default, the account and account permissions are retained.
    Description Enter an informative description of the database. The description can be up to 256 characters in length.
  6. Click OK.