TencentDB for SQL Server provides a rollback tool for rolling back an instance. Historical data can be re-constructed by using the periodical backups and real-time transactions so as to roll back the instance to a specified time point where the time slices of all data are guaranteed to be identical.
The data and log backups in TencentDB for SQL Server are retained for seven days; therefore, you can roll back the instance data to any time point within the last seven days. This document describes how to roll back an instance in the console.
- Rollback is currently only supported for the same instance, and you can choose to overwrite the original database or generate a duplicate database.
- If you choose to generate a duplicate database, note that the disk capacity after rolling back cannot exceed the disk capacity available for the instance; otherwise, rollback will fail.