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

Answer Posted / srisenthil

Replication is a method of copying data from one database
to other database or one server to another

there are three types of replication

(1) transactional (2)snapshot (3) merge (4) logshipping and
in 2005 one more type is introducde which was called as
peer to peer replications

Is This Answer Correct ?    11 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are subqueries in sql server?

790


What is an sql server agent?

723


What is the advantage of sql server?

723


What happens when converting big values to integers?

727


What do you do in data exploration

718






How to enforce security in sql server? : sql server security

802


How to loop through the result set with @@fetch_status?

829


List the advantages of using stored procedures?

740


What is the architecture of ms sql reporting service?

702


Why variables called the most powerful component of ssis?

795


How to view the error log for any specific instance? : sql server database administration

768


Explain error and transaction handling in sql server?

679


What are the new security features added in sql server 2012? : sql server security

702


Explain active/passive and active/active cluster configurations?

796


What is the name of the system variable that returns the number of rows affected by a SQL statement?

767