what is the diffrence between Snap Shot and Transaction
Replication
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
How do you know if sql server is running on your local system?
Can sub report data source be different from that of the parent report?
What is inner join? Explain with an example?
What are the advantages of paper records?
Give an example of SQL injection attack ?
When is the use of update_statistics command?
Why are you getting errors when creating a new odbc dsn?
How do I port a number to sql server?
What are the different normalization forms?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is bcp? When does it use?
When we should use and scope of @@identity?
How to add more data to the testing table in ms sql server?
Explain trigger classes i.e. Instead of and after trigger?
How to execute stored procedure in select statement sql server?