What is database replicaion? What are the different types
of replication you can set up in SQL Server?
Answer Posted / srisenthil
Replication is a method of copying data from one database
to other database or one server to another
there are three types of replication
(1) transactional (2)snapshot (3) merge (4) logshipping and
in 2005 one more type is introducde which was called as
peer to peer replications
| Is This Answer Correct ? | 11 Yes | 15 No |
Post New Answer View All Answers
What is the difference between left and right outer join?
Define outer join in sql server joins?
How to use the inserted and deleted pseudo tables?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What are the new features in sql server 2016?
Explain powershell included in sql server 2008?
Tell about MOM Tool(Microsoft Operator Manager)?
What is etl - extraction, transformation, and loading?
Explain what is it unwise to create wide clustered index keys?
How to use column default values in insert statements in ms sql server?
When is the use of update_statistics command?
How many partitions a clustered index has by default in sql server 2012?
What is the difference between ddl and dml?
What is difference between view and materialized view?
What happens if date-only values are provided as date and time literals?