散發資料庫Distribution Database

適用於: 是SQL Server 是Azure SQL Database (僅限受控執行個體) 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database (Managed Instance only) noAzure SQL Data Warehouse noParallel Data Warehouse

散發資料庫會儲存所有複寫類型的中繼資料和記錄資料,以及異動複寫的交易。The distribution database stores metadata and history data for all types of replication, and transactions for transactional replication.

在許多情況下,單一散發資料庫即已足夠。In many cases, a single distribution database is sufficient. 不過,如果多個發行者使用單一散發者,請考慮為每個發行者建立一個散發資料庫。However, if multiple Publishers use a single Distributor, consider creating a distribution database for each Publisher. 這樣可以確保流經每個散發資料庫的資料都不同。Doing so ensures that the data flowing through each distribution database is distinct. 您可以為使用設定散發精靈的散發者指定一個散發資料庫。You can specify one distribution database for the Distributor using the Configure Distribution Wizard. 如有需要,請在 [散發者屬性] 對話方塊中指定其他散發資料庫。If necessary, specify additional distribution databases in the Distributor Properties dialog box.

選項。Options

散發資料庫名稱Distribution database name
輸入散發資料庫的名稱。Enter a name for the distribution database. 散發資料庫的預設名稱為「distribution」。The default name for the distribution database is 'distribution'. 如果您指定名稱,則名稱最多為 128 個字元、必須在 MicrosoftMicrosoft SQL ServerSQL Server執行個體中是唯一的,而且必須符合識別碼的規則。If you specify a name, the name can be a maximum of 128 characters, must be unique within an instance of MicrosoftMicrosoft SQL ServerSQL Server, and must conform to the rules for identifiers. 如需詳細資訊,請參閱< Database Identifiers>。For more information, see Database Identifiers.

[散發資料庫檔案的資料夾][散發資料庫記錄檔的資料夾]Folder for the distribution database file and Folder for the distribution database log file
輸入散發資料庫和記錄檔的路徑。Enter the path for the distribution database and log files. 路徑必須參考對散發者而言是本機的磁碟機,而且以本機磁碟機代號開始,然後是冒號 (例如,C:)。Paths must refer to disks that are local to the Distributor and begin with a local drive letter and colon (for example, C:). 對應的磁碟機代號和網路路徑無效。Mapped drive letters and network paths are not valid.

注意

您可以藉由將散發資料庫記錄放置在散發資料庫的個別磁碟機上,來減少寫入交易的時間和改進複寫的效能。You can decrease the time it takes to write transactions and improve the performance of replication by placing the distribution database log on a separate disk drive from the distribution database.

另請參閱See Also

[設定散發] Configure Distribution
設定發行和散發 Configure Publishing and Distribution
檢視及修改散發者和發行者屬性View and Modify Distributor and Publisher Properties