TAILIEUCHUNG - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P62

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P62: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Maintaining Your Database Chapter 7 287 The configuration of maintenance plans is stored in MSDB also. Again you must back up MSDB to avoid the risk of losing your maintenance plan configuration. To configure Maintenance Plans expand Management right-click Maintenance Plans and then click Maintenance Plan Wizard. To view the execution history of a particular maintenance plan right-click on it in the Object Browser then click View History. Policy-Based Management Many database administrators work for large organizations that keep many SQL Servers for example a customer organization that maintains over 50 SQL Servers in different locations. As you can imagine it is difficult to report on and apply configuration changes to that many servers individually. Keeping the configuration standardized becomes a laborious task and with individual management mistakes are inevitable. This is why the Policy-Based Management feature has been introduced in SQL Server 2008. Policy-Based Management allows you to view and configure settings on multiple instances of SQL Server 2008. Using Policy-Based Management you can apply a configuration change to a group of servers with one administrative action. Furthermore Policy-Based Management allows you to enforce standards on your SQL Server for example object naming standards. This is known as Explicit Administration. SQL Server Management Studio provides PolicyBased Management wizards. These are accessible from the Object Browser under Management Policy Management. Let s examine the key components of Policy-Based Management and how they relate to each other Managed targets are the objects you will be managing with Policy-Based Management. Instances of SQL Server databases tables indexes and other database objects can be targeted for Policy-Based Management. Targets are presented in a logical hierarchy. You can create target sets by filtering all managed targets using a filter criterion for example all database names starting with MOSS_ or

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• thiết kế CSDL quan hệ
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản