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
- 6596 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
Explain unique key in sql server?
What are the types of normalization?
What is 5nf in normalization form?
Explain the ways to controlling cursor behavior?
What is inline table-value user-defined function?
Explain about temporary stored procedure?
Explain the difference between function and stored procedure?
Can you please explain the difference between primary keys and foreign keys?
What is the difference between the 2 operating modes of database mirroring?
What is extent? Types of extents?
What are the database objects? : SQL Server Architecture
How many categories of data types used by sql server?
Tell me what is a linked server?
How to find the source of a table in sql server?
What are logical/boolean operations in ms sql server?
