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
- 6473 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 parse query button used for?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to change the password of a login name in ms sql server?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Can we deploy SSRS reports on our personal website?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Explain the purpose of indexes?
what method you can use to reduce the overhead of Reporting Services data sources?
Explain collation?
What is the difference between resultset and resultsetmetadata?
What is attribute? : sql server analysis services, ssas
How do I connect to sql server database?
What is the difference between commit and rollback?
What are the benefits and tasks of object explorer? : sql server management studio
How to check if a table is being used in sql server?
