Here are some questions to help you determine whether you have learned enough to move on to the next chapter. If you have difficulty answering these questions, review the material in this chapter before beginning the next chapter. The answers for these questions are located in the Appendix, "Questions and Answers."
- You are using RAID 1 for your transaction log and RAID 10 for your database. With this level of fault tolerance, why is it still critical to have a data restoration plan?
- You are developing your data recovery plan. You have tested the length of time required to perform a full database backup and determined that you can back up the entire database in six hours. You have decided to perform full database backups every night. You have also determined that you need to perform transaction log backups every 15 minutes to minimize the risk of data loss. Should you also use regular differential database backups as part of your data recovery plan?
- You are responsible for maintaining and restoring, if needed, a decision support database. Several different data sources regularly populate this database using DTS packages. What is the restoration benefit, if any, to using the Full Recovery model for this database given the substantial increase in the number and size of the transaction log backups required?