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 ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the options which must be set to allow the usage of optimistic models?

607


How to grant a permission in ms sql server using "grant execute" statements?

654


Define self join?

714


What is the use of set nocount on/off statement?

705


What does it mean to normalize a database and why would you do it?

635






What is change tracking in sql server?

619


How do you create a clustered index?

611


What should be the fill factor for indexes created on tables? : sql server database administration

718


What are dml triggers and types of dml triggers?

630


What is exporting and importing utility?

694


What is Command line parameters in PLSQL.?

659


Explain filestream storage of sql server 2008?

598


How to send email from database?

679


How to run queries with sql server management studio express?

664


What is data mart? : sql server analysis services, ssas

690