[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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-2654071/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-2654071/