Rolling back to the current instance
ダウンロード
フォーカスモード
フォントサイズ
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 the current instance 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 instance has sufficient storage space.
Before performing a rollback, ensure that no other tasks are running on the source 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 OK.
Scenario One: Rollback by Time Point
Parameter | Description |
Select the target instance | Select to roll back to the current instance here. |
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 the current instance here. |
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. |
5. Rollback status and records can be queried on the Rollback History tab. You can also click the task icon in the upper-right corner of the Backup Management page to view the rollback progress.
Related APIs
API | Description |
The API (DescribeDBRestoreTime) is used to query databases that are available for rollback. | |
The API (DescribeRollbackTime) is used to query the time range available for instance rollback. | |
The API (RollbackInstance) is used to roll back an instance by time point. | |
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. |
フィードバック