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
Are semicolons required at the end of sql statements in sql server 2005?
What are difference between Cluster index and Non-Cluster index?
Tell me the phases a transaction has to undergo?
What action plan is preferred if sql server is not responding?
Can you please explain the difference between function and stored procedure?
What is report snapshot?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is normalization and denormalization in sql server?
What is the tcp/ip port on which sql server runs?
what exactly sql injuction.how to overcome.....
What stored procedure would you use to view lock information?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is row_number()?
What are the steps you will take to improve the performance of a poor performing query?
write an SQL query to list the employees who joined in the month of January?