Microsoft® SQL Server® 2012 Bible

527 Chapter 19: Confi guring SQL Server 19 Using T-SQL-code, you can use the following command to set the PAGE_VERIFY option for ...

528 Part V: Enterprise Data Management To set media retention to 10 days in code, do the following: EXEC sp_configure 'show adva ...

529 Chapter 19: Confi guring SQL Server 19 If you insist on changing the recovery interval option, you can either use Management ...

c19.indd 530c19.indd 530 7/30/2012 5:43:15 PM7/30/2012 5:43:15 PM http://www.it-ebooks.info ...

531 CHAPTER 20 Policy Based Management IN THIS CHAPTER Exploring Policy-Based Management Using Management Facets Defi ning Polic ...

532 Part V: Enterprise Data Management Similarly, PBM abstracts the management intent, meaning the policies, from the procedural ...

533 Chapter 20: Policy Based Management 20 ■ (^) Conditions: Defi ned by the DBA, based on one facet, are the anted states, or v ...

534 Part V: Enterprise Data Management In database design terminology, there’s a many-to-many relationship between SQL Server ob ...

535 Chapter 20: Policy Based Management 20 The last two pages are not without purpose. There may potentially be a large number o ...

536 Part V: Enterprise Data Management FIGURE 20-3 The View Facets dialog, opened from any object’s context menu, presents a bro ...

537 Chapter 20: Policy Based Management 20 FIGURE 20-4 This condition includes an expression that tests the Database Facet’s @Au ...

538 Part V: Enterprise Data Management select * from msdb.dbo.syspolicy_conditions FIGURE 20-5 Use the Advanced Edit dialog to c ...

539 Chapter 20: Policy Based Management 20 FIGURE 20-6 Viewing a Policy. This policy enforces the AutoShrink condition for every ...

540 Part V: Enterprise Data Management ■ (^) On Change — Log Only: The policy is evaluated when the facet is changed, and violat ...

541 Chapter 20: Policy Based Management 20 Facet On Demand On Schedule On Change Log Only On Change Prevent DatabaseDdlTrigger 1 ...

542 Part V: Enterprise Data Management Facet On Demand On Schedule On Change Log Only On Change Prevent IUserOptions 1 1 1 1 IVi ...

543 Chapter 20: Policy Based Management 20 Facet On Demand On Schedule On Change Log Only On Change Prevent UserDefi nedDataType ...

544 Part V: Enterprise Data Management You can see the current state of any object for all policies regardless of their Executio ...

545 Chapter 20: Policy Based Management 20 FIGURE 20-8 Here the Aesop database passes the No AutoShrinkage policy and declares t ...

c20.indd 546c20.indd 546 7/30/2012 5:45:21 PM7/30/2012 5:45:21 PM http://www.it-ebooks.info ...