Database Fundamentals — Question 145

What is the ideal time to back up dynamic log files?

Answer options

• A. When the server is running.
• B. You can back up dynamic log files any time.
• C. When the server is stopped.
• D. When the server is shut down.

Correct answer: C

Explanation

The correct answer is C because backing up dynamic log files should be done when the server is stopped to ensure data integrity and consistency. Options A and B are incorrect as backing up while the server is running may lead to incomplete or corrupted backups. Option D is also incorrect as it implies a total shutdown rather than stopping the server properly.