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 a unique index?
what is the different types of backups available in sql server? : Sql server database administration
How to create an multi-statement table-valued function?
Explain filtered indexes?
What is service broker?
Where cross join is used?
Explain the properties of a relational table?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is store procedure?
Do you know what is a linked server in sql server?
How are the exceptions handled in sql server programming?
Do you know what are the steps to process a single select statement?
Where actually sql azure database is hosted?
Can you pass expressions to function parameters?
Explain about integration services of Microsoft SQL server?