Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of replication? How are they used?
- 3 Answers
- 12953 Views
- I also Faced
- E-Mail Answers
Answer Posted / raghuram
Replication is a process of copying/moving data between
databases on the same or different servers.In Replication,
We have Three server.
a) Publisher : It is the Principal server
b) Distributor : It sends the data from
Publisher to Subscriber
c) Subscriber : It is the secondary server
which stores the received data
The types of Replication are,
a) Snapshot Replication : It distributes data
exactly as it appears at a specific moment in time and does
not monitor for updates to the data. It is the best used
method of replicating data that changes infrequently or
where the most up-to-date values are not requirement. When
synchronization occurs, the entire snapshot is generated
and sent to the subscribers.
b) Merge Replication : It is the process of
distributing data from Publisher to subscriber, allowing
the Publisher and Subscriber to make update data while they
are connected or disconnected, and then merging the updates
between sites when they are connected.
c) Transactional Replication : An initial snapshot
of data is applied to subscriber, and when data
modifications are made at the publisher, the individual
transactions are captured and propogated to subscriber.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is 2nf normalization form?
What is it unwise to create wide clustered index keys?
How do I debug a stored procedure in sql server?
Explain sql server authentication modes?
What is the chart in report?
Explain acid?
Explain try...catch with sql server?
What are the security related catalog views? : sql server security
What is the return type of executeupdate ()?
What is ems sql management studio? : sql server management studio
Do you know what is rank function?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is the maximum size of a dimension? : sql server analysis services, ssas
How can sql server instances be hidden?
What is the difference between the 2 operating modes of database mirroring?
