Drag and Drop Question You have a database named db1. The log for db1 contains the following entry. You need to ensure that db1 can process transactions. Which three actions should you perform in sequ

The correct answer is Remove db1 from the availability group.; Back up the transaction log file.; Add db1 back to the availability group.. When a database in an Always On Availability Group has a transaction log that cannot be backed up normally (typically shown by a log_reuse_wait_desc of 'AVAILABILITY_REPLICA'), you must first remove the database from the availability group to break the synchronization dependency,

Submitted by tom_us· Mar 6, 2026Manage and maintain SQL Server databases, including high availability configurations and transaction log management, corresponding to Microsoft SQL Server DBA certification objectives around Always On Availability Groups and database recovery models.

Question

Drag and Drop Question You have a database named db1. The log for db1 contains the following entry. You need to ensure that db1 can process transactions. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:

Exhibits

Answer Area

Drag items

Back up the transaction log file.Remove db1 from the availability group.Shrink the transaction log file.Shrink db1.Add db1 back to the availability group.

Correct arrangement

Remove db1 from the availability group.
Back up the transaction log file.
Add db1 back to the availability group.

Explanation

When a database in an Always On Availability Group has a transaction log that cannot be backed up normally (typically shown by a log_reuse_wait_desc of 'AVAILABILITY_REPLICA'), you must first remove the database from the availability group to break the synchronization dependency, then back up the transaction log to truncate it and free space, and finally re-add the database to the availability group to restore high availability. This sequence resolves the log space issue while maintaining data integrity and restoring the AG configuration.

Topics

#Always On Availability Groups#Transaction Log Management#SQL Server High Availability#Log Backup and Truncation

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice