[AlwaysOn] 建立SQL Server高可用性組T-SQL語法：SEEDING_MODE引數

SEEDING_MODE = { AUTOMATIC | MANUAL }

指定輔助副本最初的種子設定方式。Specifies how the secondary replica is initially seeded.

自動 AUTOMATIC

啟用直接 種子設定 。Enables direct seeding. 此方法透過網路種子化輔助副本。This method seeds the secondary replica over the network. 此方法不需要備份和還原副本上主資料庫的副本。This method does not require you to backup and restore a copy of the primary database on the replica.

註釋 Note

對於直接種子設定，必須透過使用grant create any database選項呼叫alter availability group來允許在每個輔助副本上建立資料庫。For direct seeding, you must allow database creation on each secondary replica by calling ALTER AVAILABILITY GROUP with the GRANT CREATE ANY DATABASE option.

手動 MANUAL

指定手動種子設定(預設)。Specifies manual seeding (default). 此方法要求您在主副本上建立資料庫備份，並在輔助副本上手動還原該備份。This method requires you to create a backup of the database on the primary replica and manually restore that backup on the secondary replica.