Rolling Back to an Existing Instance (same region)
다운로드
포커스 모드
폰트 크기
TencentDB for SQL Server provides a rollback tool that allows you to roll back an instance and reconstruct historical data through regular backups and real-time logs. This document describes how to roll back a single database, multiple databases, or all databases to another instance in the same region based on a point in time or a backup set.
Prerequisites
To use the rollback feature, a TencentDB for SQL Server instance must already exist. To create one, see Create a TencentDB for SQL Server Instance.
To use the rollback feature, a database must exist under the instance. To create one, see Database Creation.
Note
Before performing a rollback, ensure that the target instance has sufficient storage space.
Before performing a rollback, ensure that no other tasks are running on the source instance.
The database edition of the target instance for rollback must be greater than or equal to that of the source instance.
For example, a source instance of the 2012 Enterprise edition cannot be rolled back to a target instance of the 2008R2 Enterprise edition. It can only be rolled back to an instance of the 2012 Enterprise edition or a later edition.
The target instance architecture for rollback must be the same as the source instance architecture.
For example, a dual-node (cloud disk) instance can only be rolled back to another dual-node (cloud disk) instance instead of a single-node (cloud disk) instance or a dual-node (local disk) instance.
When you choose to overwrite the original database during a rollback operation, if the rollback database instance has a read-only instance, the read-only instance will resynchronize data. During the resynchronization period, operations cannot be performed on the read-only instance. After synchronization is completed, operations can be performed.
Operation Steps
1. Log in to the TencentDB for SQL Server console.
2. Select a Region at the top, locate the required instance, and click its Instance ID or Manage in the Operation column to go to the instance management page.
3. Select Backup Management and click Rollback on the right, or click Rollback in the Operation column of the corresponding backup file under Backup Management > Data Backup.
4. In the pop-up rollback settings page, after completing the corresponding configuration based on the selected rollback method, click Save.
Scenario One: Rollback by Time Point
Parameter | Description |
Select the target instance | Select to roll back to an existing instance here. |
Target Instance Region | Select the same region as the source instance here. |
Target Instance Name | Select the target instance to roll back to. You can quickly search by instance ID/instance name, which supports fuzzy search. You can also select instances across AZs within the same region. |
Select rollback mode | Select to roll back to a specific point in time. Databases can be rolled back to a specific point in time from the source database instance. The selectable time point range is determined by the log backup retention period you set. Note: Databases in Simple recovery mode are not available for rollback to a specified time point. To learn about or modify the recovery mode, see Modify Recovery Mode. |
Set rollback time | Select the rollback time. Please select Beijing time for the rollback operation. Databases within the same instance can only be set to a uniform rollback time. |
Overwrite original database | Select whether the database to be rolled back should overwrite the original database. If you select "Yes", after the rollback is successful, the original database will be renamed to RESTORE_OLD_*_original_database_name, and the new database generated from the rollback will use the original database name. If you do not select "Yes", after the rollback is successful, the original database remains unchanged, and the new database generated from the rollback is named with a user-defined name (by default, the system automatically generates the name). |
Select the database to be rolled back | Select the database(s) to be rolled back. The operation supports rolling back a single database, multiple databases, or all databases. You can also filter databases quickly by searching for their names. If you choose not to overwrite the original database, the selected database(s) can be renamed under the Rollback Database section on the right. If no rename is performed, the new database name generated after rollback defaults to a system-generated name in the format of a prefix plus the original database name. The database name after rollback supports only letters, digits, underscores (_), and hyphens (-), must start with a letter, and can contain up to 128 characters. If you choose to overwrite the original database, renaming under the Rollback Database section on the right is not required. |
Scenario Two: Rollback by Backup Set
Parameter | Description |
Select the target instance | Select to roll back to an existing instance here. |
Target Instance Region | Select the same region as the source instance here. |
Target Instance Name | Select the target instance to roll back to. You can quickly search by instance ID/instance name, which supports fuzzy search. You can also select instances across AZs within the same region. |
Select rollback mode | Select to roll back using a backup set. |
Select replica set | Select the backup set for rollback. A new database can be rolled back from a specified backup set. The range of backup sets available for selection is determined by the data backup retention period you configured. When the backup file is in the form of a single-database backup, the database name in the backup file is displayed in the search bar. |
Overwrite original database | Select whether the database to be rolled back should overwrite the original database. If you select "Yes", after the rollback is successful, the original database will be renamed to RESTORE_OLD_*_original_database_name, and the new database generated from the rollback will use the original database name. If you do not select "Yes", after the rollback is successful, the original database remains unchanged, and the new database generated from the rollback is named with a user-defined name (by default, the system automatically generates the name). |
Select the database to be rolled back | Select the database(s) to be rolled back. The operation supports rolling back a single database, multiple databases, or all databases. You can also filter databases quickly by searching for their names. If you choose not to overwrite the original database, the selected database(s) can be renamed under the Rollback Database section on the right. If no rename is performed, the new database name generated after rollback defaults to a system-generated name in the format of a prefix plus the original database name. The database name after rollback supports only letters, digits, underscores (_), and hyphens (-), must start with a letter, and can contain up to 128 characters. If you choose to overwrite the original database, renaming under the Rollback Database section on the right is not required. |
Related APIs
API | Description |
The API (RestoreInstance) is used to roll back databases by backup set. | |
The API (DescribeRestoreTask) is used to query the rollback task list. | |
The API (DeleteRestoreTask) is used to delete rollback task records. |
피드백