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
How do we Backup SQL Azure Data?
What is normalization of database? What are its benefits?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What are the different sql server versions?
what is the difference between openrowset and openquery?
What is the difference between composite index and covering index?
What command is used to rename the database?
What were the latest updates to SQL Azure service?
What are the advantages of mirroring?
what are the different types of SSRS reports?
Do you know spatial data types - geometry and geography in sql server 2008?
What are the disadvantages of using querystrings to send data from one page to another?
How can you start sql server in different modes?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What are sparse columns?