TencentDB for SQL Server
- Release Notes and Announcements
- Announcements
- Product Introduction
- Product Architecture
- Instance Specifications
- Purchase Guide
- Product Pricing
- Getting Started
- Connecting to TencentDB for SQL Server Instance
- Operation Guide
- Maintaining Instance
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Access Management
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Backup
- Setting Automatic Backup
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Using DTS to Migrate Data
- Pre-Validation Failure Handling
- Data Migration (Legacy)
- Migrating Data from SQL Server Instance Purchased at Other Cloud Service Provider or Built In-house
- Practical Tutorial
- API Documentation
- Sales and fee related APIs
- Operation and maintenance management 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
- Data migration (cold standby migration) related APIs
- Data migration (DTS old version) related APIs
- Making API Requests
- Database APIs
- Other APIs
- FAQs
- Service Agreement
- Performance Evaluation
Restarting Instance
Last updated: 2024-08-14 10:10:24
This document describes how to restart an instance in the console.
Scenario
Instance restart is a common maintenance method for TencentDB for SQL Server. It is similar to restarting a local database.
Instructions for Sensitive Operations with MFA Integrated
To enhance the security of the cloud account, TencentDB for SQL Server supports MFA (Multi-Factor Authentication), which brings an extra layer of protection in addition to the username and password. After the MFA device verification is enabled, when you perform operations such as destroying instances/changing network/modifying IP addresses/resetting passwords/deleting accounts/resetting instances/performing primary-replica switch, a second identity verification based on the MFA dynamic code will be conducted. Such operations can be executed only after successful verification. For an introduction to MFA and how to enable the operation protection, see MFA Devices.
Limits
During the restart, the TencentDB for SQL Server instance cannot provide services. Therefore, make sure that an instance has stopped accepting business requests before restarting it. During the restart, if the business write volume is high, the restart may fail.
Restarting an instance does not change its physical attributes, so the private IP and any data stored in the instance will remain unchanged.
After the restart, reconnection to the database is needed. Make sure your business has a reconnection mechanism.
Restart the instance during off-peak hours to ensure success and minimize the impact on your business.
Directions
1. Log in to the TencentDB for SQL Server console.
2. Select a region at the top, select one or multiple instances to be restarted, and click Restart at the top.
3. In the pop-up window, confirm the selected instances and click OK.
4. Once the instance status changes from Restarting to Running, the restart is completed.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No