What is database replicaion? What are the different types
of replication you can set up in SQL Server?

Answer Posted / swapna

Replication is the process of copying/moving data between
databases on the same or different servers. SQL Server
supports the following types of replication scenarios:

Snapshot replication
Transactional replication (with immediate updating
subscribers, with queued updating subscribers)
Merge replication

Is This Answer Correct ?    42 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data source view or dsv? : sql server analysis services, ssas

561


How many primary keys are possible in a table?

522


What languages bi uses to achieve the goal?

515


What is data modeling and Reterminal integrity?

1496


How to replace null values in expressions using isnull()?

651






do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

487


What is sql service broker?

594


What is the usage of sign function?

598


Introduction of rollup clause using sum and group by clause?

542


What does it mean to normalize data?

525


What is sharding?

88


What is code near application topology?

197


What triggers long term care?

565


What is Federation Root Database?

90


Differentiate between a local and a global temporary table?

545