Interested to Buy Any Domain ? << Click Here >> for more details...
what is replication?
where do u use Go Keyword?
- 1 Answers
- 4906 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
What are sub reports?
How real and float literal values are rounded?
What functions can a view be used to performed?
Distinguish between commit and rollback?
What is optimization and its types?
What is the difference between lock, block and deadlock? : sql server database administration
Determine when to use stored procedure to complete sql server tasks?
Explain the microsoft sql server delete command? : SQL Server Architecture
What are the general features of sql server management studio? : sql server management studio
What is sql server profiler?
What is format parameter in ssrs?
What are sparse columns?
Can you explain about buffer cash and log cache in sql server?
What happens if ntwdblib.dll is missing on your machine?
What is openrowset sql server?
