Review

3 4

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."

1. You regularly perform full, differential, and transaction log backups to disk. Are there any other backup tasks that you should perform regularly to protect your database from data loss?
2. You are a new database administrator. You want to create Transact-SQL scripts to automate the backup of your database. However, the syntax is imposing. What are several good methods for familiarizing yourself with the Transact-SQL syntax and the various backup options?
3. What is a major advantage to using SQL Server Enterprise Manager for performing database restorations, rather than Transact-SQL?
4. What is the major difference between performing a restoration of the master database and all other databases?

Answers