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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / sachin rathi

Database replication is the creation and maintenance of
multiple copies of the same database.

In most implementations of database replication, one
database server maintains the master copy of the database
and additional database servers maintain slave copies of
the database.

Database writes are sent to the master database server and
are then replicated by the slave database servers.

Database reads are divided among all of the database
servers, which results in a large performance advantage due
to load sharing.

In addition, database replication can also improve
availability because the slave database servers can be
configured to take over the master role if the master
database server becomes unavailable.

Is This Answer Correct ?    4 Yes 0 No

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

Answer / vijay kona

Replication is the process of moving database objects from
one server to another server.
There are 3 types:
1.snapshot replication
2.Transactional replication
3.Merge replication(2way communication process)

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is awe?

0 Answers  


What is the difference between update lock and exclusive lock?

0 Answers  


Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  


Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,


explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  






Define master database?

0 Answers  


What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,


Can you give an example of Stored Procedure?

4 Answers   Wipro,


What are system databases into sql server (2005/2008)?

0 Answers  


What do you know about normalization and de- normalization?

0 Answers  


How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,


How can we solve concurrency problems?

0 Answers  


Categories