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
- 6486 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 significance of null value and why should we avoid permitting null values?
What are character string data types in ms sql server?
What do we have to check in database testing?
What do you mean by an execution plan? Why is it used?
Do you think BCNF is better than 2NF & 3NF? Why?
How to define and use table alias names in ms sql server?
What are the different types of backups avaialabe in sql server 2005?
Does index speed up select statements?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is policy based management (pbm)? : sql server database administration
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is the use of keyword with encryption.
Which language rdl files made of?
What command would you use to create an index?
How do I view a procedure in sql server?
