Rollback Scheme Overview

Last updated:2025-09-09 11:09:57

Rollback Scheme Overview

Last updated: 2025-09-09 11:09:57

This document provides an overview of the data recovery scheme for SQL Server.                  
Scenario
Feature
﻿
Related Operations
Rollback (Recovery of coud-based databases)
Rollback to the current instance (supporting rollback to the current instance either by time point or backup set)
﻿
﻿Rollback to current instance﻿
﻿
Rollback to the existing instance
In-region rollback (Supports rollback to other instances within the same region based on time point or backup set)
﻿Rollback to existing instance - in-region rollback﻿
﻿
﻿
Cross-region rollback (Supporting rollback to other instances across regions based on time point or backup set)
﻿Rollback to existing instance (cross-region)﻿
Restoration (Migrating an on-premises database to the cloud)
Migration/restoration to an existing instance
﻿
﻿Cold backup migration (Migrating data to TencentDB for SQL Server from another cloud provider or a self-built SQL Server via backup files)﻿
﻿Migrating data with DTS (Using DTS to migrate data from another cloud provider or self-built SQL Server to TencentDB for SQL Server)﻿
﻿Using DTS for cross-account data migration (Employing DTS to perform data migrations between Tencent SQL Server instances under different accounts)﻿
Related APIs
API
Description
﻿DescribeDBRestoreTime﻿
This API is used to query databases that can be rolled back.
﻿DescribeRollbackTime﻿
This API is used to query the time range available for instance rollback.
﻿RollbackInstance﻿
This API is used to roll back the instance by time point.
﻿RestoreInstance﻿
This API is used to roll back the database by backup set.
﻿DescribeRestoreTask﻿
This API is used to query the list of rollback tasks.
﻿DeleteRestoreTask﻿
This API is used to delete rollback task records.
﻿
﻿

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

Feedback

Scenario	Feature			Related Operations
Rollback (Recovery of coud-based databases)	Rollback to the current instance (supporting rollback to the current instance either by time point or backup set)			Rollback to current instance
		Rollback to the existing instance	In-region rollback (Supports rollback to other instances within the same region based on time point or backup set)	Rollback to existing instance - in-region rollback
		Rollback to the existing instance		Cross-region rollback (Supporting rollback to other instances across regions based on time point or backup set)	Rollback to existing instance (cross-region)
Restoration (Migrating an on-premises database to the cloud)	Migration/restoration to an existing instance			Cold backup migration (Migrating data to TencentDB for SQL Server from another cloud provider or a self-built SQL Server via backup files) Migrating data with DTS (Using DTS to migrate data from another cloud provider or self-built SQL Server to TencentDB for SQL Server) Using DTS for cross-account data migration (Employing DTS to perform data migrations between Tencent SQL Server instances under different accounts)

API	Description
DescribeDBRestoreTime	This API is used to query databases that can be rolled back.
DescribeRollbackTime	This API is used to query the time range available for instance rollback.
RollbackInstance	This API is used to roll back the instance by time point.
RestoreInstance	This API is used to roll back the database by backup set.
DescribeRestoreTask	This API is used to query the list of rollback tasks.
DeleteRestoreTask	This API is used to delete rollback task records.

tencent cloud

Related APIs