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
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is command parameter in ssrs?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How use inner join in sql server?
What is sql view?
what is denormalization and when would you go for it? : Sql server database administration
What is set nocount on?
New concepts of sql server 2005 use in your project.
what is checksum in sql server.........???
How is sql used in sql server?
what is datawarehouse?
What are the advantages of partitioning?
Explain about protocol layer present in SQL server?
Define outer join in sql server joins?
Explain nested trigger in sql?