Review

[Previous] [Next]

The following questions are intended to reinforce key information presented in the chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. Answers to the questions can be found in Appendix A, "Questions and Answers."

1. What is the automatic recovery process, and when is it initiated?

Answer

2. What steps should you take before you restore a database?

Answer

3. You have a complete database backup and several transaction log backups. Your database is spread among four files. The disk on which the third file resides fails. What should you do to restore and recover the database?

Answer

4. You have a complete database backup and several transaction log backups. A malicious update to the database occurs at 9:21 a.m. The time is now 9:30 a.m. What should you do to restore and recover the database to a consistent state?

Answer

5. In the scenario presented in question 4, will any changes be lost due to the restore process?

Answer

6. You have set up a standby SQL Server that functions as a read-only server. What must you do to replace the production server with this standby SQL Server?

Answer