Pearson IT CertificationTuesday, June 9, 2026
Question of the Day for the MCTS 70-431 Exam: Implementing and Maintaining Microsoft SQL Server 2005
Q:
An error has occurred that has corrupted one of the databases on the server. The database is set to full recovery, the last full backup occurred last night, and log backups have been continuing on an hourly basis throughout the day. No differential backups are currently performed. What steps do you need to take to get the database up and running again with the least loss of data? (Choose all that apply.)
A. Restore the last full backup.

B. Restore the last differential backup.

C. Restore logs from the last full or differential backup.

D. Restore logs from the last full or differential backup by using STOPAT.

E. Perform a log backup.

F. Perform a differential backup.

G. Perform a full backup.

Click Here to Find the Answer

This question is from the book:
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam

By Thomas Moore

Buy