Overview

Last updated: 2025-11-24 20:15:25
Overview
Last updated: 2025-11-24 20:15:25
This document lists the FAQs of TencentDB for SQL Server.
Note: 
This document lists many questions. You can use the search box or press Ctrl+F to search with keywords. If your question is not listed here, submit a ticket for assistance.
Model selection
﻿How do I select an appropriate architecture of TencentDB for SQL Server?﻿
﻿How do I select an appropriate TencentDB for SQL Server architecture and edition if my business requires read-only instances?﻿
﻿How is the performance of TencentDB for SQL Server?﻿
﻿Which specifications does TencentDB for SQL Server support?﻿
﻿How do I select an appropriate TencentDB for SQL Server instance specification?﻿
﻿In which regions is TencentDB for SQL Server available?﻿
﻿Which versions does TencentDB for SQL Server support?﻿
﻿How is the version compatibility of TencentDB for SQL Server?﻿
﻿What features does TencentDB for SQL Server offer?﻿
﻿What are the feature differences between different TencentDB for SQL Server editions?﻿
﻿How many databases can I create at most in a TencentDB for SQL Server instance?﻿
﻿Does TencentDB for SQL Server support real-time hot backup?﻿
﻿What are the use cases of TencentDB for SQL Server?﻿
﻿What high availability and disaster recovery capabilities does TencentDB for SQL Server have?﻿
﻿What strengths does TencentDB for SQL Server have?﻿
﻿What strengths does TencentDB for SQL Server have over self-built SQL Server?﻿
﻿How do I migrate data to TencentDB for SQL Server?﻿
Billing and purchase
﻿How is TencentDB for SQL Server prices?﻿
﻿How do I purchase a TencentDB for SQL Server instance?﻿
﻿Do I need to purchase SQL Server licenses by myself?﻿
﻿Does TencentDB for SQL Server provide official Microsoft licenses?﻿
﻿How do I renew a TencentDB for SQL Server instance?﻿
﻿How do I apply for a refund if I purchased an instance in a wrong region?﻿
﻿What should I do if my TencentDB for SQL Server instance expires or has overdue payments?﻿
﻿What are the differences between the two billing modes, monthly subscription and pay-as-you-go?﻿
﻿Can the two billing modes, monthly subscription and pay-as-you-go, be converted from one to the other?﻿
﻿Converts a pay-as-you-go TencentDB for SQL Server instance to a monthly subscription mode. What impact does this have on the business, and how is it billed?﻿
﻿Are there any differences in the features supported by the two billing modes, monthly subscription and pay-as-you-go?﻿
﻿Will idle pay-as-you-go instances be billed?﻿
﻿What should I do if there aren't enough TencentDB for SQL Server instances in stock in an AZ?﻿
How do I view bills of TencentDB for SQL Server?
﻿How do I terminate a TencentDB for SQL Server instance?﻿
﻿Can I restore a terminated TencentDB for SQL Server instance?﻿
﻿Can I interconnect TencentDB for SQL Server instances in different AZs in the same region over the private network?﻿
﻿Can I interconnect a CVM instance and a TencentDB for SQL Server instance in different AZs in the same region? How long will be the latency?﻿
﻿Can I change the region of a TencentDB for SQL Server instance?﻿
﻿Can I change the AZ of a TencentDB for SQL Server instance?﻿
﻿Should I select single-AZ or multi-AZ deployment for a TencentDB for SQL Server Dual-Server High Availability Edition instance?﻿
﻿How do I purchase a multi-AZ TencentDB for SQL Server instance?﻿
﻿How do I upgrade a single-AZ TencentDB for SQL Server instance to a multi-AZ instance?﻿
﻿How do I restart a TencentDB for SQL Server instance?﻿
﻿How do I view and manage TencentDB for SQL Server instances?﻿
﻿What information should I use to mark TencentDB for SQL Server resources to manage them by group?﻿
﻿What are the purposes of a TencentDB for SQL Server instance name? How do I rename an instance?﻿
﻿What are the purposes of TencentDB for SQL Server instance remarks? How do I set remarks?﻿
﻿What are the purposes of a TencentDB for SQL Server instance tag? How do I set a tag?﻿
﻿What are the purposes of a TencentDB for SQL Server instance project? How do I set a project?﻿
Connection and network
﻿How do I create an instance and connect to a database?﻿
﻿How do I connect to TencentDB for SQL Server?﻿
﻿How do I access a TencentDB for SQL Server instance from a CVM instance over the private network?﻿
﻿What should I check when interconnecting a CVM instance and a TencentDB for SQL Server instance over the private network?﻿
﻿How do I view the private network address of a TencentDB for SQL Server instance?﻿
﻿How do I access a TencentDB for SQL Server instance from a CVM instance under another Tencent Cloud root account?﻿
﻿How do I interconnect a CVM instance and a TencentDB for SQL Server instance in different regions under the same Tencent Cloud root account over the private network?﻿
﻿How do I interconnect a CVM instance and a TencentDB for SQL Server instance in different VPCs in the same region under the same Tencent Cloud root account over the private network?﻿
﻿How do I interconnect a CVM instance and a TencentDB for SQL Server instance in different types of networks in the same region under the same Tencent Cloud root account over the private network?﻿
﻿How do I interconnect a CVM instance and a TencentDB for SQL Server instance in different AZs in the same region under the same Tencent Cloud root account over the private network?﻿
﻿Can I interconnect a CVM instance and a TencentDB for SQL Server instance in different AZs in the same VPC under the same Tencent Cloud root account?﻿
﻿How do I access a TencentDB for SQL Server instance from a local server?﻿
﻿How do I connect to a TencentDB for SQL Server instance without a CVM instance?﻿
﻿How do I switch a TencentDB for SQL Server instance from VPC A to VPC B?﻿
﻿How do I switch between the classic network and VPC for a TencentDB for SQL Server instance?﻿
﻿How do I migrate a TencentDB for SQL Server instance from classic network to VPC?﻿
﻿How do I use the port mapping feature of SSH2 to connect to and manage a TencentDB for SQL Server instance from the internet?﻿
﻿Does my application need to support automatic reconnection to TencentDB for SQL Server?﻿
﻿Can I access a TencentDB for SQL Server replica instance?﻿
﻿Will a primary/replica switch affect the connection address?﻿
﻿How do I configure a security group in TencentDB for SQL Server?﻿
﻿Can I use a security group in TencentDB for SQL Server to control the classic network?﻿
﻿Can I select the SQL Server (1433) port as the type when adding an inbound rule to a security group?﻿
﻿How do I set the instance maintenance time in TencentDB for SQL Server?﻿
﻿Will TencentDB for SQL Server be disconnected during the maintenance?﻿
﻿Why can't I connect to TencentDB for SQL Server?﻿
﻿What should I do If I fail to connect to TencentDB for SQL Server?﻿
Account and permission
﻿How do I manage the account of a TencentDB for SQL Server instance?﻿
﻿How do I manage TencentDB for SQL Server databases?﻿
﻿How do I create an account in TencentDB for SQL Server?﻿
﻿How do I delete an account in TencentDB for SQL Server?﻿
﻿How do I modify account permissions in TencentDB for SQL Server?﻿
﻿How do I create a database in TencentDB for SQL Server?﻿
﻿How do I delete a database in TencentDB for SQL Server?﻿
﻿How do I modify database permissions in TencentDB for SQL Server?﻿
﻿What should I do if the system prompts "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication" when I try to manage databases with SSMS?﻿
﻿Does TencentDB for SQL Server support assigning the sysadmin role to users?﻿
﻿How do I create an account with SA permissions in TencentDB for SQL Server?﻿
﻿Can I connect to TencentDB for SQL Server with a Windows system account?﻿
﻿What should I do if I forgot the login password of TencentDB for SQL Server?﻿
﻿How do I reset the password of TencentDB for SQL Server?﻿
﻿Why can't I create databases/tables?﻿
﻿Why do I lack permissions to modify database parameters such as blocked process threshold(s)?blocked process threshold(s)?﻿
﻿Can I have the permission to access and create folders on the server in TencentDB for SQL Server?﻿
﻿Can I view connection details in TencentDB for SQL Server?﻿
﻿Can I view the slow SQL table in TencentDB for SQL Server?﻿
﻿Can I have the SQL trace permission in TencentDB for SQL Server?﻿
﻿Why does the system prompt that I don't have the permission to enable Profiler in TencentDB for SQL Server?﻿
﻿Can I use accounts created in the primary instance in read-only instances?﻿
﻿Will permissions be synced to replica instances and read-only instances automatically after an account in the primary instance is deleted and created again?﻿
﻿How do I sync account permissions on Dual-Server High Availability/Cluster Edition primary and replica instances to read-only instances?﻿
﻿Can I manage database accounts at a finer granularity (such as source address and access table)?﻿
﻿Which account permissions are granted by default in TencentDB for SQL Server?﻿
Backup and rollback
﻿How do I back up TencentDB for SQL Server?﻿
﻿How do I configure automatic backup?﻿
﻿How do I create a backup manually?﻿
﻿How do I view and modify backup policies?﻿
﻿How long can TencentDB for SQL Server retain a backup?﻿
﻿Can I delete a backup manually?﻿
﻿Can I disable data and log backups?﻿
﻿Why can't I initiate a manual backup task?﻿
﻿How do I cancel a backup task?﻿
﻿Is a database available during the backup time period?﻿
﻿How do I back up individual databases in TencentDB for SQL Server?﻿
﻿How do I set to perform a backup task on the replica instance in TencentDB for SQL Server?﻿
﻿How do I download backup files of TencentDB for SQL Server?﻿
﻿Can I use a third-party tool to automatically back up TencentDB for SQL Server?﻿
﻿Can I download or restore backup files that exceed the retention period?﻿
﻿Can I download the backup files of an isolated instance?﻿
﻿Will backup files still be retained after a TencentDB for SQL Server instance is deleted?﻿
﻿How is the TencentDB for SQL Server backup space billed?﻿
﻿What should I do if the free tier of the backup space is exceeded?﻿
﻿How do I reduce backup space costs in TencentDB for SQL Server?﻿
﻿How do I view the backup space usage of TencentDB for SQL Server?﻿
﻿How do I roll back a TencentDB for SQL Server instance?﻿
﻿How do I clone a database in a TencentDB for SQL Server instance?﻿
﻿What can I do with downloaded data and log backups?﻿
﻿Can I restore a downloaded backup to another TencentDB for SQL Server instance?﻿
﻿How do I restore a backup of a self-built database to TencentDB for SQL Server?﻿
﻿Can I restore a full backup of TencentDB for SQL Server to a self-built database?﻿
﻿What are the differences between direct backup upload and backup download from COS in cold backup migration?﻿
﻿If I directly upload a backup file in cold backup migration, will the file use my backup space?﻿
Data migration
﻿How do I migrate data to TencentDB for SQL Server?﻿
﻿How do I migrate a self-built SQL Server database in my local IDC to TencentDB for SQL Server?﻿
﻿How do I restore a backup of a self-built database to TencentDB for SQL Server?﻿
﻿I have purchased a TencentDB for SQL Server instance. How do I restore a local .bak file to it?﻿
﻿How do I migrate a self-built SQL Server database in a CVM instance to TencentDB for SQL Server?﻿
﻿How do I migrate a self-built SQL Server database in another cloud vendor to TencentDB for SQL Server?﻿
﻿How do I migrate a cloud SQL Server instance in another cloud vendor to TencentDB for SQL Server?﻿
﻿How do I migrate a TencentDB for SQL Server two-node (formerly High Availability/Cluster Edition) instance to a single-node (formerly Basic Edition) instance?﻿
﻿How do I migrate a TencentDB for SQL Server single-node (formerly Basic Edition) instance to a two-node (formerly High Availability/Cluster Edition) instance?﻿
﻿How do I migrate a TencentDB for SQL Server two-node (formerly High Availability/Cluster Edition) instance to another two-node (formerly High Availability/Cluster Edition) instance?﻿
﻿Does TencentDB for SQL Server support cross-account migration?﻿
﻿Does TencentDB for SQL Server support heterogeneous migration?﻿
﻿Does TencentDB for SQL Server support data sync with a self-built database?﻿
﻿How do I connect Kingdee K/3 WISE to TencentDB for SQL Server?﻿
﻿What should I check before using DTS for data migration to the cloud?﻿
﻿What should I check when using DTS for data migration to the cloud?﻿
﻿What should I check after using DTS for data migration to the cloud?﻿
Publish/Subscribe
﻿Does TencentDB for SQL Server support publish/subscribe?﻿
﻿Does a TencentDB for SQL Server single-node (formerly Basic Edition) instance support publish/subscribe?﻿
﻿How do I implement publish/subscribe between a self-built SQL Server database in my local IDC and a TencentDB for SQL Server instance?﻿
﻿What are the use cases of the publish/subscribe feature of TencentDB for SQL Server?﻿
﻿What are the prerequisites for using the publish/subscribe feature of TencentDB for SQL Server?﻿
﻿How do I create a publish/subscribe task in TencentDB for SQL Server?﻿
﻿How do I delete the publish/subscribe relationship between two TencentDB for SQL Server instances?﻿
Read-only instance
﻿How do I view a read-only instance in TencentDB for SQL Server?﻿
﻿Does TencentDB for SQL Server support read/write separation?﻿
﻿How do I create a read-only instance in TencentDB for SQL Server?﻿
﻿How do I create an RO group in TencentDB for SQL Server?﻿
﻿How long is the sync delay between the TencentDB for SQL Server primary and read-only instances?﻿
﻿Are there any differences between read-only instances on different versions? Which version should I choose?﻿
﻿Can I use accounts created in the primary instance in read-only instances?﻿
﻿How many read-only instances can I create for a TencentDB for SQL Server primary instance at most?﻿
﻿Does TencentDB for SQL Server support data migration to read-only instances?﻿
﻿Do TencentDB for SQL Server read-only instances support database creation/deletion?﻿
﻿Do TencentDB for SQL Server read-only instances support account creation/deletion?﻿
﻿Do TencentDB for SQL Server read-only instances support backup and rollback?﻿
﻿Do I need to enable load rebalancing after customizing weights in TencentDB for SQL Server?﻿
Version/Architecture upgrade
﻿Can I change a TencentDB for SQL Server instance from two-node architecture (formerly High Availability/Cluster Edition) to single-node architecture (formerly Basic Edition)?﻿
﻿Does TencentDB for SQL Server support version upgrade?﻿
﻿Does TencentDB for SQL Server support version downgrade?﻿
Disk space and specification adjustment
﻿Which configuration items can I adjust in TencentDB for SQL Server?﻿
﻿Can I expand/reduce the disk space of a TencentDB for SQL Server instance?﻿
﻿Can I upgrade/downgrade the CPU/memory specifications of a TencentDB for SQL Server instance?﻿
﻿Is the service still available when the specification of a TencentDB for SQL Server single-node (formerly Basic Edition) instance is changed?﻿
﻿Will the service be interrupted when the specification of a TencentDB for SQL Server two-node (formerly High Availability/Cluster Edition) instance is changed?﻿
﻿How do I perform disk space expansion/reduction and specification upgrade/downgrade in TencentDB for SQL Server?﻿
﻿How are TencentDB for SQL Server disk space expansion/reduction and specification upgrade/downgrade fees calculated?﻿
﻿Will the read-only instance configuration be upgraded automatically when the primary instance configuration is upgraded?﻿
Monitoring and alarms
﻿How do I view the monitoring data of a TencentDB for SQL Server instance?﻿
﻿Where can I view monitoring charts in TencentDB for SQL Server?﻿
﻿What monitoring metrics are supported by TencentDB for SQL Server?﻿
﻿How do I set an alarm policy for TencentDB for SQL Server?﻿
﻿How do I associate an alarm policy with an alarm object in TencentDB for SQL Server?﻿
﻿How do I set alarm notifications for TencentDB for SQL Server?﻿
﻿How do I view alarm records for TencentDB for SQL Server?﻿
﻿What is the minimum monitoring granularity in TencentDB for SQL Server?﻿
﻿Which monitoring metrics of a TencentDB for SQL Server instance should I generally care about?﻿
Log
﻿What is the slow query collection threshold in TencentDB for SQL Server?﻿
﻿Can I modify the slow query collection threshold in TencentDB for SQL Server?﻿
﻿Do slow query logs in TencentDB for SQL Server use my storage space?﻿
﻿Can I view the slow SQL table in TencentDB for SQL Server?﻿
﻿How do I analyze slow SQL queries in TencentDB for SQL Server?﻿
﻿Will transaction logs in TencentDB for SQL Server be automatically cleared?﻿
﻿Can I view audit logs in TencentDB for SQL Server?﻿
﻿Can I view error logs in TencentDB for SQL Server?﻿
﻿How do I get the error logs of TencentDB for SQL Server through commands?﻿
Parameter modification
﻿How do I modify the time zone in TencentDB for SQL Server?﻿
﻿How do I modify character sets/collations in TencentDB for SQL Server?﻿
﻿How do I modify the configuration parameters of TencentDB for SQL Server?﻿
﻿Which parameters can I modify quickly in the TencentDB for SQL Server console?﻿
﻿How do I view parameter modification logs in TencentDB for SQL Server?﻿
Features
﻿Does TencentDB for SQL Server support manual primary/replica switch?﻿
﻿Can TencentDB for SQL Server access other heterogeneous databases?﻿
﻿Does TencentDB for SQL Server support data import through commands such as BULK INSERT?BULK INSERT?﻿
﻿Does TencentDB for SQL Server support MSDTC?﻿
Does TencentDB for SQL Server support audit configuration?
﻿What encryption methods are used by TencentDB for SQL Server?﻿
﻿Can TencentDB for SQL Server automatically scan the server for security vulnerabilities?﻿
﻿Can TencentDB for SQL Server use maintenance plans?﻿
﻿Can I create a folder on a server in TencentDB for SQL Server?﻿
﻿How do I enable/disable CDC in TencentDB for SQL Server?﻿
﻿How do I enable/disable CT in TencentDB for SQL Server?﻿
﻿How do I shrink a database in TencentDB for SQL Server?﻿
﻿How many databases can I create at most in a single TencentDB for SQL Server instance on different editions?﻿
﻿Are there any limits on the number of tables in a TencentDB for SQL Server instance?﻿
﻿In what paths are databases created in TencentDB for SQL Server stored?﻿
﻿Does TencentDB for SQL Server support SSRS?﻿
﻿Are there any restrictions and limits on TencentDB for SQL Server features?﻿
Performance/Space/Memory
﻿How long does it take to create a TencentDB for SQL Server instance?﻿
﻿How many databases can I create at most in a TencentDB for SQL Server instance?﻿
﻿Does TencentDB for SQL Server limit the IOPS?﻿
﻿Why does a TencentDB for SQL Server instance have a "monitor" database?﻿
﻿How does TencentDB for SQL Server track deadlocks?﻿
﻿How do I view the memory usage of a TencentDB for SQL Server instance?﻿
﻿How do I view the memory usage of each database in a TencentDB for SQL Server instance?﻿
﻿What should I do if the memory usage metric value stays high in TencentDB for SQL Server?﻿
﻿How do I view the storage space usage of a TencentDB for SQL Server instance?﻿
﻿After a SQL Server database is created, no or only a small amount of data is written, but why does the storage space monitor show that 500 MB of space has been used?﻿
﻿Why doesn't the storage space usage decrease after data is deleted from a TencentDB for SQL Server instance?﻿
﻿What will happen after the data volume exceeds the maximum storage space of a TencentDB for SQL Server instance?﻿
﻿Why does disk overuse happen in a TencentDB for SQL Server instance?﻿
﻿What should I do if the data volume exceeds the maximum storage space of my TencentDB for SQL Server instance?﻿
﻿Can I directly expand the storage space of a TencentDB for SQL Server instance? Do I need to perform data migration? What is the impact of the expansion?﻿
﻿Can I reduce the disk space of a TencentDB for SQL Server instance?﻿
﻿What does the disk space of a TencentDB for SQL Server instance consist of?﻿
﻿How much disk space is required for DDL operations?﻿
﻿How do I view the data file size of a business database in a TencentDB for SQL Server instance?﻿
﻿How do I view the log file size and status of a business database in a TencentDB for SQL Server instance?﻿
﻿How do I view the table size in a database in a TencentDB for SQL Server instance?﻿
﻿How does TencentDB for SQL Server repossess the tablespace?﻿
﻿How do I avoid data disk space usage surges caused by massive amounts of data pushed to a TencentDB for SQL Server instance within a short time?﻿
﻿How do I solve the problem of slow queries in TencentDB for SQL Server?﻿
﻿How do I troubleshoot the problem of high CPU utilization in TencentDB for SQL Server?﻿
﻿How do I view current connections and executed SQL statements in TencentDB for SQL Server?﻿
﻿How do I analyze and solve blockage in TencentDB for SQL Server?﻿
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
Feedback
tencent cloud

Model selection

Billing and purchase

Connection and network

Account and permission

Backup and rollback

Data migration

Publish/Subscribe

Read-only instance

Version/Architecture upgrade

Disk space and specification adjustment

Monitoring and alarms

Log

Parameter modification

Features

Performance/Space/Memory
