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 the difference between a primary key and a unique key? : Sql server database administration

712


How do you delete duplicate records in sql server?

723


explain different types of constraints? : Sql server database administration

702


How can we delete Duplicate row in table?

790


What is key attribute?

699






Explain the Ways to improve the performance of a sql azure database?

78


What is the recovery model? List the types of recovery model available in sql server?

655


How to declare a cursor with "declare ... Cursor" in ms sql server?

739


Do you know what is normalization of database? What are its benefits?

732


Write a program to fetch first 10 records from a file?

759


What do you mean by a dependent functionality in a build?

828


What are the basic functions for master, msdb, model, tempdb databases?

783


Do you know what are acid properties of transaction?

689


What is indexed view? How to create it?

757


What are the different types of locks in the database?

649