教學課程:使用原則式管理來管理伺服器Tutorial: Administering Servers by Using Policy-Based Management

適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

歡迎使用「使用以原則為基礎的管理原則來管理伺服器」教學課程。Welcome to the Administering Servers by Using Policy-Based Management Policies tutorial. 本教學課程的主要對象是熟悉 SQL ServerSQL Server 但剛接觸以原則為基礎之管理的使用者。This tutorial is intended for users who are familiar with SQL ServerSQL Server but new to the Policy-Based Management.

學習內容What You Will Learn

這個教學課程會建立管理伺服器的原則以及套用至單一資料庫的原則。This tutorial creates a policy to administer your server and a policy that applies to a single database. 其中一項原則會視需要執行,以便測試是否符合。One policy is run on demand to test for compliance. 另一項原則會強制執行未來的符合。The other policy enforces future compliance.

這個教學課程分成兩個課程:This tutorial is divided into two lessons:

第 1 課:建立和套用預設關閉原則Lesson 1: Create and Apply an Off By Default Policy
這個課程會建立指定不要在伺服器上啟用 Database Mail 的原則。This lesson creates a policy that specifies that Database Mail is not enabled on the server. 然後,它會檢查伺服器是否符合此原則,並且透過停用 Database Mail,設定伺服器。Then, it checks to see whether your server complies with the policy, and configures the server by disabling Database Mail.

第 2 課:建立和套用命名標準原則Lesson 2: Create and Apply a Naming Standards Policy
這個課程會建立針對資料表定義並強制執行命名標準的原則。This lesson creates a policy that defines and enforces a naming standard for tables.

需求Requirements

這個課程需要基本資料庫知識以及 SQL Server Management StudioSQL Server Management Studio的基本了解。This lesson requires basic database knowledge and a basic understanding of SQL Server Management StudioSQL Server Management Studio.

若要使用這個教學課程,您的系統必須已安裝 SQL Server Management StudioSQL Server Management StudioTo use this tutorial, your system must have SQL Server Management StudioSQL Server Management Studio installed.

開始教學課程Start the Tutorial

第 1 課:建立和套用預設關閉原則Lesson 1: Create and Apply an Off By Default Policy

另請參閱See Also

使用原則式管理來管理伺服器Administer Servers by Using Policy-Based Management