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.
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
