Microsoft SQL Server 7.0 System Administration Training Kit

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. Your database consists of 5 gigabytes (GB) of data and is stored in one database file. This database is used as an order-taking system for a mail-order catalog company. Operators take orders 24 hours a day. The company typically receives about 2000 orders each day. Describe an appropriate backup plan for this database.

Answer

2. Your database contains image data that is gathered from a weather satellite and is continually being updated. The database is 700 GB. Each table exists in a separate filegroup in the database. If you were to perform a database backup, the process would take about 20 hours. How can you minimize the amount of time that is spent performing backups each day and still ensure good data recoverability in case of a system failure?

Answer