what is the diffrence between Snap Shot and Transaction
Replication
Answers were Sorted based on User's Feedback
Snapshot is the a picture or snapshot of the databse is
taken peridicalloy propgated to the sbuscripber.
it does't invole continuesly.
only read only
transcation replication : This can be used to replication
changes to the database with this any changes made to the
replication data immediately caputred from transcation log
and propogated to the distributor
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / 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 |
What are the differences between local and global temporary tables?
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?
Explain table valued parameters in sql server? Why tvp used?
Can you force a query to use a specific index?
Can we shrink data file in sql server?
What is difference between count (*) and count column?
When we can say that is in BCNF?
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -
Explain the truncate command? : SQL Server Architecture
What is autocommit mode in sql server?
what is difference between Enterprise Manager and Query Analyer