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

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1750


What is command parameter in ssrs?

141


what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

748


How use inner join in sql server?

837


What is sql view?

763


what is denormalization and when would you go for it? : Sql server database administration

923


What is set nocount on?

713


New concepts of sql server 2005 use in your project.

2110


what is checksum in sql server.........???

1408


How is sql used in sql server?

695


what is datawarehouse?

861


What are the advantages of partitioning?

837


Explain about protocol layer present in SQL server?

817


Define outer join in sql server joins?

698


Explain nested trigger in sql?

799