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

DATABASE database_name

指定本地SQL Server實例(即創建可用性組的服務器實例)上一個或多個用戶數據庫的列表。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). 可以為一個可用性組指定多個數據庫，但每個數據庫只能屬于一個可用性組。You can specify multiple databases for an availability group, but each database can belong to only one availability group. 有關可用性組可以支持的數據庫類型的信息，請參閱“永不停機的可用性組(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). 要找出哪些本地數據庫已經屬于某個可用性組，請參閱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.

創建可用性組之后，請連接到承載輔助副本的每個服務器實例，然后準備每個輔助數據庫并將其加入到可用性組中。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. 有關詳細信息，請參閱在始終打開的輔助數據庫(SQL Server)上啟動數據移動。For more information, see Start Data Movement on an Always On Secondary Database (SQL Server).

注釋 Note

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