Does TencentDB for SQL Server support manual active-standby switching?
TencentDB for SQL Server Dual-node Cloud Disk Edition supports manual active-standby switching. For details, please refer to Manual Active-Standby Switching. Dual-node Local Disk architecture does not support manual active-standby switching from the console. If you need manual active-standby switching, please Submit Ticket for assistance.
Can TencentDB for SQL Server currently access other heterogeneous databases?
Currently, TencentDB for SQL Server does not support accessing other heterogeneous databases from cloud SQL Server.
Does TencentDB for SQL Server support BULK INSERT or other data imports?
Currently, TencentDB for SQL Server does not support BULK INSERT or other data imports.
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 security system vulnerabilities on its servers?
Currently, TencentDB for SQL Server does not support scanning security system vulnerabilities on its servers.
Can TencentDB for SQL Server use maintenance plans?
Currently, TencentDB for SQL Server does not support using maintenance plans. Maintenance plans generate additional packages and JOBs. This process can be executed by directly creating a JOB to run SQL.
Can I create folders on the server in TencentDB for SQL Server?
TencentDB for SQL Server does not support creating folders within the database server.
How do I enable or disable Change Data Capture (CDC) in TencentDB for SQL Server?
Change Data Capture (CDC) captures insert, update, and delete activities applied to SQL Server tables and provides the details of these changes in a user-friendly relational format. For details on how to enable or disable CDC, see Change Data Capture (CDC).
How do I enable or disable Change Tracking (CT) in TencentDB for SQL Server?
Change Tracking (CT) can be applied to track specific tables or even columns within a database. When a user performs an add, modify, or delete operation 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. For details on how to enable or disable CT, see Change Tracking (CT).
How do I shrink a database in TencentDB for SQL Server?
How many databases can a single instance of TencentDB for SQL Server create?
From a performance perspective, having too many databases in TencentDB for SQL Server can lead to a decline in instance performance, occupy Worker Thread resources, and exceed the limit for the number of databases, potentially causing primary-secondary synchronization anomalies. It is recommended not to exceed the maximum limit of databases per instance. The number of databases an instance can support is related to the instance CPU cores. For detailed formulas on the maximum number of databases per version, refer to Database Quantity.
Is there a limit on the number of tables in a single instance of TencentDB for SQL Server?
The number of tables in a single instance of TencentDB for SQL Server is theoretically unlimited. However, having more than 1 million tables may affect database performance. It is recommended to keep the number of tables in a single instance under 1 million.
Where are the databases created in TencentDB for SQL Server stored?
Log in to the SQL Server SSMS client. After connecting to the instance, right-click on the database properties to view the database file location.
Does TencentDB for SQL Server support Reporting Services?
Currently, TencentDB for SQL Server does not support Reporting Services. If needed, you can use Tencent Cloud's Business Intelligence (BI) Products to achieve reporting services.
What are the constraints and limitations on using features in TencentDB for SQL Server?
To ensure the stability and security of instances, TencentDB for SQL Server imposes certain use constraints. For more details, please refer to Constraints and Limits.