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
- 25542 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 are audit control procedures?
Write an SQL query to obtain the 2nd highest salary.
What are recommended options to be used while using db mirroring? : sql server database administration
Write a query to find 5th highest amount paid from the customer table.
How many replicas are maintained for each sql azure db?
What do you mean by acid?
Where are full-text indexes stored?
Which are the olap features?
Explain the categories of stored procedure?
explain different types of constraints? : Sql server database administration
Explain an incremental backup?
What is DCL?
What function does a database engine serve in the sql server?
How to use order by with union operators in ms sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
