What is database replicaion? What are the different types
of replication you can set up in SQL Server?
Answer Posted / swapna
Replication is the process of copying/moving data between
databases on the same or different servers. SQL Server
supports the following types of replication scenarios:
Snapshot replication
Transactional replication (with immediate updating
subscribers, with queued updating subscribers)
Merge replication
| Is This Answer Correct ? | 42 Yes | 6 No |
Post New Answer View All Answers
What is the difference between Normalization and De-normalization?
What are the differences between DDL, DML and DCL in SQL?
What stored by the master?
Describe in brief authentication modes in sql server.
How can windows applications connect to sql servers via odbc?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What are 3 ways to get a count of the number of records in a table?
How to create a trigger for insert only?
Do you know what are various aggregate functions that are available?
Explain how you can deploy an SSRS report?
Explain what is the difference between a local and a global temporary table?
What is single-user mode?
Define right outer join in sql server joins?
How to find the list of fixed hard drive and free space on server?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?