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
- 6472 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
Replication is the process of copying/moving data between
databases on the same or different servers. SQL Server
supports the following types of replication scenarios:
Snapshot replication
Transactional replication (with immediate updating
subscribers, with queued updating subscribers)
Merge replication
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / vijay kona
Replication is the process of moving database objects from
one server to another server.
There are 3 types:
1.snapshot replication
2.Transactional replication
3.Merge replication(2way communication process)
| Is This Answer Correct ? | 1 Yes | 0 No |
How can you set the threshold at which sql server will generate keysets asynchronously?
What do you understand by a view? What does the with check option clause for a view do?
sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters
Do you know data definition language, data control language and data manipulation language?
What is difference between commit and rollback when used in transactions?
How do you debug a procedure in sql server?
What is difference between stored procedure and user defined function?
What is difference in performance between insert top (n) into table and using top with insert?
What is a heap?
how can i view structure of table in sql server? tell me that query.
Which one is faster delete/truncate? Why?
how to delete duplicate rows from table
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
