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 does the INSTEAD OF trigger do?
What are the parts of a function?
What happens to a statement batch if there is a compilation error?
What is sub-query in sql server? Explain its properties.
What is 5nf in normalization form?
How many types of the database links?
What is data compression? : sql server database administration
How to store and query spatial data?
How do I port a number to sql server?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10
What happens if null values are involved in comparison operations?