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 ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is merge replication?

912


How to define the name and server for a new dsn?

765


What is the difference between clustered index and primary key?

733


How to rebuild indexes with alter index ... Rebuild?

824


What are the types of processing and explain each? : sql server analysis services, ssas

947


What are scalar functions?

729


Why use sub query in sql server and list out types of sub queries?

772


What is your recommendation for a query running very slow? : sql server database administration

821


What is an indice?

806


Explain left outer join and right outer join?

803


What is read uncmmited?

838


How to test odbc dsn connection settings?

758


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

741


How to automatically create a log when an exception is being received into SQL Server?

984


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

1764