1 create database or use existing database and then apply instdist . sql file to create replication objects in the distribution database 所以这两个文件是用来做为分发复制的数据库模板用的。
1 create database or use existing database and then apply instdist . sql file to create replication objects in the distribution database 所以这两个文件是用来做为分发复制的数据库模板用的。
Details considerations for backing up and restoring replicated databases , with strategies for each type of replication 详细说明备份和还原复制的数据库的注意事项,包括针对每种类型复制的策略。
For example , you can monitor a replicated database for stored procedures or other processes that are taking a long time to complete 例如,可以针对存储过程或其他需要花费很长时间完成的过程监视复制的数据库。
In replicated databases , the error is typically raised because primary keys have not been managed appropriately across the topology 在已复制的数据库中,通常会引发该错误,因为尚未跨拓扑对主键进行适当的管理。
For the detach - and - attach method , to avoid data loss or inconsistency , active sessions cannot be attached to the database being moved or copied 对于分离和附加方法,为了避免数据丢失或不一致,不能将活动会话附加到要移动或复制的数据库。
Peer - to - peer transactional replication is designed for applications that might read or modify the data at any of the databases participating in replication 对等事务性复制是专为可以读取或修改任何参与复制的数据库中的数据的应用程序设计的。
All databases should be backed up on a regular basis , and the ability to restore those backups should be tested periodically ; replicated databases are no different 所有数据库都应定期备份,还应对还原这些备份的能力定期进行测试;复制的数据库没有差异。
Find detailed information here on monitoring replication , replication agents , enhancing replication performance , backing up and restoring replicated databases , and upgrading replicated databases 从此处查找有关监视复制、复制代理、增强复制性能、备份和恢复复制的数据库以及升级复制的数据库的详细信息。
Provides information on : monitoring replication topologies ; techniques for optimizing replication performance ; backing up and restoring replicated databases ; and upgrading replicated databases 提供有关以下内容的信息:监视复制拓扑、优化复制性能的技术、备份和还原已复制的数据库以及升级已复制的数据库。