Querying primary and standby switch logs

Recent Pages

Querying primary and standby switch logs

Last updated: 2024-01-18 17:23:30

SQL Server supports the records for primary and secondary switch logs of an instance. Through that, you can understand the specific time and switch methods of the primary and secondary switch to verify the success of the switch, and optimize switch policies.
This document decribes how to query primary and secondary switch logs.          
The steps are as follows:
1. Log in to the TencentDB for SQL Server console.
2. Select the region on the top, locate the instance that needs to query the primary and secondary switch logs, and click Instance ID or Manage in the Operation column to go to the instance management page.
﻿
3. On the instance management page, choose Operation Log > Primary/Replica Switch Log to view the list of primary and secondary switch logs.
You can view the following fields: Switch Event ID, Switch Start Time, Switch End Time, and Switch Mode (automatic switch by system, manual switch).
You can filter logs by using a time-based search.
﻿
﻿