what is replication?
where do u use Go Keyword?



what is replication? where do u use Go Keyword? ..

Answer / jijo

Synchronizing data and object between systems .

For example i have 50gb data in Delhi server(Publisher or
source ) i need to replicate into tow locations one into
mumbai server 10gb data (subscriber ) and another one into
kerala server 20gb data.

Publisher ---Source
Subscriber ---destination
Distributor--- Receive from publisher and forward to sub

Type of replications

1)Snapshot (one way)
Data refresh of the subscriber every time you synchronize.

2)Merge Replication (Two way)
Both publisher and subscriber can make change to the data.
Conflict :- When two participant chenge the same row at same
time

3)Transactional replication
As change made at the publisher its send to the distributor
and distributor into subscriber

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are types of scd? : sql server analysis services, ssas

0 Answers  


How do I save a stored procedure in sql server?

0 Answers  


How to select some specific columns from a table in a query in ms sql server?

0 Answers  


Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  


What is in place upgrade in sql server?

0 Answers  






Explain some stored procedure creating best practices or guidelines?

0 Answers  


What is SQL Server?

0 Answers   Atos Origin,


Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,


How exceptions can be handled in sql server programming?

0 Answers  


What is side by side migration in sql server?

0 Answers  


Explain what is lock escalation and what is its purpose?

0 Answers  


Can you please explain the difference between primary keys and foreign keys?

0 Answers  


Categories