What are the different types of replication? How are they used?
Answer Posted / meeran
Replication is the process of sharing data between
databases in different locations. Using replication, we can
create copies of the database and share the copy with
different users so that they can make changes to their
local copy of database and later synchronize the changes to
the source database.
Microsoft SQL Server 2000 supports the following types of
replication:
Snapshot Replication
Transactional Replication
Merge Replication
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is history table in sql server?
Explain transaction server consistency?
What is the difference between commit and rollback?
how to invoke a trigger on demand? : Sql server database administration
What are the dis_advantages of stored procedures, triggers, indexes?
Explain about system stored procedure?
What is policy based management (pbm)? : sql server database administration
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Explain activity monitors
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Define Joins?
Do you know what is similarity and difference between truncate and delete in sql?
What are the types of indexing?
What is normalization and its types?
What is surrogate key? : sql server analysis services, ssas