Interested to Buy Any Domain ? << Click Here >> for more details...
What is database replicaion? What are the different types
of replication you can set up in SQL Server?
- 3 Answers
- 6625 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 is the function of inner join?
What is database white box testing?
What do you mean by data manipulation language?
Explain about link server in sql server?
How to list all stored procedures in the current database using ms sql server?
what method you can use to reduce the overhead of Reporting Services data sources?
How to update values in a table with update statements in ms sql server?
What is sub-query in sql server?
Which are the two editions in which SQL Azure database available?
Explain the disadvantages of cursors?
What is triggers in ms sql server?
Detail about the hardware which is supported by SQL server?
What is difference between clustered and non clustered index?
What is exclusive locks?
What are the new features of sql server 2012 reporting service?
