What is database replicaion? What are the different types
of replication you can set up in SQL Server?
- 5 Answers
- 24312 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
What is the use of set nocount on/off statement?
what is a join? : Sql server database administration
Explain the truncate command?
What are the components of sql server service broker?
What is data mart? : sql server analysis services, ssas
What is the use of commit?
How do indexes help, types?
How to create a simple table to test triggers in ms sql server?
Differentiate between truncate vs delete in mssql?
What are the different ways you can create databases in sql server?
What is usually the first word in a sql query?
List few advantages of stored procedure.
Can the query output be sorted by multiple columns in ms sql server?
What are logical database components? : SQL Server Architecture
how to take backup bcp out for a column in table in sql server?
