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
- 6733 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
Can binary strings be converted into numeric or float data types?
How can I get data from a database on another server?
What are the types of lock supported by ?
Do you know the capabilities of cursors?
Explain subquery and state its properties?
is there a column to which a default can't be bound? : Sql server database administration
What are different replication agents and what's their purpose? : sql server replication
Will the writetext statement activate a trigger?
What is difference between join and natural join?
How to start and end transact-sql statements?
How can I create a new template for import ? : sql server management studio
How do you set a trace flag in sql server?
How to create indexed view?
What program is used to store the data source file?
Explain what is use of dbcc commands?
