How to Manage SQL Server Replication04 May
SQL Server allows you to implement replication of data among several systems within the company. There are quite a few benefits to SQL Server Replication you should be aware of. By resorting to SQL Server Replication, you can achieve Load balancing: you will be able to distribute the data and the query load between several available servers.
If you have a system which is not always connected to the network and you want to manipulate data from your database on that machine, you can do this by using Server Replication. Server Replication also offers you redundancy. You will be able to have a fail-over database server which is always ready to take the load at any given moment.
A replication scenario has two main components: the Publishers and the Subscribers. The Publishers are the servers which offer the data found on them to other machines. There may be one or more publishers in a replication scheme. The Subscribers are the database servers from the network which want to receive data when the Publisher server updates its data. A server machine… Read More
