tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TencentDB for SQL Server
    Documentation
    Download PDF

    Overview

    Last updated: 2024-01-18 17:25:32
    Download PDF
      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?
      Will idle pay-as-you-go instances be billed?
      How is the TencentDB for SQL Server backup space 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?
      How do I set the instance maintenance information in TencentDB for SQL Server?
      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)?
      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?
      Does TencentDB for SQL Server support MSDTC?
      Does TencentDB for SQL Server support MSDTC from a self-built IDC to the cloud?
      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?
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy