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 the advantages of passing name-value pairs as parameters?

665


Is sql server 2016 free?

538


List some major differences between triggers and stored procedures?

524


What according to you is the difference between mysql and sql server performance?

567


What is postgresql server?

516






What are the different types of indexes?

613


What are the types of sql server?

523


What are translations and its use? : sql server analysis services, ssas

611


How do you make a trace?

588


What is star, snowflake and star flake schema? : sql server analysis services, ssas

667


How do you check sql server is up and running?

518


why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

563


What is triggers and stored procedures?

519


What is recompile sql server?

573


is it important for a database administrator to understand the operating system and file access? : Sql server administration

592