分发数据库

• Each publisher is associated with a single database known as a distribution database at the distributor
  每个发布服务器都与分发服务器中的单个数据库称作分发数据库相关联。
• Servername will act as its own distributor ; sql server will create a distribution database and log
  “ <服务器名称>将充当自己的分发服务器； sql server将创建分发数据库和日志”
• To drop a distribution database you must first drop the association between the distributor and the publisher
  若要删除分发数据库，必须先删除分发服务器与发布服务器之间的关联。
• It moves transactions marked for replication from the transaction log on the publisher to the distribution database
  它将发布服务器上的事务日志中标记为复制的事务移至分发数据库中。
• This error occurs if you attempt to drop a distribution database that is associated with one or more publishers
  如果试图删除与一个或多个发布服务器相关联的分发数据库，将发生此错误。
• Each publisher is associated with a single database , referred to as a distribution database , at the distributor
  每个发布服务器都与分发服务器中的单个数据库（称为分发数据库）相关联。
• If the primary was also a distributor , restore the distribution database from the primary to the secondary
  如果主服务器同时也是分发服务器，则将分发数据库从主服务器还原到辅助服务器。
• When the distribution database is contained on a local instance , a random password is generated and configured automatically
  当分发数据库包含在本地实例上时，密码将随机产生并自动配置。
• The distribution database then becomes the store - and - forward queue from which changes are sent to subscribers
  这样，分发数据库就成为一个存储-转发队列，从该队列中将更改发送到订阅服务器中。
• It applies the initial snapshot to the subscriber and moves transactions held in the distribution database to subscribers
  它将初始快照应用于订阅服务器，并将分发数据库中保存的事务移至订阅服务器。