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. You have a database for which you generally perform only database backups. The transaction log exists on a separate physical disk from the secondary data files. It is allowed to accumulate changes but is periodically cleared. The disk that contains the secondary data files is damaged. After you replace the disk, what can you do to minimize data loss?
  2. Answer

  3. What are the advantages and disadvantages of using differential backups as part of your backup strategy?
  4. Answer



Microsoft Press - Microsoft SQL Server 7. 0 System Administration Training Kit
Microsoft SQL Server 7.0 System Administration Training Kit
ISBN: 1572318279
EAN: 2147483647
Year: 1999
Pages: 100

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net