Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of replication? How are they used?
- 3 Answers
- 13088 Views
- I also Faced
- E-Mail Answers
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
If a table does not have a unique index, can a cursor be opened on it?
What are the authentication modes in sql server? How can it be changed?
What is correlated subquery in sql server?
What is filestream?
What is molap and its advantage? : sql server analysis services, ssas
What is indexing in sql server with example?
Which is the main third-party tool used in sql server?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Do you know sql server 2008 introduces automatic auditing?
List down some advantages of sql stored procedure?
Explain trigger and trigger types?
What is “asynchronous” communication in sql server service broker?
What are the dis_advantages of stored procedures, triggers, indexes?
How to create a trigger for insert only?
What is acid db?
