- Release Notes and Announcements
- Release Notes
- Announcements
- Announcement on Changing External Network Links
- Interface Authentication Upgrade Announcement
- Maintenance Time Change from Local Time to Beijing Time
- Account Type and Permission Changes
- Product Architecture Name Change
- Disk Storage Space Composition Change
- Ending Support for Classic Network [2022.12.31]
- Backup Billing Start [2022.07.10]
- Ending Sale for Basic Edition 1-Core Specification [2022.03.07]
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Constraints and Limits
- Usage Specifications and Suggestions
- Maintaining Instance
- Renaming Instance
- Setting Instance Remarks
- Setting Instance Tag
- Setting Instance Project
- Modify Instance-level Character Set Collation
- Modify System Time Zone
- Setting Instance Maintenance Information
- Multi-AZ Disaster Recovery
- Restarting Instance
- Terminating Instance
- Migrating Across AZs
- Manual Primary-Secondary Switching
- Recycle Bin
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Data Migration (Legacy)
- Practical Tutorial
- API Documentation
- History
- Introduction
- API Category
- Sales and fee related APIs
- Network management related APIs
- Account management related APIs
- Instance Management APIs
- Data security encryption related APIs
- Parameter configuration related APIs
- Log management related APIs
- Extended Event APIs
- Read only instance management related APIs
- Backup APIs
- Rollback APIs
- Data migration (cold standby migration) related APIs
- CreateBackupMigration
- ModifyBackupMigration
- StartBackupMigration
- DescribeBackupMigration
- DeleteBackupMigration
- DescribeUploadBackupInfo
- CreateIncrementalMigration
- ModifyIncrementalMigration
- StartIncrementalMigration
- DescribeIncrementalMigration
- DescribeBackupCommand
- DescribeBackupUploadSize
- DeleteIncrementalMigration
- Data migration (DTS old version) related APIs
- Making API Requests
- Database APIs
- Other APIs
- Data Types
- Error Codes
- FAQs
- Overview
- Model Selection
- Pricing and Selection
- Connection and Network
- Account and Permission
- Backup and Rollback
- Data Migration
- Publish/Subscribe
- Read-Only Instance
- Version and Architecture Upgrade
- Disk Space and Specification Adjustment
- Monitoring and Alarms
- Log
- Parameter Modification
- Features
- Performance/Space/Memory
- Service Agreement
- Performance Evaluation
- Glossary
- Contact Us
- Release Notes and Announcements
- Release Notes
- Announcements
- Announcement on Changing External Network Links
- Interface Authentication Upgrade Announcement
- Maintenance Time Change from Local Time to Beijing Time
- Account Type and Permission Changes
- Product Architecture Name Change
- Disk Storage Space Composition Change
- Ending Support for Classic Network [2022.12.31]
- Backup Billing Start [2022.07.10]
- Ending Sale for Basic Edition 1-Core Specification [2022.03.07]
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Constraints and Limits
- Usage Specifications and Suggestions
- Maintaining Instance
- Renaming Instance
- Setting Instance Remarks
- Setting Instance Tag
- Setting Instance Project
- Modify Instance-level Character Set Collation
- Modify System Time Zone
- Setting Instance Maintenance Information
- Multi-AZ Disaster Recovery
- Restarting Instance
- Terminating Instance
- Migrating Across AZs
- Manual Primary-Secondary Switching
- Recycle Bin
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Data Migration (Legacy)
- Practical Tutorial
- API Documentation
- History
- Introduction
- API Category
- Sales and fee related APIs
- Network management related APIs
- Account management related APIs
- Instance Management APIs
- Data security encryption related APIs
- Parameter configuration related APIs
- Log management related APIs
- Extended Event APIs
- Read only instance management related APIs
- Backup APIs
- Rollback APIs
- Data migration (cold standby migration) related APIs
- CreateBackupMigration
- ModifyBackupMigration
- StartBackupMigration
- DescribeBackupMigration
- DeleteBackupMigration
- DescribeUploadBackupInfo
- CreateIncrementalMigration
- ModifyIncrementalMigration
- StartIncrementalMigration
- DescribeIncrementalMigration
- DescribeBackupCommand
- DescribeBackupUploadSize
- DeleteIncrementalMigration
- Data migration (DTS old version) related APIs
- Making API Requests
- Database APIs
- Other APIs
- Data Types
- Error Codes
- FAQs
- Overview
- Model Selection
- Pricing and Selection
- Connection and Network
- Account and Permission
- Backup and Rollback
- Data Migration
- Publish/Subscribe
- Read-Only Instance
- Version and Architecture Upgrade
- Disk Space and Specification Adjustment
- Monitoring and Alarms
- Log
- Parameter Modification
- Features
- Performance/Space/Memory
- Service Agreement
- Performance Evaluation
- Glossary
- Contact Us
Does TencentDB for SQL Server support manual primary-replica switchover?
TencentDB for SQL Server two-node cloud disk architecture supports manual primary-replica switchover. For specific operations, please refer to Manual Primary-Replica Switchover. The two-node local disk architecture does not support initiating manual primary-replica switchover from the console. If you need to perform manual primary-replica switchover, please 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?
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.
Yes
No
Was this page helpful?