What is database replicaion? What are the different types
of replication you can set up in SQL Server?
- 3 Answers
- 5605 Views
- I also Faced
- E-Mail Answers
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 stored procedure would you use to view lock information? : Sql server administration
What are user defined functions in ms sql server?
What is the difference between dropping a database and taking a database offline?
Tell me what is a linked server?
How many primary keys are possible in a table?
How many replicas are maintained for each sql azure db?
Describe different Processing Modes offered by SSRS?
explain extended properties
What is sql injection? How to protect against sql injection attack?
What is shrink log file?
Explain about remote stored procedure?
What is an index in sql?
What are the different types of columns types constraints in the sql server?
Do you know how to make remote connection in database?
How to attach adventureworkslt physical files to the server?
