Modifying the Recovery Mode
다운로드
포커스 모드
폰트 크기
TencentDB for SQL Server supports two database recovery models: Full and Simple. This document describes how to modify the recovery model.
SQL Server Recovery Mode Comparison
Feature | Simple Mode | Full Mode |
Transaction Log Backup | Not supported | Supported |
Point-in-Time Recovery | Not supported | Supported |
Transaction Log Management | Transaction logs are automatically truncated. | All transactions are fully logged, requiring manual log backup and truncation. |
Data Protection | Data may be lost after the last backup. | Minimized data loss |
File Size | Smaller | Relatively large, requiring periodic log backup. |
When the database recovery model is set to Full for TencentDB for SQL Server, all transactions are logged completely, transaction log backup is supported, and point-in-time recovery is supported to prevent data loss. We recommend that you use the Full model.
Note
This feature only supports changing the recovery model from Simple to Full for single-node instances.
When the recovery model is Simple, the database is not available for rollback to a specified time point.
Recovery Mode Display
You can view the recovery model of databases under an instance on the database management page of the console.
Operation Steps
Modifying the Recovery Mode for a Single Database
1. Log in to the TencentDB for SQL Server console and click Instance ID or Manage in the Operation column in the instance list to enter the instance management page.
2. On the instance management page, select the Database Management page, select the row where the target database resides, and then choose Others > Modify recovery model in the Operation column.
3. In the pop-up window, set the recovery model and click OK.
Batch Modification of Recovery Modes
1. Log in to the TencentDB for SQL Server console and click Instance ID or Manage in the Operation column in the instance list to enter the instance management page.
2. On the instance management page, select the Database Management page.
3. Select multiple databases in the list, and then choose Batch Management > Batch modify recovery model above.
4. In the pop-up window, set the recovery model and click OK.
피드백