Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of replication? How are they used?
- 3 Answers
- 13140 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
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How to download and install sql server 2005 books online?
What is key set driven?
How do I start sql server 2016?
What is ssrs?
How to transfer a table from one schema to another?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is sleeping status in sql server?
How to create a new table in a given schema?
Why do we need different type of parameter?
What is normalization? Explain different forms of normalization?
What is row_number () and partition by in sql server?
What is the main difference between ‘between’ and ‘in’ condition operators?
How do you set a trace flag in sql server?
How can you fetch alternate records from a table?
