What is database replicaion? What are the different types
of replication you can set up in SQL Server?
Answer Posted / sivakumar
Replication
Replication is the process of copying/moving data between
databases on the same or different servers.
SQL Server upports the following types of replication
scenarios:
Snapshot replication:
The Publisher sends a snapshot of the published data to
Subscribers at scheduled intervals.
Transactional replication:
The Publisher streams transactions to the Subscribers after
they receive an initial snapshot of the published data.
Merge replication:
The Publisher and Subscribers can update the published data
independently after the Subscribers receive an initial
snapshot of the published data. Changes are merged
periodically. Microsoft SQL Server Mobile Edition can only
subscribe to merge publications.
Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What is database black box testing?
How to retrieve error messages using odbc_errormsg()?
What is instead of trigger sql server?
What is indexing and its types?
What are functions in the sql server?
How to write character string constants or literals in ms sql server?
Explain user defined views?
Explain tablesample?
How to start sql server browser service?
When would you use sql joins?
What is create command?
What are views in ms sql server?
What do you mean by stored techniques? How would we use it?
How to create a new table in a given schema?
What are the types of subquery?