TencentDB for SQL Server provides a rollback tool for rolling back an instance. Historical data can be re-constructed by using periodical backups and real-time transactions. This document describes how to roll back a single database, multiple databases, or all databases to another instance in the same region by time point or backup set.
Prerequisites
To use the rollback feature, you must have an existing TencentDB for SQL Server instance. To create one, see Creating SQL Server Instance.
To use the rollback feature, there must be a database under the instance. To create one, see Create a Database.
Notes
Before rolling back, ensure that the target instance has sufficient storage space.
Make sure there are no other tasks being executed on the source instance before rollback.
The database version of the target instance must be greater than or equal to the source instance database version.
For example: A source instance with the 2012 Enterprise version cannot be rolled back to a target instance with the 2008R2 Enterprise version; it can only be rolled back to instances with the 2012 Enterprise version or higher.
The architecture of the target instance must be the same as the source instance.
For example: A Cloud Disk Edition dual-node instance can only be rolled back to another Cloud Disk Edition dual-node instance, and cannot be rolled back to a Cloud Disk Edition single-node or a local disk dual-node instance.
2. Select the Region above, find the required instance, click Instance ID or Operation in the Manage column to enter the instance management page.
3. Select Backup Management, and click Rollback at the upper right corner of the backup management page or click Rollback in the Operation column of the data backup list.
4. In the popped-up rollback settings interface, based on your selected rollback method, complete the corresponding configurations, and click Save.
Scenario 1: Rollback by Time Point
Parameter
Description
Select the target instance
Select rollback 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 which you want to roll back. You can quickly search by instance ID/name, and the selection supports instances in the same region across availability zones.
Select Rollback Method
Select Roll Back by Time Point.
You can roll back to a specific time point on the source database instance. The range of the time points you can select is determined by the log backup retention duration you have set.
Set the rollback time
Select the rollback time.
The databases of the same instance can only have a uniform rollback time.
Whether to overwrite the original database
Choose whether to overwrite the existing database when selecting the database to be rolled back.
If you select "Yes," after a successful rollback, the original database will be renamed to RESTORE_OLD_*_Original Database Name, and the new database will use the original database name.
If you select "No," after a successful rollback, the original database remains unchanged, and the new database name from the rollback will be the user-defined name (default is system-generated).
Select the database to be rolled back
Select the database to be rolled back. Supports rolling back a single database, multiple databases, or all databases. You can quickly filter by searching the database name. The selected databases can be renamed under Selected Databases on the right. If not renamed, the new databases from the rollback will have system-generated names, which are prefixed with the original database names.
The name of the database after rollback can contain only digits, uppercase and lowercase English letters, and special characters -_./()[]()+=::@. It must start with an English letter and can be up to 128 characters long.
Scenario 2: Roll back by backup set
Parameter
Description
Select the target instance
Select rollback 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 which you want to roll back. You can quickly search by instance ID/name, and the selection supports instances in the same region across availability zones.
Select Rollback Method
Select Rollback by Backup Set.
Note:
You can restore a new database from a specified backup set. The selection range of the backup set is determined by the data backup retention duration you set.
Select Backup Set
Select the backup set for rollback.
Whether to overwrite the original database
Choose whether to overwrite the existing database when selecting the database to be rolled back.
If you select "Yes," after a successful rollback, the original database will be renamed to RESTORE_OLD_*_OriginalDatabaseName, and the new database from the rollback will use the original database name.
If you select "No," after a successful rollback, the original database remains unchanged, and the new database name from the rollback will be the user-defined name (default is system-generated).
Select the database to be rolled back
Select the database to be rolled back. Supports rolling back a single database, multiple databases, or all databases. You can quickly filter by searching the database name. The selected databases can be renamed under Selected Databases on the right. If not renamed, the new databases from the rollback will have system-generated names, which are prefixed with the original database names.
Note:
The name of the database after rollback can contain only digits, uppercase and lowercase English letters, and special characters -_./()[]()+=::@. It must start with an English letter and can be up to 128 characters long.
