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
- 25740 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 do I find the port number for sql server?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What are various ways to enhance the ssrs report?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is outer join in sql server joins?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
How to provide values to stored procedure parameters in ms sql server?
How to recover from sql injection? : sql server security
How do you size a resultset?
Can sub report data source be different from that of the parent report?
What are the 2 types of classifications of constraints in the sql server?
Explain features and concepts of analysis services?
How to add a new dsn with the odbc driver for sql server?
What does truncate do?
