What is database replicaion? What are the different types
of replication you can set up in SQL Server?
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 |
What are commit and rollback in sql?
please tell me the query to get details of the employee having the second largest salary
How many categories of data types used by sql server?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
0 Answers Amdocs, Apps Associates,
What is the ‘fillfactor’?
What action plan is preferred if sql server is not responding?
What are the differences between char and nchar in ms sql server?
Can you pass expressions to stored procedure parameters?
Explain about the command-line tool SQLCMD?
How to get max 100 values from sql server
What is store procedure? When do you use?
How do I create a partition table in sql server?