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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the recovery models in sql server 2000?

750


How can sql server instances be hidden?

730


What is oltp (online transaction processing)?

779


Explain what is public role in sql server?

845


Call by value and call by reference in procedure and function, with NOCOPY.

1100


What are magic tables in sql server?

839


What is the query and subquery?

848


How can sql injection be stopped? : sql server security

759


What is unpivot?

808


What are the types of database recovery models?

841


Can you tell me some of the common replication dmv's and their use? : sql server replication

747


do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

731


What is a heap?

818


How to execute the cursor queries with "open" statements?

886


What are the properties and different types of sub-queries?

808