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
- 25298 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
How do I create an extended event in sql server?
Can we call future method from trigger?
How do you clear a log file?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is a non clustered primary key?
Tell me what is a linked server?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What do you mean by recursive stored procedure?
Does partitioning help performance?
What are partitioned views?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Can I save my report as html, excel or word? : sql server management studio
How to access the deleted record of an event?
Which are the olap features?
What is the contrast amongst drop and truncate?
