It is often necessary to have the same database running in multiple servers. With transactional replication, several instances of the same database can run in completely different servers and communicate to each other. All the insert, update, delete operations are synced between the databases.
An application can benefit from peer-to-peer replication in the following ways:
- Improved read performance, because reads are spread out over two or more servers.
- Higher availability if maintenance is required or in case of failure at one server.
Read More:
http://msdn.microsoft.com/en-us/library/ms151196.aspx
Cool!, So how can I configure this? Here is the link:
Configuration with SQL Management Studio
No comments:
Post a Comment