TencentDB for SQL Server consists of a master database and a mirror database that are deployed in different racks. Each database corresponds to a group of monitoring agents which monitor the database in real time based on the heartbeat. The cluster management scheduling center consists of two sets of independently deployed decision-making clusters and configuration clusters and is mainly used to manage the normal operations of the database node group, access gateway cluster and HDFS. The Hadoop distributed file system (HDFS) makes available data disaster recovery service with cold backup. The gateway cluster is accessed to provide a unique IP, and if the data node is switched, the IP won't change.
You can manage the database in the TencentDB for SQL Server Console.
TencentDB for SQL Server do not allow the creation/deletion of databases and creating/deleting/modifying accounts via Microsoft SQL Server Management. You can go to TencentDB for SQL Server Console > Instance Details page > Account Management to create, delete, an account or modify account permission.
Currently, the console only allows you to use the "read-write" and "read-only" permissions. If you need permissions at a higher level, please submit a ticket for application (no sa account is provided).
TencentDB for SQL Server supports 25 common parameters of SQL Server. You can collect statistics of other parameters by configuring the counters of SSMS. For more information, see Monitoring and Alarming.
Currently, alarming is supported for the following metrics through Cloud Monitor. You can configure alarms in Cloud Monitor Console > Alarm Configuration > Alarm Policy.
The full and log backups in TencentDB for SQL Server are retained for seven days; therefore, you can roll back to any time point within the past seven days.
In the TencentDB for SQL Server Console, you can restore the database to another instance (such as a self-built instance) using a downloaded backup file.
Upgrade means upgrading an existing TencentDB for SQL Server instance to a higher specification.
- You can only upgrade an instance to a higher specification. Downgrade is not supported.
- You cannot cancel the upgrade process once it has started.