tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P77

Microsoft SQL Server 2008 R2 Unleashed- P77:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 704 CHAPTER 22 Administering Policy-Based Management FIGURE The Evaluation Results pane. Importing a policy from an XML file is just as simple. Follow these steps to import a policy with SQL Server Management Studio 1. In Object Explorer expand the Management folder expand the Policy Management node and then select Policies. 2. Right-click on the Policies folder and select Import. 3. The import screen has three options you need to be aware of a. First provide the path of the file to import. b. Second enable the option Replace Duplicate Items When Imported. c. Finally in the Policy State drop-down box specify the state of the policy being imported. The options include Preserve Policy State on Import Enable All Policies on Import and Disable All Policies on Import. Sample Templates and Real-World Examples The following sections illustrate the sample policy templates included with SQL Server 2008 and real-world examples for using Policy-Based Management. Sample Policy Templates SQL Server 2008 includes a plethora of predefined sample policies which can be leveraged by importing them into a SQL Server 2008 system. The policies available for import are located in the default installation drive at C Program Files Microsoft SQL Download from Sample Templates and Real-World Examples 705 Server 100 Tools Policies. As mentioned earlier you can import the desired policies by right-clicking the Policies node and selecting Import. The sample templates are categorized by SQL Server feature such as Database Engine Reporting Services and Analysis Services. Evaluating Recovery Models Recovery models determine how SQL Server uses the transaction log. On OLTP systems the most appropriate recovery model is generally the Full Recovery model. For OLAP systems the most appropriate recovery model is generally the simple recovery model. For most development environments the most appropriate recovery model is also the simple recovery model. For mission-critical .