Explanation:The transaction log also supports high availability and disaster recovery solutions. 2. Point out the correct statement :
A. The Database Engine supports two types of checkpoints
B. Long-running uncommitted transactions decrease recovery time for all types of checkpoints.
C. Log truncation deletes inactive virtual log files from the logical transaction log of a SQL Server database
D. All of the mentioned
Answer:A
Explanation:The transaction log also supports high availability and disaster recovery solutions. 2. Point out the correct statement :
A. The Database Engine supports two types of checkpoints B. Long-running uncommitted transactions decrease recovery time for all types of checkpoints. C. Log truncation deletes inactive virtual log files from the logical transaction log of a SQL Server database D. All of the mentioned
Explanation:Log truncation frees space in the log file for reuse by the transaction log. 3. Which of the log_reuse_wait_desc value has log_reuse_wait value 0 ?