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?
  2. Answer

  3. What steps should you take before you restore a database?
  4. Answer

  5. 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?
  6. Answer

  7. 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?
  8. Answer

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

  11. 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?
  12. 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