| 1. |
What Is The Replication And Why It Is Required On The Sql Server? |
|
Answer» It is a set of technologies for copy and distributes DATA and database objects from one database to another. Synchronize the data can also be achieved with replication to maintain consistency. Replication can be used to DISTRIBUTE data to various LOCATIONS and to remote or mobile users over the certain medium of internet. Multiple servers having data can be synchronized with the replication process using a replica set. Thus, reading CAPACITY can be enhanced and users can be provided with a CHOICE to selecting among different server to perform read-write operations. It is a set of technologies for copy and distributes data and database objects from one database to another. Synchronize the data can also be achieved with replication to maintain consistency. Replication can be used to distribute data to various locations and to remote or mobile users over the certain medium of internet. Multiple servers having data can be synchronized with the replication process using a replica set. Thus, reading capacity can be enhanced and users can be provided with a choice to selecting among different server to perform read-write operations. |
|