What is database replicaion? What are the different types
of replication you can set up in SQL Server?
- 5 Answers
- 24315 Views
- Aptech, HCL, Perpetual, SAIC, I also Faced
- E-Mail Answers
Answer Posted / neeraj singh bhandari
Replication is the technique provided by MS SQl server to
keep the replicate copy of database.
There are four basis type of Replication which we can set
up in sql server
1. Snapshot replication – It is used when data at Publisher
is static means not changing frequently and Subscriber need
update data
2. Transactional replication - It is used when data is
changing frequently at publisher and Subscriber need on
line data from publisher.
3. Merge replication- It is used when there is no constant
connection between Publisher and Subscriber. When they come
on line then data will replicate. In replication data
can conflict and resolve this there is rule set up already.
4. Transactional replication with Updateable Subscription-
It is similer to Transactional replication but update
backs to Publisher from Subscriber. In this it add extra
field in table called ms_repl- etc to keep the update data
from Subscriber.
We can also implement Peer to Peer replication which is
Headless topology. To do this we need enterprise edition of
sql server 2005. In this there is more than one Publishers
and one or more Subscribers. Every participant is both
Publisher and Subscriber. This is mostly use when every one
wants to read and modify the data.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is difference between joins and subqueries?
Which table keeps information about stored procedures?
How do you handle datasets larger than 50 gb?
Where are full-text indexes stored?
What is cube dimension? : sql server analysis services, ssas
Can a table be moved to different filegroup?
Does partitioning ssd reduce performance?
What are the different types of sub-queries?
What are the character string functions supported by sql server 2005?
List the different index configurations possible for a table?
What is global temp table?
Explain the difference between control flow and data flow?
How do I find the query plan in sql server?
