Does TencentDB for SQL Server support manual primary-replica switchover?
The dual-node cloud disk/multi-node cloud disk architecture of TencentDB for SQL Server supports manual primary/secondary switch. For detailed operations, see Manual Primary/Secondary Switching. The dual-node local disk architecture does not support manual primary/secondary switch via the console. If a manual primary/secondary switch is needed, submit a ticket for assistance. Can TencentDB for SQL Server currently access other heterogeneous databases?
Currently, TencentDB for SQL Server doesn't support accessing other heterogeneous databases from a cloud SQL Server.
Does TencentDB for SQL Server support BULK INSERT and other data import methods?
TencentDB for SQL Server currently does not support BULK INSERT and other data import methods.
Does TencentDB for SQL Server support MSDTC?
TencentDB for SQL Server does not support MSDTC.
What is the encryption method for TencentDB for SQL Server?
TencentDB for SQL Server supports SQL Server's native encryption key method. Users can create database-level encryption keys themselves.
Can TencentDB for SQL Server scan the security system vulnerabilities of its servers on its own?
TencentDB for SQL Server currently does not support self-scanning for security system vulnerabilities on its servers.
Can TencentDB for SQL Server use a maintenance plan?
TencentDB for SQL Server currently does not support using a maintenance plan. A maintenance plan generates additional packages and JOBs. You can execute this process by directly creating JOBs to execute SQL statements.
Can TencentDB for SQL Server create folders on the server?
TencentDB for SQL Server does not support creating folders on the database server.
How to enable or disable Change Data Capture (CDC) in TencentDB for SQL Server?
Change Data Capture (CDC) is used to capture insertions, updates, and deletions applied to SQL Server tables and provide details of these changes in a convenient relational format. To enable or disable CDC, see Change Data Capture CDC. How to enable or disable Change Tracking (CT) in TencentDB for SQL Server?
Change Tracking (CT) can be applied to track a specific table or even a specific column in a database. When additions, modifications, or deletions are performed on a table with CT enabled, the system automatically generates a version number for the operation, recording the operation timestamp, operation type, and the primary key of the affected data. To enable or disable CT, see Change Tracking (CT). How to shrink the database in TencentDB for SQL Server?
You can shrink the database directly through the console. For details, see Shrinking Databases. How many databases can a single instance of TencentDB for SQL Server create?
From a performance perspective, having too many databases on TencentDB for SQL Server can lead to performance degradation, consuming resources such as worker threads. Exceeding the database creation limit can result in primary-replica synchronization exceptions. It is recommended to keep the number of databases in a single instance below the maximum limit, which is related to the number of CPU cores of the instance. For detailed formulas on the maximum number of databases for each version, see Number of Databases. Is there a limit on the number of tables for a single instance of TencentDB for SQL Server?
Theoretically, there is no limit on the number of tables for a single instance of TencentDB for SQL Server. However, if the number of tables exceeds 1 million, it may affect database performance. Please regulate the number of tables to ensure it does not exceed 1 million per instance.
Where are the databases created on TencentDB for SQL Server stored?
Log in to the SQL Server SSMS client. After connecting to the instance, right-click Database Properties to view the database file location.
Does TencentDB for SQL Server support reporting services?
TencentDB for SQL Server currently does not support reporting services. If needed, you can use Tencent Cloud's <1>Business Intelligence (BI) product<1> to implement reporting services.
What are the constraints and limitations on the use of features in TencentDB for SQL Server?
To ensure the stability and security of instances, TencentDB for SQL Server imposes some usage constraints. For details, please refer to Constraints and Limitations.