SQL SERVER 2005 Synchronous replication

What

SQL SERVER2005 replication is a scheme that maintains data structure and content synchronization updates between different databases.

Consists of three parts: the Publisher: Contains the database that needs to be published, that is, the source database that needs to distribute the content to other data sources. Distributor: The Distributor contains the distribution database, which is the role of the distribution database to store the data sent by the forwarding publisher. One distributor supports multiple Publisher subscribers: contains a copy of the data published by the publisher. This copy can be a database, or a table, or even a subset of a table. Includes three modes: 1, snapshot replication: The structure and content of the publication database is synchronized to the subscription database at one time by the snapshot feature: Each update data is large. Suitable for small amount of data, more data update, better network environment Scenario 2, merge replication: Both the Publisher and the subscription database are modified after merging to the publication database, the publication database is synchronized to the subscription database features: For multiple servers to update the data of the scene 3, Transactional replication: The publication database only synchronizes the modified place to the subscription database, mainly according to modify the log to synchronize features: Each time only the part of the change, occupy small bandwidth, real-time strong. For high-real-time scenario subscriptions, there are two modes: Push subscription: The publisher has updated data that is immediately pushed to the Subscriber pull subscription: Subscribers go to the publisher every once in a while to find out if there is data to update. WhyWhen we use the read-write separation, the data cluster, the failover needs to synchronize the database, the database duplication is one of the means to realize this function. HowCreate a release one, prepare 3 server,1 for the Publisher, 1 for the Distributor, 1 for subscribers, and typically for the Publisher and distributor for the same 1 servers. Second, ensure that 3 servers can access each other, SQL SERVER remote connection needs to be opened, firewall to open 1433 ports. Third, according to the online publishing tutorial to operate, the following is the tutorial URL: http://www.cnblogs.com/CareySon/archive/2012/06/20/ introducttosqlserverreplicationpart1.htmlhttp://dufei.blog.51cto.com/382644/84645/Delete a publication using the following system stored procedures:
sp_removedbreplication @dbname = ' dbname ', @type = ' type '
Parameters
[@dbname =] ' DBName '
The name of the database. The dbname data type is sysname and the default value is NULL. When this parameter value is NULL, the current database is used.
[@type =] Type
The type of replication for which to remove the database object. Type has a data type of nvarchar (5) and can be one of the following values.
Tran: Deletes the transactional replication publication object.
Merge: Deletes the merge replication publication object.
Both (default): Deletes all replication publication objects.

SQL SERVER 2005 Synchronous replication