This document describes how to adjust the instance version in the TencentDB for SQL Server console.
Supported versions
TencentDB for SQL Server single-node (formerly basic edition) and two-node (formerly high-availability/cluster edition) instances support version upgrade.
Prerequisites
You can adjust the configuration of a TencentDB for SQL Server instance and its associated instances only when they are in running status and are not executing any tasks.
Note
Currently, the database version cannot be downgraded back after an upgrade.
Impact of configuration adjustment
Data migration will be involved during the instance configuration adjustment, and the larger the data volume, the longer the data migration time. Access to the instance will not be affected during this period.
A switch will be performed after migration is completed, which causes a momentary disconnection from the database for a few seconds. Make sure that your business has a reconnection mechanism.
Most database, account, and network operations are unavailable during the momentary disconnection. Therefore, we recommend that you perform the switch during off-peak hours.
Directions
1. Log in to the TencentDB for SQL Server console, select the region and target instance in the instance list, and click Adjust Configuration in the Operation column.
2. In the Adjust Configuration window that pops up, select the desired Database Version and click Confirm.
Note:
Select the Time to Take Effect of the configuration adjustment and click the orange note.
During maintenance time: You can modify the maintenance time on the instance details page.
Adjust now: The configuration adjustment will be performed immediately.
3. For pay-as-you-go instances, click Adjust in the window.
4. You will be redirected to the instance list. When the instance status changes from Adjusting instance configuration to Running, the version upgrade is completed. You can query and check the new version on the Instance List or Instance Details page.
Was this page helpful?