Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diffrence between Snap Shot and Transaction
Replication
- 2 Answers
- 11890 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / gowtham
In snapshot replication we ccan take the copy of the database
from publisher and put it into the subscriber,here it is in read-only mody it will not allow us to make any modifycations
In Transactional replication it is a oneway commite if we did any modifications in publisher those modifications will be replicated to suscriber (here the log rederagent captures the
changes in suscriber from transactional log and it moves to the distibutor).
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Mention the 3 ways to get a count of the number of records in a table.
What is SQL Azure Federations?
Tell me what is difference between clustered and non clustered index?
Explain how would you store your query in an SSRS report or a Database server?
Do you know the capabilities of cursors?
How to write an inner join with the where clause in ms sql server?
What are the events recorded in a transaction log?
What are the ways available in sql server to execute sql statements?
Differentiate between sql temp table vs table variable?
How to create new table with "create table" statements?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
what is spatial nonclustered index
What is difference between delete and truncate commands?
what purpose does the model database serve? : Sql server database administration
How is table type constraint applied to a table?
