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
- 25718 Views
- Aptech, HCL, Perpetual, SAIC, I also Faced
- E-Mail Answers
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
Explain datetime2 data type in sal server 2008?
What is the use of group by clause?
Difference between drill down and drill through report.
Explain the truncate command? : SQL Server Architecture
What is filtered index?
Explain iaas, paas and saas?
How do I completely remove sql server instance?
Write a SQL queries on Self Join and Inner Join.
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
How to start sql server browser service?
List the ways in which dynamic sql can be executed?
Comment,Datatypes are unlimited
Please illustrate physical database architecture? : SQL Server Architecture
How many cores do I need for sql server 2016?
How to get a list of columns in a view using the "sp_help" stored procedure?
