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
What is merge replication?
How to define the name and server for a new dsn?
What is the difference between clustered index and primary key?
How to rebuild indexes with alter index ... Rebuild?
What are the types of processing and explain each? : sql server analysis services, ssas
What are scalar functions?
Why use sub query in sql server and list out types of sub queries?
What is your recommendation for a query running very slow? : sql server database administration
What is an indice?
Explain left outer join and right outer join?
What is read uncmmited?
How to test odbc dsn connection settings?
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
How to automatically create a log when an exception is being received into SQL Server?
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