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
What are the recovery models in sql server 2000?
How can sql server instances be hidden?
What is oltp (online transaction processing)?
Explain what is public role in sql server?
Call by value and call by reference in procedure and function, with NOCOPY.
What are magic tables in sql server?
What is the query and subquery?
How can sql injection be stopped? : sql server security
What is unpivot?
What are the types of database recovery models?
Can you tell me some of the common replication dmv's and their use? : sql server replication
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is a heap?
How to execute the cursor queries with "open" statements?
What are the properties and different types of sub-queries?