User Guide

This document describes the common use cases and operations of TencentDB for SQL Server.
1. Basic Knowledge
If you purchase and use a TencentDB for SQL Server instance for the first time, we recommend you start with the overview and concepts of the product in the following order.
Product Overview
Architecture
Strengths
Use Cases
Common Concepts
Regions and AZs
Features and Differences
Instance Types
Primary Instance Specifications
Read-Only Instance Specifications
Storage Types
Network Environment
License Statement
Then, the use limits, specifications, and suggestions of TencentDB for SQL Server are provided to help you better use the product.
Constraints and Limits
Usage Specifications and Suggestions
2. Billing Mode
TencentDB for SQL Server has two billing modes, pay-as-you-go billing mode and monthly subscription billing mode. For more information, see Billing Overview.
For more information on product billing, see the following documents:
﻿Primary Instance Pricing﻿
﻿Read-Only Instance Pricing﻿
﻿Renewal Instructions﻿
Payment Overdue
﻿Refund Instructions﻿
﻿Converting Pay-as-You-Go to Monthly Subscription﻿
Instance Adjustment Fees Description
Backup Space Billing
Cross-Region Backup Billing
Viewing Bill Details
3. Getting Started
3.1 Purchasing a TencentDB for SQL Server instance
Before using TencentDB for SQL Server, you need to sign up for a Tencent Cloud account and purchase an instance. For more information, see Creating TencentDB for SQL Server Instance.
3.2 Connecting to a TencentDB for SQL Server instance
After purchasing a TencentDB for SQL Server instance, you can access the instance from a Windows or Linux CVM instance over the public network or private network. For more information, see Instance Connection Scenarios.
3.3 Managing a TencentDB for SQL Server instance
After creating a TencentDB for SQL Server instance, you can manage the instance in the console. For more information, see Managing TencentDB for SQL Server Instance.
4. Overview of Console Features
TencentDB for SQL Server provides an easy-to-use console to help you implement diversified features with ease, such as instance management, quick configuration adjustment, visual instance monitoring, and backup configuration and management. For more information, see the following documents.
Console Feature
Documentation
Instance management and maintenance
Renaming Instance
Setting Instance Remarks
Setting Instance Tag
Setting Instance Project
Modifying Instance-Level Character Set Collation
Modifying System Time Zone
Setting Instance Maintenance Information
Restarting Instance
Terminating Instance
Migrating Across AZs
Recycle Bin
Instance configuration adjustment
Overview
Adjusting Instance Architecture
Adjusting Instance Version
Adjusting Instance Specification
Read-only instance
Read-Only Instance Overview
Managing Read-Only Instance
﻿Read-Only Group
Replica Node Read-only﻿
Network Management
Switching from Classic Network to VPC
Changing Network (from VPC to VPC)
Enabling/Disabling Public Network Address
﻿Enabling Public Network Access Through CLB﻿
Account management
﻿Creating Account﻿
﻿Creating Admin Account
Creating Special Permission Account﻿
Resetting Password
Modifying Account Permissions
Deleting Account
Database management
Creating Database
Setting Database Permissions
Cloning Database
Deleting Database
Setting Change Data Capture (CDC)
Setting Change Tracking (CT)
Shrinking Database
Data Security
﻿Transparent Data Encryption
Seting up SSL Encryption
CAM Overview
Authorization Policy Syntax
Authorizable Resource Types
Configuring Security Group﻿
Parameter configuration
Setting Instance Parameters
Viewing Parameter Modification Log
Monitoring and alarms
Viewing Monitoring Charts
Monitoring Metrics
Setting Alarm Policies
Setting Alarm Notification
Viewing Alarm Records
Backup and rollback
Backup Overview
﻿Setting Up Regular Backup Retention
Setting Up Periodic Backup Retention﻿
Creating Manual Backup
Setting Backup Task
﻿Cross-Region Backup﻿
Viewing Backup List
Downloading Backup
Deleting Manual Backup
Viewing Backup Space
﻿Rollback Plan Overview
Rollback to Current Instance
Rollback to Existing Instance (Same Region)
Rollback to Existing Instance (Cross-region)
View Rollback Task List﻿
Log management
﻿Querying and Downloading Slow Query Log﻿
﻿Querying and Downloading Blocking and Deadlock Events
Querying Primary/Replica Switchover Log
Manually Creating Latest Blocking and Deadlock Events﻿
Publish/Subscribe
﻿Publish/Subscribe Overview﻿
﻿Managing Publish/Subscribe﻿
SQL Server Integration Services (SSIS)
SSIS Overview
Purchasing Business Intelligence Server
Creating Windows Authentication Account
Adding Flat File
﻿Interconnecting Source/Target Instances and Business Intelligence Server﻿
﻿Deploying Project﻿
Data migration (New)
Cold Backup Migration
Migrating Data with DTS
5. FAQs
The FAQs about the use of TencentDB for SQL Server are summarized to make it easier for you to find answers to common questions. For more information, see Overview.
6. Troubleshooting
If you encounter problems such as high CPU utilization, blockage, slow SQL, and deadlocks during your use of TencentDB for SQL Server, you can refer to Performance/Space/Memory for troubleshooting.
7. Feedback and Suggestions
If you have any questions or suggestions about TencentDB for SQL Server, you can send your feedback through the following channels, and we will get back to you accordingly:
If you have any questions regarding the product documentation, such as links, content, or APIs, click Send Feedback on the right of the document page.
If you encounter any problems while using the product, submit a ticket for assistance.

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

Console Feature	Documentation
Instance management and maintenance	Renaming Instance Setting Instance Remarks Setting Instance Tag Setting Instance Project Modifying Instance-Level Character Set Collation Modifying System Time Zone Setting Instance Maintenance Information Restarting Instance Terminating Instance Migrating Across AZs Recycle Bin
Instance configuration adjustment	Overview Adjusting Instance Architecture Adjusting Instance Version Adjusting Instance Specification
Read-only instance	Read-Only Instance Overview Managing Read-Only Instance Read-Only Group Replica Node Read-only
Network Management	Switching from Classic Network to VPC Changing Network (from VPC to VPC) Enabling/Disabling Public Network Address Enabling Public Network Access Through CLB
Account management	Creating Account Creating Admin Account Creating Special Permission Account Resetting Password Modifying Account Permissions Deleting Account
Database management	Creating Database Setting Database Permissions Cloning Database Deleting Database Setting Change Data Capture (CDC) Setting Change Tracking (CT) Shrinking Database
Data Security	Transparent Data Encryption Seting up SSL Encryption CAM Overview Authorization Policy Syntax Authorizable Resource Types Configuring Security Group
Parameter configuration	Setting Instance Parameters Viewing Parameter Modification Log
Monitoring and alarms	Viewing Monitoring Charts Monitoring Metrics Setting Alarm Policies Setting Alarm Notification Viewing Alarm Records
Backup and rollback	Backup Overview Setting Up Regular Backup Retention Setting Up Periodic Backup Retention Creating Manual Backup Setting Backup Task Cross-Region Backup Viewing Backup List Downloading Backup Deleting Manual Backup Viewing Backup Space Rollback Plan Overview Rollback to Current Instance Rollback to Existing Instance (Same Region) Rollback to Existing Instance (Cross-region) View Rollback Task List
Log management	Querying and Downloading Slow Query Log Querying and Downloading Blocking and Deadlock Events Querying Primary/Replica Switchover Log Manually Creating Latest Blocking and Deadlock Events
Publish/Subscribe	Publish/Subscribe Overview Managing Publish/Subscribe
SQL Server Integration Services (SSIS)	SSIS Overview Purchasing Business Intelligence Server Creating Windows Authentication Account Adding Flat File Interconnecting Source/Target Instances and Business Intelligence Server Deploying Project
Data migration (New)	Cold Backup Migration Migrating Data with DTS

tencent cloud

New User Offers

Next-Generation CDN：EdgeOne

Elasticsearch Service free trial

Free Tier

Tencent Cloud Startup Program

Special Offers

Lighthouse Special Offers

Cloud Object Storage Special Offers

Featured Products

New Products

Education

Tencent Cloud Online Education Solutions

Gaming

Gaming Solution

Game Media Solutions

E-commerce

E-commerce retail solutions

Audio & Video

Audio/Video Solution

LVB Recording Solution

Interactive Classroom Solution

Interactive Live Streaming Solution

Audio Chat Social Networking Solution

Financial Services

Financial Services Solution

Compute

Cloud Virtual Machine

Auto Scaling

Batch Compute

CVM Dedicated Host

Database

TencentDB for MySQL

TencentDB for Redis®

TencentDB for CTSDB

TDSQL for MySQL

Data Transfer Service

TencentDB for MongoDB

TencentDB for PostgreSQL

TencentDB for SQL Server

TencentDB for TcaplusDB

Video Service

Cloud Streaming Services

Video on Demand

Media Processing Service

Cloud Application Rendering

Cloud Contact Center

Game Multimedia Engine

Chat

Real-time Communication

Tencent Effect SDK

AI and Machine Learning

Image Creation Large Model

Face Fusion

eKYC

Optical Character Recognition

Video Creation Large Model

Industry Applications

Tencent HealthCare Omics Platform

Container and Middleware

TDMQ for CKafka

Serverless Cloud Function

Tencent Kubernetes Engine

Tencent Kubernetes Engine for Serverless

Networking

Cloud Load Balancer

Virtual Private Cloud

Direct Connect

Cloud Connect Network

NAT Gateway

VPN Connection

Bandwidth Package

Anycast Internet Acceleration

Elastic Network Interface

Flow Logs

Global Application Acceleration Platform

Security

Captcha

Cloud Workload Protection Platform

Data Security Governance Center