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
- 25454 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
Why de-normalization required?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What are the advantages of user-defined functions over stored procedures in sql server?
What is optimistic concurrency?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What happens if null values are involved in comparison operations?
Ms sql server index?
Can you create a logon trigger in sql server 2005 express edition?
What is onf in normalization form?
What is 2nf normalization form?
What is raiseerror? What is raiseerror?
what is a join and explain different types of joins? : Sql server database administration
How much does sql server 2016 cost?
Ways to improve the performance of a SQL Azure Database?
What is a recursive stored procedure in sql server?
