Explanation:log_reuse_wait value 0 indicates currently there are one or more reusable virtual log files. 4. ACTIVE_TRANSACTION has log_reuse_wait value :
A. 1
B. 2
C. 3
D. 4
Answer:A
Explanation:log_reuse_wait value 0 indicates currently there are one or more reusable virtual log files. 4. ACTIVE_TRANSACTION has log_reuse_wait value :
A. 1 B. 2 C. 3 D. 4
Explanation:A long-running transaction might exist at the start of the log backup. In this case, freeing the space might require another log backup. 5. Point out the wrong statement :