將整個企業的管理自動化Automated Administration Across an Enterprise

將多個 SQL ServerSQL Server 執行個體之間的管理自動化,稱為「多伺服器管理」 (Multiserver Administration)。Automating administration across multiple instances of SQL ServerSQL Server is called multiserver administration. 使用多伺服器管理,可進行以下工作:Use multiserver administration to do the following:

  • 管理二或多部伺服器。Manage two or more servers.

  • 為企業伺服器之間的資訊流程進行排程以作為資料倉儲之用。Schedule information flows between enterprise servers for data warehousing.

注意

MicrosoftMicrosoft 持續努力減少整體擁有成本的過程中,SQL Server 2008SQL Server 2008 導入了兩項功能:稱為「原則式管理」的管理伺服器方法,以及使用組態伺服器和伺服器群組的多伺服器查詢。As part of MicrosoftMicrosoft ongoing efforts to reduce the total cost of ownership, SQL Server 2008SQL Server 2008 introduced two features: a method of managing servers that is called Policy-Based Management, and multiserver queries that use configuration servers and server groups. 這些功能可以搭配本主題所描述的某些功能使用,也可以取代這些功能。These features can be used with, or instead of, some of the features that are described in this topic. 如需詳細資訊,請參閱 < 原則式管理來管理伺服器管理多部伺服器使用中央管理伺服器For more information, see Administer Servers by Using Policy-Based Management and Administer Multiple Servers Using Central Management Servers.

若要利用多伺服器管理,您至少要有一部主要伺服器與一部目標伺服器。To take advantage of multiserver administration, you must have at least one master server and at least one target server. 主要伺服器會將作業散發到目標伺服器,並接收目標伺服器傳回的事件。A master server distributes jobs to, and receives events from, target servers. 對於目標伺服器上執行的作業,主要伺服器也會儲存其作業定義的集中副本。A master server also stores the central copy of job definitions for jobs that are run on target servers. 目標伺服器則會定期連接到主要伺服器,以更新其作業排程。Target servers connect periodically to the master server to update their schedule of jobs. 如果主要伺服器上有新的作業,目標伺服器便會下載該作業。If a new job exists on the master server, the target server downloads the job. 當目標伺服器完成作業後,它就會重新連接到主要伺服器並報告作業的狀態。After the target server completes the job, it reconnects to the master server and reports the status of the job.

下圖顯示主要伺服器和目標伺服器之間的關係:The following illustration shows the relationship between master and target servers:

多伺服器管理組態Multiserver administration configuration

如果您負責管理大型公司的部門伺服器,您可以定義下列項目:If you administer departmental servers across a large corporation, you can define the following:

  • 含多個作業步驟的備份作業。One backup job with job steps.

  • 發生備份失敗狀況時要通知的操作員。Operators to notify in case of backup failure.

  • 備份作業的執行排程。An execution schedule for the backup job.

請在主要伺服器上撰寫一次這個備份作業,然後將每個部門伺服器都編列為目標伺服器。Write this backup job one time on the master server and then enlist each departmental server as a target server. 一旦您將這些伺服器編列上去以後,所有的部門伺服器都會執行同一個備份作業,而您只需定義一次作業。From the time of their enlistment, all the departmental servers run the same backup job, yet you defined the job only once.

注意

多伺服器管理功能是提供給 sysadmin 角色的成員。Multiserver administration features are intended for members of the sysadmin role. 但是,目標伺服器上的 sysadmin 角色成員,不能編輯主要伺服器在目標伺服器上所執行的作業。However, a member of the sysadmin role on the target server cannot edit the operations that are performed on the target server by the master server. 這個安全性措施避免意外刪除作業步驟,防止目標伺服器上的作業中斷。This security measure prevents job steps from being accidentally deleted and operations on the target server from being interrupted.

本節內容In This Section

建立多伺服器環境Create a Multiserver Environment
包含如何建立與管理主要伺服器及目標伺服器的相關資訊。Contains information about how to create and manage master and target servers.

為多伺服器環境選擇適當的 SQL Server Agent 服務帳戶Choose the Right SQL Server Agent Service Account for Multiserver Environments
包含針對 SQL ServerSQL Server Agent 服務使用非管理的 Windows 帳戶或「本機系統」帳戶,會如何影響多伺服器環境的資訊。Contains information about how using nonadministrative Windows accounts or the Local System account for the SQL ServerSQL Server Agent service can affect multiserver environments.

在目標伺服器上設定加密選項Set Encryption Options on Target Servers
包含在目標伺服器上設定 MsxEncryptChannelOptions SQL ServerSQL Server Agent 登錄子機碼的相關資訊。Contains information about setting the MsxEncryptChannelOptions SQL ServerSQL Server Agent registry subkey on target servers.

管理整個企業的作業Manage Jobs Across an Enterprise
包含檢查作業狀態、變更作業的目標伺服器、同步處理目標伺服器時鐘,以及向主要伺服器輪詢其目前作業狀態等的相關資訊。Contains information about checking job status, changing target servers for jobs, synchronizing target server clocks, and polling master servers for their current job status.

疑難排解使用 Proxy 的多伺服器作業Troubleshoot Multiserver Jobs That Use Proxies
包含失敗的使用 Proxy 之多伺服器作業的疑難排解資訊。Contains information about troubleshooting multiserver jobs that use proxies which fail.

輪詢伺服器Poll Servers
包含如何以隱含方式 (及明確方式) 讓目標伺服器輪詢主要伺服器,以同步處理作業資訊的相關資訊。Contains information about how to implicitly and explicitly make target servers poll master servers to synchronize jobs information.

管理事件Manage Events
包含如何將事件從目標伺服器轉送至主要伺服器的相關資訊。Contains information about event forwarding from target servers to master servers.

微調企業整體的自動化管理Tune Automated Administration Across an Enterprise
包含多伺服器環境中的自動化管理如何利用 SQL ServerSQL Server之自行微調功能的相關資訊。Contains information about how automated administration in a multiserver environment takes advantage of the self-tuning features of SQL ServerSQL Server.

另請參閱See Also

SQL Server Database Engine 回溯相容性 SQL Server Database Engine Backward Compatibility
註冊伺服器 Register Servers
sp_add_targetservergroup (Transact-SQL) sp_add_targetservergroup (Transact-SQL)
sp_delete_targetserver (Transact-SQL) sp_delete_targetserver (Transact-SQL)
sp_delete_targetservergroup (Transact-SQL) sp_delete_targetservergroup (Transact-SQL)
sp_help_downloadlist (Transact-SQL) sp_help_downloadlist (Transact-SQL)
sp_help_jobserver (Transact-SQL) sp_help_jobserver (Transact-SQL)
sp_help_targetservergroup (Transact-SQL) sp_help_targetservergroup (Transact-SQL)
sp_resync_targetserver (Transact-SQL) sp_resync_targetserver (Transact-SQL)
sp_update_targetservergroup (Transact-SQL) sp_update_targetservergroup (Transact-SQL)
dbo.sysjobservers (Transact-SQL) dbo.sysjobservers (Transact-SQL)
sys.syslogins (Transact-SQL) sys.syslogins (Transact-SQL)
dbo.systargetservers (Transact-SQL)dbo.systargetservers (Transact-SQL)