Interested to Buy Any Domain ? << Click Here >> for more details...
what is replication?
where do u use Go Keyword?
- 1 Answers
- 4978 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
How to enable/disable indexes?
Explain the different index configurations a table can have?
What is filter index?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is filtered index?
What is a transact-sql statement batch in ms sql server?
What is sub-query in sql server? Explain its properties.
Can we take the full database backup in log shipping?
How do I manually uninstall an instance of sql server 2016?
What is a transaction and why is it important?
Explain subquery and state its properties?
what are database files and filegroups? : Sql server database administration
What is the difference between DATETIME2 and DATETIME?
what is a traditional network library for sql servers? : Sql server database administration
