Creating a Backup Using OBS Buckets

Supported Source and Destination Databases

Prerequisites

• You have logged in to the DRS console.

Precautions

This section describes constraints on backup migrations of Microsoft SQL Server databases.

Procedure

This section describes how to create a backup migration task using the backup stored in the OBS bucket on the DRS console.

1. On the Backup Migration Management page, click Create Migration Task.
2. On the Select Backup page, specify information about the task and backup files. Then, click Next.

   Table 3 Task information

   Parameter	Description
   Task Name	The task name consists of 4 to 50 characters, starts with a letter, and can contain only letters (case-insensitive), digits, hyphens (-), and underscores (_).
   Description	The description consists of a maximum of 256 characters and cannot contain special characters !=<>'&"\

   Table 4 Backup file information

   Parameter	Description
   Database Type	Database type of the backup file. Select Microsoft SQL Server.
   Backup File Source	Select OBS Bucket.
   Bucket Name	Select a bucket and a backup file stored in the directory of the bucket. NOTE: The backup file of the Microsoft SQL Server must be named in the .bak format in the OBS bucket directory. Multiple backup files can be selected at the same time. A database cannot be split into different files for upload. The bucket name, backup file name, or path cannot contain Full-width characters or spaces.

3. On the Select Destination page, specify database information and click Next.

   Table 5 Microsoft SQL Server database information

   Parameter	Description
   Destination RDS DB Instance Name	Select a destination RDS DB instance. If no RDS DB instance is available, you can create one.
   Backup File Format	Select Full or Incremental. Full: indicates full backup files. Incremental: indicates log backup files. NOTE: Before performing an incremental restoration, you need to perform a full restoration. To migrate databases at a time, you need to stop services first and upload full backups for restoration. To ensure service continuity during a migration, perform a full backup and multiple incremental backups, and then upload the backup data to OBS for restoration.
   Last Backup	A complete restoration involves restoring several incremental backup files. The destination DB instance cannot be modified while it is being restored. It will not be available until the last backup file is restored. If you select Yes and restore the instance, any incremental restoration will not be performed. You can select the last backup in the following scenarios: Perform a one-time full migration. The selected backup file is the last one to be restored.
   Overwrite Data	You can determine whether to overwrite data in the destination database during the restoration if the destination DB instance contains a database with the same name as the backup database. Exercise caution when performing this operation. NOTE: If you select this option, the destination databases with the same names as the backup databases will be overwritten. Exercise caution when performing this operation.
   Perform Pre-verification	Specifies whether to perform pre-verification on the backup migration task. The default value is Yes. Yes: To ensure successful migration and identify potential problems in advance, verify the validity, integrity, continuity, and version compatibility of backup files before restoration. No: If pre-verification is not performed, the migration speed is faster, but you need to check the validity, integrity, continuity, and version compatibility of backup files on your own.
   Restore Database	You can restore all or part of databases. All of databases are restored by default. All: Restore all databases from the backup file. You do not need to enter the name of the database to be restored. Custom: Restore specified databases from the backup file. You need to enter the names of the databases to be restored. The databases to be restored must be consistent with those for which the full or incremental backups are created.
   Reset Database Name	If Restore Database is set to All, you can reset database names. If you enable Reset Database Name, the original database names in the backup file will be reset to new database names. Constraint: The backup file contains only one database. The backup file is a full backup file and is the last backup file. Select Full for Backup File and Yes for Last Backup Type. NOTE: The database name can be reset only when Backup Type is set to Full and Restore Database is set to All.
   Backup Database Name	If Restore Database is set to Custom, you need to specify Backup Database Name. The backup database name must be the same as that in the backup file and consist of 1 to 256 characters. It can contain only letters (case-sensitive), digits, hyphens (-), and underscores (_). DRS also allows you to create an alias for the database to be restored. If you choose to restore databases in full backup mode, you can set the alias of the database based on the site requirements. The alias is also stored in the destination database. If databases are restored in incremental backup mode, alias is not supported. NOTE: The backup database can be renamed. Up to 100 backup databases can be created.

4. On the Confirm Task page, check configuration details, read and agree to the agreement, and click Next.
   

   If the SQL Server source contains non-clustered index tables, the index information of non-clustered index tables will become invalid after the SQL Server backups are restored to a new database. For the best performance, rebuild the indexes after the backup migration. In addition, the backup files store only database-level information. If the SQL Server source contains some instance-level configurations, such as login, permission, DBlink, and job, migrate these configurations by referring to Manual Configuration

5. In the task list on the Backup Migration Management page, check whether the task is in the Restoring status. If the migration is successful, the task status becomes Successful.