[AlwaysOn] 創(chuàng)建SQL Server高可用性組T-SQL語法：DATABASE子句

DATABASE database_name

指定本地SQL Server實例(即創(chuàng)建可用性組的服務(wù)器實例)上一個或多個用戶數(shù)據(jù)庫的列表。Specifies a list of one or more user databases on the local SQL Server instance (that is, the server instance on which you are creating the availability group). 可以為一個可用性組指定多個數(shù)據(jù)庫，但每個數(shù)據(jù)庫只能屬于一個可用性組。You can specify multiple databases for an availability group, but each database can belong to only one availability group. 有關(guān)可用性組可以支持的數(shù)據(jù)庫類型的信息，請參閱“永不停機的可用性組(SQL Server)”的前提條件、限制和建議。For information about the type of databases that an availability group can support, see Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server). 要找出哪些本地數(shù)據(jù)庫已經(jīng)屬于某個可用性組，請參閱sys.databases目錄視圖中的replica_id列。To find out which local databases already belong to an availability group, see the replica_id column in the sys.databases catalog view.

DATABASE 子句是可選的。The DATABASE clause is optional. 如果省略了它，則新的可用性組為空。If you omit it, the new availability group is empty.

創(chuàng)建可用性組之后，請連接到承載輔助副本的每個服務(wù)器實例，然后準備每個輔助數(shù)據(jù)庫并將其加入到可用性組中。After you have created the availability group, connect to each server instance that hosts a secondary replica and then prepare each secondary database and join it to the availability group. 有關(guān)詳細信息，請參閱在始終打開的輔助數(shù)據(jù)庫(SQL Server)上啟動數(shù)據(jù)移動。For more information, see Start Data Movement on an Always On Secondary Database (SQL Server).

注釋 Note

稍后，您可以在承載當前主副本的服務(wù)器實例上向可用性組添加符合條件的數(shù)據(jù)庫。Later, you can add eligible databases on the server instance that hosts the current primary replica to an availability group. 還可以從可用性組中刪除數(shù)據(jù)庫。有關(guān)詳細信息，請參閱alter availability group(Transact-SQL)。You can also remove a database from an availability group. For more information, see ALTER AVAILABILITY GROUP (Transact-SQL).