tailieunhanh - Microsoft Press Configuring sql server 2005 môn 70 - 431 phần 8

Làm thế nào để bạn khởi chạy System Monitor? 2. Đối với mục đích gì làm bạn sử dụng System Monitor? Nhanh chóng Kiểm tra câu trả lời Giám sát và khắc phục sự cố Hiệu suất SQL Server | 650 Chapter 17 Review Take a Practice Test The practice tests on this book s companion CD offer many options. For example you can test yourself on just the content covered in this chapter or you can test yourself on all the 70-431 certification exam content. You can set up the test so that it closely simulates the experience of taking a certification exam or you can set it up in study mode so that you can look at the correct answers and explanations after you answer each question. MORE INFO Practice tests For details about all the practice test options available see the How to Use the Practice Tests section in this book s Introduction. Chapter 18 Implementing Log Shipping Log shipping is the automated process of backing up copying and restoring the transaction log from one database on a primary server to one or more secondary databases on another server. Using log shipping you can frequently synchronize the copy of the database with the original so you can use the copy to distribute query processing for improved performance or as a warm standby database for high availability. This chapter will explain log shipping s components processes and requirements. It then will show you how to configure the primary and secondary databases the various log shipping options and the optional monitor server for optimal operations. Exam objectives in this chapter Implement log shipping. Initialize a secondary database. Configure log shipping options. Configure a log shipping mode. Configure monitoring. Lessons in this chapter Lesson 1 Preparing to Log Lesson 2 Configuring Log Shipping Lesson 3 Configuring Log Shipping Lesson 4 Configuring Before You Begin To complete the lessons in this chapter you must have A computer that meets the hardware and software requirements for Microsoft SQL Server 2005. SQL Server 2005 Developer Workgroup Standard or Enterprise Edition installed. SQL Server Agent running and configured with a Microsoft .