Interested to Buy Any Domain ? << Click Here >> for more details...
What is database replicaion? What are the different types
of replication you can set up in SQL Server?
- 5 Answers
- 25457 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
What does the on update no action do?
What new changes are being made in SQL Server?
what is package and it uses and how can u call a package
Explain the steps to create and execute a user-defined function in the sql server?
How do you rename a table in sql server?
Differentiate between ms sql server reporting services vs crystal reports?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What are the steps you will take to improve the performance of a poor performing query?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Can an entity have two primary keys?
Does any body please help me what question's have asked for SSRS in the interview?
What is read committed?
Is it possible to have clustered index on separate drive from original table location?
What is difference between temp table and cte?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
